Alert in Email !!!
Dear Professional,
I am using one extended stored procedure to send email from SQL Server. Now
the question is how can I email my self from SQL Server if CPU usage greater
than 30% or available memory greater than specific value,
Can any body guide me regarding that?
Thanks
.
Relevant Pages
- Re: Extended Stored Procedure: Loopback connection
... SQL Server ships a sample exactly showing this: ... SQLRETURN sret, ... SRV_PROC* srvproc); ... NULL, 0, 0, "Error executing extended stored procedure: ...
(microsoft.public.sqlserver.odbc) - Extended Stored Procedure: is there a small memory leak in srv_paraminfo??
... I called my own extended stored procedure 1000 times to make sure there was ... no memory leak but the sqlservr.exe memory usage went up so i thought there ... might be a memory leak. ... w/ a sample extended stored procedure that comes on the SQL Server 2000 CD ...
(microsoft.public.vc.database) - There seems to be a memory leak in srv_paraminfo
... I called my own extended stored procedure 1000 times to make sure there was ... no memory leak but the sqlservr.exe memory usage went up so i thought there ... might be a memory leak. ... w/ a sample extended stored procedure that comes on the SQL Server 2000 CD ...
(microsoft.public.sqlserver.programming) - Re: Implementation of full text
... There is no documented way of accessing the MSSearch catalogs directly other ... tables in SQL Server to identify the row the hit occurs in. ... table to a client from an extended stored procedure. ... To use the recordset returned from the ESP as a virtual table>. ...
(microsoft.public.sqlserver.fulltext) - Re: sql server events on data create
... If I were to do this, I would set up the client to listen on a socket, write ... an extended stored procedure that can trigger this socket, ... triggers on the tables of interest to call this extended stored procedure, ... Or you could start a custom SQL Server trace event with the right filters? ...
(microsoft.public.sqlserver.programming) |
|
