.png)
How to: Script Alerts Using Transact-SQL (SQL Server Management Studio)
SQL Server 2005
This topic describes how to generate a Transact-SQL script that creates a Microsoft SQL Server Agent alert.
-
In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
-
Expand SQL Server Agent.
-
Expand Alerts. Right-click an alert, and point to Script Alert as. Select CREATE To or DROP To and click one of the following:
-
New Query Editor Window, which opens a new Query Editor window and writes the Transact-SQL script to it.
-
File, which saves the Transact-SQL script to a file.
-
Clipboard, which saves the Transact-SQL script to the Clipboard.
-
New Query Editor Window, which opens a new Query Editor window and writes the Transact-SQL script to it.
