Running an SQL Script from a Desktop Icon

[JuliePritchard]

I have SQL Server on a NT Server and I want to put an icon on the desktop so that once clicked on, an SQL script is run - is this easy to do - if so - how would I go about it ??

Thanks for any help

Julie

 

[ColinM]

Look up osql in the SQL server Books Online.
Then you can write a batch file with the right parameters, and create a shortcut to it.
Just don't put the password in the batch file!

 

[JuliePritchard]

Thanks ColinM