Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 system tables

Author  Topic 

Sean_B
Posting Yak Master

111 Posts

Posted - 2007-10-31 : 04:34:10
Hi,

I'm doing an impact analysis to see what views / stored procedures etc are impacted by a change to columns in a table.
I'm using the system tables to identify these changes, and it is something that I'll have to repeat across all our databases in case the tables are being accessed from elsewhere.

I'd like to make sure I'm doing it the right way so could someone point me in the direction of a good article or code for doing this.

thanks

Sean

Sean_B
Posting Yak Master

111 Posts

Posted - 2007-10-31 : 05:06:36
Hi,

just an fyi, I found this article, which looks pretty good.
http://www.select-sql.com/mssql/search-text-in-triggers-and-store-prodedures.html

Sean
Go to Top of Page

Sean_B
Posting Yak Master

111 Posts

Posted - 2007-10-31 : 05:41:18
Hi,

just an fyi, I found this article, which looks pretty good.
http://www.select-sql.com/mssql/search-text-in-triggers-and-store-prodedures.html

Sean
Go to Top of Page
   

- Advertisement -