vb script to query sql server? Simon G 6/8/2007 2:48:05 PM This may not be in the right forum, but... I've got a nice little sql script which works fine, it has one variable which i change quite frequently. Is it possible to have a vb script display me with a prompt box, i enter the new variable, it then puts that into my already working sql script and queries the sql server and then simply returns the results? preferably as a csv file?

Re: vb script to query sql server? "CreateWindow" <createwindow[ at ]gmail.com> 6/9/2007 1:30:10 AM Hi Simon, You just need an input box. Dim NewVar NewVar = InputBox("Enter a new variable.") If NewVar = "" Then Wscript.Echo("No variable entered - exiting...") Wscript.Quit End If ' Now just use NewVar in your script. For reading in a csv file use the "Scripting.FileSystemObject". http://www.microsoft.com/technet/scriptcenter/scripts/logs/text/lgtxvb01.mspx Is a sample of that for a DHCP log. CreateWindow http://justpageprobe.com The FREE Web page utility you always wanted. Monitor your enterprise Web Servers. Keep your router connected. Email your IP to where you need it. "Simon G" <SimonG[ at ]discussions.microsoft.com> wrote in message news:C4791E1E-23BE-4CB3-BA6A-816FDC5292DA[ at ]microsoft.com... [Quoted Text] > This may not be in the right forum, but... > > I've got a nice little sql script which works fine, it has one variable > which i change quite frequently. > > Is it possible to have a vb script display me with a prompt box, i enter > the > new variable, it then puts that into my already working sql script and > queries the sql server and then simply returns the results? preferably as > a > csv file? > >