SQL Server Performance Forum – Threads Archive
How to object dropped alert?Hi
I want to known who created, deleted db and table. How to configure alerts for getting these informations? Thanks
AFAIK you may get creation date of DB from master..sysdatabases and for tables query
db..sysobjects you will get creation date and uid but for who deletes the table/db you can use third party tools. Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
Profiler will help you
Madhivanan Failing to plan is Planning to fail
Hi, I hope this is related to SQL 2005. In that case u just do not need any third party tool or Profiler. implement DDL Triggers at DB level and Server Level for these kind of audit. Just refer DDL trigger in BOL.
Ref :http://msdn2.microsoft.com/en-us/library/ms190989.aspx Madhu
As explained you need to depend upon the tools mentioned and system table will only keep the object creation data and not any deletion or modification. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.