Viewing 3 posts - 1 through 3 (of 3 total)
I just answered my own question!!! thanks I changed the permission on the extended stored procedure on the master database....
I do have one other question though.....if you go to this...
July 13, 2005 at 3:38 pm
Thanks...the following syntax works just fine...
CREATE PROCEDURE dbo.emailgas
AS
EXEC master..xp_sendmail
@recipients = 'brad@rbrsystems.us',
@subject = 'SQL Server - Updated Gas Transaction',
@message = 'This is a test message, at some point the...
July 13, 2005 at 3:34 pm
thanks for your quick response...here is the code
CREATE PROCEDURE emailgas
EXEC xp_sendmail
@recipients = 'brad@domain.com',
@subject = 'SQL Server - Updated Gas Transaction',
@message = 'This is a test message, at some point...
July 13, 2005 at 3:17 pm
Viewing 3 posts - 1 through 3 (of 3 total)