ho to retrieve a list of dependants
-
Hi All i have a view in sql2005. this view links to several other views and those views may link to other views. how do i get a completed list of dependancies? i have tried to use this but only gives me the 1st level EXEC sp_MSdependencies N'viewname', null, 131527 thanks in advance Anoop
-
Hi All i have a view in sql2005. this view links to several other views and those views may link to other views. how do i get a completed list of dependancies? i have tried to use this but only gives me the 1st level EXEC sp_MSdependencies N'viewname', null, 131527 thanks in advance Anoop
Try this EXEC sp_MSdependencies N'viewname', null, 266751 Hope this helps :)
Niladri Biswas
modified on Tuesday, June 30, 2009 6:08 AM
-
Try this EXEC sp_MSdependencies N'viewname', null, 266751 Hope this helps :)
Niladri Biswas
modified on Tuesday, June 30, 2009 6:08 AM
Hi, nope this returns no data... i am using SQL2005 and have a view that is dependant on several other views. any other suggestions are welcomed... thank you Anoop