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 |
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 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
 |
|
|
|
|