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> ~
