Verification Prompt Before User Runs SQL Script

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

Verification Prompt Before User Runs SQL Script

Author

Topic

BRishel
Starting Member

5 Posts

Posted - 2008-12-22 : 13:27:06

Hello,

I am creating a script to make updates to our database in the event of a Disaster Recovery. I have already completed the core Update commands.

What I am looking for is a command that I can put at the top of the script that will run and prompt the user to put in a password or the current date before it makes any changes to the records.

I want to put this in with the script so that it does not get ran accidentally and make changes to our working production environment.

Any help is greatly appreciated.

Bryan Rishel
Jackson, Michigan

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-22 : 13:57:23

That isn't possible through the SQL Server tools. You will need to write an application to do this and then call the script in that app.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

BRishel
Starting Member

5 Posts

Posted - 2008-12-22 : 14:40:55

Thank you again Tara for your quick response.

Bryan Rishel
Jackson, Michigan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources