SaintCharlesX
24th April 2006 10:45 UTC

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

Jnuw
25th April 2006 04:46 UTC

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

SaintCharlesX
27th April 2006 13:15 UTC

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

blue_harvester
9th May 2006 10:20 UTC

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.

kichik
9th May 2006 13:14 UTC

You can SearchPath for it.