> Hey guys,
>   Does anyone know any available tool which can be used to view the
> impact on database and stored procs when some changes have been made
> on the database. For example, changing the name of a column in a
> table, changing the data type of a column from uniqueidentifier to 34-
> byte int, changing the datetime to smalldatetime, changing the
> decimal(10, 2) to decimal(9, 2). As a lot of already written stored
> procs are using these columns, so before making those changes, I need
> to use some tools to view how much impact will be made on database and
> stored proces beforehand from all those possible changes.
>  If anyone can provide suggestions on it, I really appreciate it.
> Thanks a lot.
>

"Darwin fisk" <dar***@dotnetdesigns.com> wrote in message
news:Omt40o8$HHA.4612@TK2MSFTNGP03.phx.gbl...
> If you are just looking for the list of stored procs you would need to
> revise you can use the following query in the database you are modifying:
>
> SELECT Name FROM SysObjects WHERE [ID] IN
> (SELECT [ID] FROM SysComments WHERE Text Like
> '%NameOfColumnOrTableYouAreChanging%')
>
> Hope this helps,
> Darwin Fisk
>
> chenyuxue1***@gmail.com wrote:
>> Hey guys,
>>   Does anyone know any available tool which can be used to view the
>> impact on database and stored procs when some changes have been made
>> on the database. For example, changing the name of a column in a
>> table, changing the data type of a column from uniqueidentifier to 34-
>> byte int, changing the datetime to smalldatetime, changing the
>> decimal(10, 2) to decimal(9, 2). As a lot of already written stored
>> procs are using these columns, so before making those changes, I need
>> to use some tools to view how much impact will be made on database and
>> stored proces beforehand from all those possible changes.
>>  If anyone can provide suggestions on it, I really appreciate it.
>> Thanks a lot.
>>