I need to develop a T-SQL insert script for use on a remote SQL 2005 Express instance but I would like the script to include the necessary SQL credentials so all the user has to do is execute the script. What is the easiest way to accomplish this?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
As you describe it, it's not going to work. The T-SQL script needs to run on a SQL Server which means that it needs to be run in an appropriately-authenticated session.
One option would be to write the TSQL script, and then provide it with a VBScript or CMD file or PowerShell script that'll launch the TSQL at the correct server with the right credentials.
Using a batch file and SQLCMD, you can execute the script as below :
Using POWERSHELL, you can use this script from Microsoft Script Center.