My boss found a table in live data that we can't account for on who created it or what it's for. Barring a security issue & whatever along those lines I'm creating a trigger to fire off if someone alters/drops/creates a table in a database.
As you probably already know I can do this at a database level with no problems. Is there a way to put a trigger at the server level to trip the ALTER_TABLE/DROP_TABLE/CREATE_TABLE when anything is done at the database level? Or will I be stuck putting this trigger on each database?
I know, I know...my subject line is back-a$$-wards. Should be "Database trigger at server level"
JohnSQL Server 200x Newb and proud of it!