November 7, 2010 at 12:52 pm
Hello,
I am new to the SQL Server programming. So I am sorry if this is a very naive question.
We create scripts to update our database. This we can do using SQL Server Management Studio easily. But our users, this is too complex task. So the idea is to run the script file from a bat file or NSIS script, so that all the user needs to do is to run a simple file. The DB can be local as well as remote. So we need to create two scripts for each or an intelligent one that with an argument in the command string will know what to do. Any help to get us started on this will be highly appreciated. Thank you.
November 7, 2010 at 5:36 pm
Have a look at SQLCMD in books online !
hmm ... so you're going to have users write your sqlscript and direct upload/update your prod db ??
If that user just needs to run a fixed script, set up and alert and connect that to a sqlagent job which executes your script.
This would minimize the opened security needed and give you as a dba control over the actual job without having to spread it all over your company, risking user modifications.
have a look at http://www.sqlservercentral.com/Forums/Topic403093-370-1.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply