CREATE TRIGGER ................. ON ALL SERVER
FOR DDL_EVENTS
AS 
BEGIN
	DECLARE @data XML;
	DECLARE @schema SYSNAME;
	DECLARE @object SYSNAME;
	DECLARE @eventType SYSNAME;
	DECLARE @user SYSNAME;
	DECLARE @mess NVARCHAR(MAX);
	DECLARE @dbname SYSNAME;

	SET @user = SUSER_NAME()
	SET @data = EVENTDATA();
	SET @eventType = @data.value('(/EVENT_INSTANCE/EventType)[1]', 'SYSNAME');
	SET @schema = @data.value('(/EVENT_INSTANCE/SchemaName)[1]', 'SYSNAME');
	SET @object = @data.value('(/EVENT_INSTANCE/ObjectName)[1]', 'SYSNAME'); 
	SET @dbname = @data.value('(/EVENT_INSTANCE/DatabaseName)[1]','SYSNAME');

	SET @mess = 
		'<FONT FACE="Arial"> User = ' + '<B>' + UPPER(CONVERT(SYSNAME, @user)) + '</B>' + ' has done the following DDL operation'
		+ '
'
		+ 'DDL Operation = ' + '<B>' + @eventType + '</B>'
		+ '
'
		+ 'Object = ' + '<B>' + @dbname + '.' + CONVERT(SYSNAME, @schema) + '.' + CONVERT(SYSNAME, @object) + '</B></FONT>';
	
	SELECT @mess
	
	EXECUTE MSDB.DBO.sp_send_dbmail @profile_name = , @recipients = '', @subject = 'Server level change detected', @body = @mess, @body_format = 'HTML'
END