SQL Server Performance


Discussion in 'General DBA Questions' started by snarayanas, Jan 31, 2006.

  1. snarayanas New Member

    HELLO Experts,

    Can we schedule custom script in SQLDM, if any one doing any operations to that database can we get alert?

  2. Chappy New Member

    What do you mean by operations?

    I think the short answer is no, this isnt really possible. Your script could detect connections, and maybe even grab the most recent sql command (DBCC INPUTBUFFER), but it would be unreliable. Also profiler can run a trace, but its entirely reactive and wouldnt provide realtime alerts

    Im guessing you wanted to monitor admin connections to detect schema changes ?

    Not 100% sure but I think sql 2005 may provide some mechanisms for this

Share This Page