| http://www.w3.org/ns/prov#value | - Here is a Trigger that I created and currently use on SQL 2005 and 2008.It monitors when someone creates a new DB and emails me the information, including the create statement and the user.Note: it will not work on earlier versions of SQL.CREATE TRIGGER [DDL_CREATE_DATABASE_EVENT]ON ALL SERVERFOR CREATE_DATABASEASDECLARE @bd varchar(max)Declare @tsql varchar(max)Set @tsql = EVENTDATA().value
|
