InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 08:25:55 GMT20http://www.sqlservercentral.com/Forums/Topic743354-1291-1.aspx[quote][b]John Mitchell-245523 (7/9/2009)[/b][hr]Have you looked at DDL triggers? As far as I know, you can create a trigger that will fire when a DDL event (such as creation of a database) occurs, and have that trigger send the e-mail. That way, you get your notification immediately and don't have to wait until the next morning.John[/quote]This could be a very late reply. Sending e-mails from DDL Triggers (or for that reason any trigger) could give some misleading error messages like incorrect "mail profile names" or "Databasemail XP warnings" when creating a new database/table.Wed, 08 May 2013 22:07:48 GMTMohammed Imran Alihttp://www.sqlservercentral.com/Forums/Topic743354-1291-1.aspxonly Thing about using triggers, is the fact you can take a hit on the performance. It just depends on the Transaction you are monitoring, something like creating new databases should not happen to often so it may not be a major issue. You might consider using SCOM, SQL DM, or any of the SQL monitoring tools. :-)Tue, 14 Feb 2012 07:37:55 GMTKevi322000http://www.sqlservercentral.com/Forums/Topic743354-1291-1.aspxHave you looked at DDL triggers? As far as I know, you can create a trigger that will fire when a DDL event (such as creation of a database) occurs, and have that trigger send the e-mail. That way, you get your notification immediately and don't have to wait until the next morning.JohnThu, 09 Jul 2009 04:39:21 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic743354-1291-1.aspx[quote][b]hi_abhay78 (7/6/2009)[/b][hr]As per this MSDN , yes its not supported .http://msdn.microsoft.com/en-us/library/ms165636(SQL.90).aspxBut there is a tweak :) Copy DatabaseMail90.exe, DatabaseMailEngine.dll and DatabaseMailProtocols.dll into the MSSQL\Binn directory and execute below mentioned system SPs (in MSDB context)dbo.sysmail_start_spdbo.sysmail_stop_sp You are done .Actually these 3 files you need to copy from ENT edition or STD edition.Regards[/quote]And probably not legal either unless those files are part of a redistibutable package. Which means if you have any problems you won't get any support from Microsoft.Mon, 06 Jul 2009 22:09:30 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic743354-1291-1.aspxAs per this MSDN , yes its not supported .http://msdn.microsoft.com/en-us/library/ms165636(SQL.90).aspxBut there is a tweak :) Copy DatabaseMail90.exe, DatabaseMailEngine.dll and DatabaseMailProtocols.dll into the MSSQL\Binn directory and execute below mentioned system SPs (in MSDB context)dbo.sysmail_start_spdbo.sysmail_stop_sp You are done .Actually these 3 files you need to copy from ENT edition or STD edition.RegardsMon, 06 Jul 2009 21:31:36 GMThi_abhay78http://www.sqlservercentral.com/Forums/Topic743354-1291-1.aspxDatabase Mail is not supported in the Express Edition, nor is SQL Server Agent.Mon, 06 Jul 2009 20:30:33 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic743354-1291-1.aspxI have never tried creating the database mail profiles and accounts through Express .But for jobs you need SQL Agent .Normal Express does nto have express agent with it .you need to install advanced tools for SQL Express .After that it should work .I am confident that database mail is suported in Express as well ..RegardsMon, 29 Jun 2009 00:12:46 GMThi_abhay78http://www.sqlservercentral.com/Forums/Topic743354-1291-1.aspxIs this possible in express edition.Mon, 29 Jun 2009 00:03:21 GMTEswinhttp://www.sqlservercentral.com/Forums/Topic743354-1291-1.aspxYou can create an SP using xp_sendmail .Finally create a job that executes daily before you come to office and send you the mail .In xp_sendmail you can use the query :select * from sys.databases where datediff(day,create_date ,getdate()) <=1For backups you can configure alerts or just add the same step mentioned above with message "backup on server XXXX failed" as a step in case the backup fails in the job .RegardsSun, 28 Jun 2009 23:51:17 GMThi_abhay78http://www.sqlservercentral.com/Forums/Topic743354-1291-1.aspxHI ExpertzCan anyone please tell me how to create an alert (send mail) when a new database is created and also for Backup and Restore operations in your server.Sun, 28 Jun 2009 23:08:34 GMTEswin