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.
Cheers
Regards
Parasu Raman
Regards
Parasu Raman
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!
Andy
October 22, 2001 at 5:17 am
Thanx andy,
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
Regards
Parasu Raman
Regards
Parasu Raman
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.
Andy
October 22, 2001 at 6:34 am
Thanx Andy
Regards
Parasu Raman
Regards
Parasu Raman
October 22, 2001 at 10:04 am
There is a script here that will do this.
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=90
Also another:
Steve Jones
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply