Re: Auto alert on database changes

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: oj (nospam_ojngo_at_home.com)
Date: 03/09/04 

Date: Mon, 8 Mar 2004 22:22:39 -0800

Sql2k or below does not support server event. Hence, what you're asking for is
not possible. 

-- 
-oj
http://www.rac4sql.net
"Ed" <eddiemarino@hotmail.com> wrote in message
news:uDmmo4VBEHA.916@tk2msftngp13.phx.gbl...
> Is it possible to set up an alert via e-mail such that if any of the
> developers modifies a stored procedure in a particular database, an e-mail
> will be sent to me (describing which stored proc got modified)?
>
>

Relevant Pages

  • Auto alert on database changes
    ... Is it possible to set up an alert via e-mail such that if any of the ... developers modifies a stored procedure in a particular database, ...
    (microsoft.public.sqlserver.programming)
  • Question
    ... Does this statement applied to SQL2K as well? ... ...when you use the INSERT...EXEC statement to load a ... as the stored procedure itself creates ... legacy code or code you do not control, ...
    (microsoft.public.sqlserver.programming)
  • SP call to DB2/400 linked server
    ... SQL2K to a DB2/400 stored procedure that returns ... recordset, using IBMDA400 as a provider? ...
    (microsoft.public.sqlserver.security)