HELLO Experts, Can we schedule custom script in SQLDM, if any one doing any operations to that database can we get alert? NS
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
