Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_server_dba
Posting Yak Master
167 Posts |
 Posted - 2010-08-27 : 11:48:45
|
| Hi, Need small help here. I have a simple SELECT statement( SELECT A, B, C, D FROM XYZ LEFT JOIN PQR ....). As per the data, this should not return any resultset, but if this returns any resultset then i need to set some alert. Is it possible to add those values in EVENT VIEWER? If Yes, then how can we do it? IF NOT, how can i setup this alert so that the alert will have those records.Thanks in Advance. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-27 : 11:59:56
|
| see RAISERROR in BOL.basically, you raise an error, then create an alert for that error to write it the event log |
 |
|
|
sql_server_dba
Posting Yak Master
167 Posts |
Posted - 2010-08-27 : 12:37:29
|
| Yeah, i am trying the same...but no luck, i tried to send an e-mail and i guess it should automatically written to Event log. but its not doing any of them.... |
|
|
|
|
|
|
Help needed to set up an alert.