column datatype changed

• rpatil22

  Ten Centuries

  Points: 1371

  More actions

  January 13, 2011 at 10:43 am

  #388626

  We are planning to change datatype for column (say col1) of table ( say table1)

  Old datatype - int

  new datatype - varchar(10)

  How to identify which store proc will be affected by this column change?

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  January 13, 2011 at 10:58 am

  #1273193

  Try this:

  select distinct o.name, o.type_desc from sys.objects o

  where OBJECT_DEFINITION(o.object_id) like '%col1%'

  order by o.name

  Greg