InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 11:38:10 GMT20http://www.sqlservercentral.com/Forums/Topic1429825-146-1.aspxThanks to your ideaWed, 13 Mar 2013 05:08:39 GMTIvan Mohapatrahttp://www.sqlservercentral.com/Forums/Topic1429825-146-1.aspxok, I see. Glad you sorted that.Wed, 13 Mar 2013 05:06:06 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic1429825-146-1.aspxevery thing is working fine i created alert after i posted this and it is working fine....Wed, 13 Mar 2013 05:00:19 GMTIvan Mohapatrahttp://www.sqlservercentral.com/Forums/Topic1429825-146-1.aspxso you have a sqlagent alert but its not working?Wed, 13 Mar 2013 04:52:46 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic1429825-146-1.aspxalready done that !!Tue, 12 Mar 2013 22:42:22 GMTIvan Mohapatrahttp://www.sqlservercentral.com/Forums/Topic1429825-146-1.aspxif you have DBMail and an operator setup, then it's simple since 1105 is a logged error:[code="sql"]USE MSDBEXEC sp_add_alert @name = 'Error 1105: Filegroup Full', @message_id=1105, @Severity=0, @enabled=1, @delay_between_responses=900, @include_event_description_in=1EXEC sp_add_notification @alert_name = 'Error 1105: Filegroup Full', @operator_name='youroperatorname', @notification_method = 1[/code]you'll get an e-mail like this:[code="plain"]DATE/TIME: 3/12/2013 2:43:26 PMDESCRIPTION: Could not allocate space for object 'dbo.bogus' in database 'trying' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.[/code]Tue, 12 Mar 2013 12:48:20 GMTChris Harshmanhttp://www.sqlservercentral.com/Forums/Topic1429825-146-1.aspxthanks for the idea where i can get but this is what i need to monitor Error: 1105, Severity: 17Tue, 12 Mar 2013 12:12:16 GMTIvan Mohapatrahttp://www.sqlservercentral.com/Forums/Topic1429825-146-1.aspxwill that for primary file group or t log file group or for all ?Tue, 12 Mar 2013 11:27:08 GMTIvan Mohapatrahttp://www.sqlservercentral.com/Forums/Topic1429825-146-1.aspxset up an alert in SQLAgent to monitor for 9002 errorsTue, 12 Mar 2013 10:39:53 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic1429825-146-1.aspxhi guys, is there any ways to have a automatic alert when primary file group is full in Sql server for any of the database in Sql server 2005.Tue, 12 Mar 2013 07:58:30 GMTIvan Mohapatra