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 |
|
bubberz
Constraint Violating Yak Guru
289 Posts |
 Posted - 2006-08-07 : 08:56:54
|
| Hello!I have about 15 databases on our instance of SQL Server, a and it's only growing. I'm trying to figure out how to run a stored procedure for each database without having to run it for the first in Query Analyzer, then select from the dropdown list at the top the next db, click "Execute", then select the next name....and so on. Seems like there's gotta be a better way. I'm searching Books Online, and haven't found anything yet.Thanks! |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
bubberz
Constraint Violating Yak Guru
289 Posts |
Posted - 2006-08-07 : 09:15:07
|
| thanks khtan!I'll take a look!I appreciate the help! |
 |
|
|
|
|
|
Add SPROC for each db in SQL Server