As putea in sql 2000 sa-mi definesc un eveniment la nivel de server/baza de date in care sa pun codul meu care sa se execute atunci cand eventul are loc?

---

Secolul XXI ori va fi religios ori nu va fi deloc

Puteti folosi SQL Agent Alerts si executa un job ca raspuns la declansarea unei alerte.

Vedeti aceasta pagina din Books Online pentru SQL Server 2000:How to define the response to an alert (Enterprise Manager)

To define the response to an alert

1. Expand a server group, and then expand a server.
   
   
2. Expand Management, and then expand SQL Server Agent.
   
   
3. Click Alerts, and in the details pane, right-click an alert.
   
   
4. Click Properties, and then click the Response tab.
   
   
5. Select the Execute job check box, and then click a job to execute when the alert occurs.

   You can create a new job by clicking (New Job), or modify an existing job by clicking the browse (...) button.

6. Under Operators to notify, select one or more of the following check boxes for one or more operators: E-mail, Pager, or Net send.

   Be sure that each operator's notification method is valid.

7. Select the appropriate Include alert error text in check box for the notification method used if you want the alert error text to be sent with the notification.
   
   
8. Under Additional notification message to send to operator, enter additional information for the operator.

   The maximum number of characters is 512.

precum si pagina Defining Alerts

 

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro