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 |
|
drokliss
Starting Member
2 Posts |
 Posted - 2001-08-21 : 19:13:42
|
| Here's the situation:We have mutiple copies (about 30) of the exact same database structure, and some of the same stored procedures in each one.We want to put the standard stored procedures in the master db if possible, and have it perform the procedure on whatever the current database happens to be. We tried going "select * from dbname().dbo.table where ID=@blah" but to no avail. Is there a way to tell it to perform on your current db?Drokliss |
|
|
|
|
|
Calling Stored Procedures