Hey Carpal, I got it to work. Look at the changes I made below.

Alter TRIGGER [ddl_trig_database]

ON ALL SERVER

FOR CREATE_DATABASE

AS

declare @results varchar(max)

SET @results = (SELECT EVENTDATA().value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]','nvarchar(max)'))

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Default',

@recipients = 'me@home.com',

@body...

Thanks Carpal but the email still doesn't include the select statement. Any ideas? I'm running SQL 2008 R2.

Thank you! That helped a lot

I would like the users to be able to see all SQL jobs but prevent them from creating user accounts.

Even though a add the users to the SQLAgentOperator role...