I need some help and advise. I am trying to create a database in the background when installed. I have the SQL script and I think SQLCMD is the way to go. I have downloaded SQLCMD and installed it in the following directory:
C:\Program Files\Microsoft SQL Server\80\Tools\Binn
however when I double click on the file it appears and then disappear again. Even though I want to run my SQL script on a batch type process, is this the correct path for it to be installed? and also is this the best way to do my task. I do not really want to write a .exe to do this task when MS provide apps. to do it for me.
Thanks in advance
Simon
C:\Program Files\Microsoft SQL Server\80\Tools\Binn
however when I double click on the file it appears and then disappear again. Even though I want to run my SQL script on a batch type process, is this the correct path for it to be installed? and also is this the best way to do my task. I do not really want to write a .exe to do this task when MS provide apps. to do it for me.
Thanks in advance
Simon
