Specific databases or all databases on the server? Can you shoot me over the code you have now?
- Andy O. >-----Original Message----- >From: Joseph L. Casale [mailto:[EMAIL PROTECTED] >Sent: Friday, February 29, 2008 1:47 PM >To: NT System Admin Issues >Subject: RE: SQL Scripting Help > >Andy, >From the help of another member, I have some code that backs up the db's >and logs. Given there is a long list of db's to run through this code, I >hoped I could iterate a list of db's (easier to maintain) through my code. > >Thanks for the interest! >jlc > >> -----Original Message----- >> From: Andy Ognenoff [mailto:[EMAIL PROTECTED] >> Sent: Friday, February 29, 2008 12:40 PM >> To: NT System Admin Issues >> Subject: RE: SQL Scripting Help >> >> Can you explain a little more what you are actually trying to >> accomplish? >> >> It seems like you’re trying to do something that might be more >> appropriate in a procedural scripting language like VBScript, rather >> than SQL (which is set based.) Or perhaps use VBScript as a wrapper to >> do the iterations and call your SQL commands from it. >> >> - Andy O. >> ________________________________________ >> From: Joseph L. Casale [mailto:[EMAIL PROTECTED] >> Sent: Friday, February 29, 2008 12:09 PM >> To: NT System Admin Issues >> Subject: RE: SQL Scripting Help >> >> Thanks for the pointer Michael. >> If I have a comma separated list of values (I can change that format if >> it makes this easier), how do I iterate through each element pushing it >> into a variable? >> >> Thanks guys, >> jlc >> >> From: Michael B. Smith [mailto:[EMAIL PROTECTED] >> Sent: Friday, February 29, 2008 5:28 AM >> To: NT System Admin Issues >> Subject: RE: SQL Scripting Help >> >> Stored procedure. >> >> ☺ >> >> Regards, >> >> Michael B. Smith >> MCSE/Exchange MVP >> http://TheEssentialExchange.com >> >> From: Joseph L. Casale [mailto:[EMAIL PROTECTED] >> Sent: Friday, February 29, 2008 1:49 AM >> To: NT System Admin Issues >> Subject: SQL Scripting Help >> >> I have a series of commands I would like to loop through with a list of >> db names. Obviously it’s much easier to keep a list up to date and >> organized, then whole bunch of repetitive sets of commands. I can’t >> seem to be able to Google what I am looking for. Anyone got an idea to >> push me along? >> >> Thanks, >> jlc >> >> >> >> >> >> >> >> >> ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ >> ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~ > >~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ >~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~ ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
