Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234»»

Monitoring Disk Space and Sending Alerts with TSQL Expand / Collapse
Author
Message
Posted Monday, October 1, 2007 7:54 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 1, 2007 9:22 PM
Points: 11, Visits: 4
I am new to SQL2005. I received the following error when execute the SP

-- Msg 15281, Level 16, State 1, Procedure xp_sendmail, Line 1
-- SQL Server blocked access to procedure 'ys.xp_sendmail' of component 'SQL Mail XPs' because this -
-- component is turned off as part of the security configuration for this server. A system administrator -

I check on the Help inside the SQL2005 and it warn us not to use the SQL_Mail but use the Database Mail instead and I have successfully configurated the SMTP database Mail. However, how can I change the SP to use the Database Mail instead of the SQL sendMail

Thanks
Post #405342
Posted Monday, October 1, 2007 7:54 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 1, 2007 9:22 PM
Points: 11, Visits: 4
I am new to SQL2005. I received the following error when execute the SP

-- Msg 15281, Level 16, State 1, Procedure !!!!x!!!!p_sendmail, Line 1
-- SQL Server blocked access to procedure '!!!!y!!!!s.xp_sendmail' of component 'SQL Mail XPs' because this -
-- component is turned off as part of the security configuration for this server. A system administrator -

I check on the Help inside the SQL2005 and it warn us not to use the SQL_Mail but use the Database Mail instead and I have successfully configurated the SMTP database Mail. However, how can I change the SP to use the Database Mail instead of the SQL sendMail

Thanks
Post #405343
Posted Monday, October 1, 2007 7:54 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 1, 2007 9:22 PM
Points: 11, Visits: 4
I am new to SQL2005. I received the following error when execute the SP

I check on the Help inside the SQL2005 and it warn us not to use the SQL_Mail but use the Database Mail instead and I have successfully configurated the SMTP database Mail. However, how can I change the SP to use the Database Mail instead of the SQL sendMail

Thanks
Post #405344
Posted Monday, October 1, 2007 7:55 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 1, 2007 9:22 PM
Points: 11, Visits: 4
I am new to SQL2005. I received the following error when execute the SP

I check on the Help inside the SQL2005 and it warn us not to use the SQL_Mail but use the Database Mail instead and I have successfully configurated the SMTP database Mail. However, how can I change the SP to use the Database Mail instead of the SQL sendMail

Thanks
Post #405345
Posted Monday, October 1, 2007 7:56 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 1, 2007 9:22 PM
Points: 11, Visits: 4
I am new to SQL2005. I received the following error when execute the SP

I check on the Help inside the SQL2005 and it warn us not to use the SQL_Mail but use the Database Mail instead and I have successfully configurated the SMTP database Mail. However, how can I change the SP to use the Database Mail instead of the SQL sendMail

Thanks
Post #405346
Posted Monday, October 1, 2007 7:57 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 1, 2007 9:22 PM
Points: 11, Visits: 4
I am new to SQL2005. I received the following error when execute the SP

I check on the Help inside the SQL2005 and it warn us not to use the SQL_Mail but use the Database Mail instead and I have successfully configurated the SMTP database Mail. However, how can I change the SP to use the Database Mail instead of the SQL sendMail

Thanks
Post #405347
Posted Monday, November 5, 2007 6:01 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 1:22 PM
Points: 68, Visits: 631
For anyone else who needs to modify the script to use SQL 2005 dbmail just change (assuming db mail is correctly set up already)....

EXEC master..xp_sendmail @recipients = 'email@domain.com',
@subject = @MailSubject,
@message = @AlertMessage
to
EXEC msdb..sp_send_dbmail @recipients = 'email@domain.com',
@subject = @MailSubject,
@body = @AlertMessage
Post #418498
Posted Tuesday, April 1, 2008 2:25 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, November 7, 2014 6:03 PM
Points: 538, Visits: 1,929
hello, thank you for your script, question how can i run with my other servers?
Post #478058
Posted Monday, April 14, 2008 9:35 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, November 7, 2014 6:03 PM
Points: 538, Visits: 1,929
hi how can i edit this sp so i get also the percentage? and modify the alert if i have less than 10%?
Post #484487
Posted Thursday, April 17, 2008 4:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 6, 2011 4:09 AM
Points: 4, Visits: 13
I've read the helpful comments here.
i am using it in a similar way.
but how can i read the sizes of mount points?
thanks for your help!
cheers
daniel
Post #486270
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse