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.
| Author |
Topic |
|
lionofdezert
Aged Yak Warrior
885 Posts |
 Posted - 2008-12-03 : 04:41:04
|
| I have table, which structure is changed by changing a column name, i need to list out all those sp, view and functions which become invalid due to this change.HOW ??? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-03 : 04:45:35
|
Have a look at the sysdepends table.SELECT *FROM sys.sysdepends
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2008-12-03 : 04:50:56
|
| Thanx for your quick response, Peso.But sys.sysdepends system table only store informtion about which object depends on which object. But what if i have two store procedures one has all three columns, that are in my changed table but other one has only two columns and changed column is missing. sysdepends will return both of my sps but i want only first. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-03 : 09:33:12
|
| http://msdn.microsoft.com/en-us/library/ms189487.aspx |
|
|
|
|
|
|
Procedures and Functions Invalidity