Run a SQL Statement with NSIS
Does anyone know if it's possible to run a small SQL script (with a shell command or by other means) from within NSIS?
The statements that I want to run are:
sp_attach_db 'Tagprod', 'D:\MSSQL7\Data\Tagprod_data.mdf', 'D:\MSSQL7\Data\Tagprod_log.ldf'
***Then***
sp_dropuser TAG1
go
sp_dropuser administrator
go
sp_droplogin TAG1
go
sp_droplogin administrator
go
sp_droplogin Q
go
sp_addgroup Quantum
go
sp_addlogin 'administrator', 'password'
go
sp_adduser administrator,administrator,Quantum
go
sp_addlogin 'TAG1', 'WLV818'
go
sp_adduser TAG1,TAG1,Quantum
go
sp_addlogin 'Q', 'QAdmin'
go
sp_grantdbaccess 'Q', 'Q'
go
sp_addrolemember 'db_owner', 'Q'
go
/**************************************************
All Application users
***************************************************/
sp_dropuser example
go
sp_addlogin 'example', 'password'
go
sp_adduser example,example,Quantum
go