When dropping any object in Prod environment

Tools & Utilities

When dropping any object in Prod environment

When dropping any object in Prod environment through SQL Assistant, it is not asking for confirmation message. Does any one have infomation regarding same.

Recently one of my colleague was dropped production object my mistake. As he thought he was dropping backup version of that object.

 

Is any one have any workaround to avoid such things in prod environment.

Tags (1)
3 REPLIES
Junior Contributor

Re: When dropping any object in Prod environment

SQL Assistant never asks for confirmation, regardless of prod or dev, it simply submits your SQL statement :-)

 


Is any one have any workaround to avoid such things in prod environment. 

  • Don't grant drop rights on important objects
  • Double check before you press F5
  • Know what you're doing
  • Don't run DML/DDL against production tables in interactive mode
  • F6 before F5

Re: When dropping any object in Prod environment

Thank you 

 

Junior Contributor

Re: When dropping any object in Prod environment

There's no way to get a pop-up-message using SQL/Macro/SP.

 

You couldn't do it in SQL Assistant, but Studio will ask Are you sure you want to drop table "**bleep**"?

 

Similar yould be done in a shell script running BTEQ, but what's the difference between thinking/explaining before you submit and clicking "yes" in a Windows environment where you get Confirm dialogs all the time (and who is actually reading those?)