在刪除sql server management studio之前顯示警報 - Display alert before delete sql server management studio -开发者知识库

在刪除sql server management studio之前顯示警報 - Display alert before delete sql server management studio -开发者知识库,第1张

I am using SQL server 2008 and we do have access to prod database . Currently while executing queries particularly DDL I always check which server it's pointing to but sometimes I may go careless and things may go wrong, so how to automate that?

我正在使用SQL server 2008,我們確實可以訪問prod數據庫。目前,在執行查詢(尤其是DDL)時,我總是檢查它指向哪個服務器,但有時可能會出錯,因此如何自動執行呢?

Is't possible to display the alert before performing delete or update operation in SQL server management studio ?

在SQL server management studio中執行刪除或更新操作之前,是否不能顯示警報?

Or avoid DDL execution when connected to prod server?

或者在連接到prod服務器時避免DDL執行?

Example : when you send mail without subject in outlook it will alert you similar type of setting

當你在outlook中發送沒有主題的郵件時,它會提醒你類似的設置

1 个解决方案

#1


4  

I have developed SSMSBoost add-in for SSMS and there is a feature there allowing to declare some database as "Important". In this case you will see additional warning when you switch to this database. In next releases we plan to add some further restrictions, like "no DML statements" or "no DML statements without WHERE"

我已經為SSMS開發了SSMSBoost外接程序,其中有一個特性允許將某些數據庫聲明為“重要的”。在這種情況下,當您切換到這個數據庫時,您將看到附加的警告。在下一個版本中,我們計划添加一些進一步的限制,如“無DML語句”或“無WHERE的無DML語句”

Feature description can be found here: http://www.ssmsboost.com/Features/ssms-add-in-preferred-connections

特征描述可以在這里找到:http://www.ssmsboost.com/features/ssms-add -in- preferredconnections。

在刪除sql server management studio之前顯示警報 - Display alert before delete sql server management studio -开发者知识库,enter image description here,第2张

最佳答案:

本文经用户投稿或网站收集转载,如有侵权请联系本站。

发表评论

0条回复