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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Is there a way to find certain SPs calls a certain

Author  Topic 

NguyenL71
Posting Yak Master

228 Posts

Posted - 2008-11-12 : 18:08:47
I have over 100 databases on ProdServer and wonder is there a way to certain SPs calls a certain db. SQL 2000.

Thanks in advance.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-11-12 : 18:28:08
use 3 part naming convention:
exec dbname.ownername.sprocname

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.1 out!
Go to Top of Page
   

- Advertisement -