Sql

Hi everyone,
does anybody here know how can I use NSIS scripts in creating and manipulating tables in my SQL Server 2000?
Thanks

I looked into this a while back, and the best I could put together was to use OSQL.exe. If your not familiar with this exe, it is a utility that comes with MS SQL, and allows you to do most things you can do with Enterprise Manager. It is redistributable per http://download.microsoft.com/downlo...SDE_redist.txt . I think you have to also sign up with MS officially before you can send that file out (google: osql.exe redistributable)

At any rate, once you have that file out, you could run a batch file, or use the ExecDos plug in to issue commands to OSQL.EXE (http://nsis.sourceforge.net/ExecDos_plug-in)

Hope this helps. Good luck.
- Jnuw

Thanks Master Jnuw, thats a big help. I'll let you know if i am able to run it. but i think i need to study osql.exe...

rock on!
-SaintCharlesX

I was just wondering if there was a way to check if the OSQL.exe tool is on the current system before attempting run the batch file? I.e. is it available for useage with batch files.

You can SearchPath for it.