August 22, 2008 at 2:33 pm
Hi,
I have one table in central repository that contains all sql servers(available for me to work upon) names along with their sa passwords(i know its a bad practice).
I need one vb script which can connect to these servers one by one by picking up the credential from this table and fire one sql query against it. If you have any such script please share it with me.
Thanks in advance,
MJ
August 22, 2008 at 2:56 pm
Wouldn't DTS be a better option? Seems somewhat security risky all the way around and putting a lot of work into a VBScript which there are utilities to do. Just my thought.
If you really feel compelled to do the VBScript solution then a great series of articles to read from Andy Warren can be found here - http://www.sqlservercentral.com/articles/Performance+Tuning/introductiontoadopart4combiningitall/537/ - this is where I got my start in this area.
You could / should also visit http://www.microsoft.com/technet/scriptcenter/scripts/default.mspx?mfr=true which is the Scripting Guys repository for Microsoft. Great stuff and you may find something that will do the job for you.
Ultimately though you really should consider using DTS.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply