Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Mirrorball
-
Re-run a query isn Query Analyser
Thanks for your help on my first query. It wasn't actually a stored procedure but a script in the query analyser window. The script is to update 40 identical databases. I can use the USE command to change databases but once I've done that I want to be able to re-run the script in the window...- Mirrorball
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Change database within a stored procedure
I have an update stored procedure which needs to be run over 40 identical databases on the same server. Is it possible to include a command in the update stored procedure to change from one database to another? Thanks for your help- Mirrorball
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
