I want to change one column data type from sql table how to

Question

I want to change the column datatype from sql server  now i want to check all the references where it is used in the code  is there any tool avaialble to check where my that column is used either in stored procedure or in vb.net code.

Gowtham K · Answer

Hi Mark Check this http://blog.sqlauthority.com/2012/07/19/sql-server-find-column-used-in-stored-procedure-search-stored-procedure-for-column-name-part-2/

Nirav Daraniya · Answer

Hi Mark You can you below Query for find the all the store procedure in which you column is used SELECT Name FROM sys.procedures WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%YourCulomnName%'