sql-server - SQL Server : catch every error within a database into error table

Question

我想知道如何以某种方式钩住SQL Server中的某个数据库，使所引发的每个错误(没有人捕获)都将被捕获并保存到数据库的error_table中。谢谢。

Answer 1

您可以设置警报来执行以下操作:使用错误号创建警报

In Object Explorer, click the plus sign to expand the server where you want to create an alert using an error number.

Click the plus sign to expand SQL Server Agent.

Right-click Alerts and select New Alert.

In the New Alert dialog box, in the Name box, enter a name for this alert.
Check the Enable check box to enable the alert to run. By default, Enable is checked.

In the Type list, select SQL Server event alert.

Under Event alert definition, in the Database name list, select a database to restrict the alert to a specific database.

Under Alerts will be raised based on, Click Severity and then select the specific severity that will raise the alert.
You can add a job step to write to a table with the information from the alert.