October 22, 2001 at 4:04 am
How do I loop through all the databases in my server?
I might need this when I want to backup all the databases using TSQL
And also, kindly tell some good sites for tsql.
October 22, 2001 at 5:08 am
You need a cursor. sp_msforeachdb provides a shortcut to this. What kind of TSQL, you looking for scripts or for help with a specific problem? I'd hate to think we can't help you here!
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter
October 22, 2001 at 5:17 am
Im trying to do a full tsql script for doing backup for all the dbs in my server.
Can u help me with this regards
October 22, 2001 at 5:50 am
I will forward this request to TSQL MAN himself, Steve Jones...Steve? I use DMO for stuff like this mostly.
October 22, 2001 at 6:34 am
Steve Jones - SSC Editor
October 22, 2001 at 10:04 am
There is a script here that will do this.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply