could not find stored procedure xp_sendmail 1

[collierd]

Hello

I am using SQL Server 2000

Does anybody know why the following query returns 'Could not find stored procedure xp_sendmail ?

exec xp_sendmail
   @recipients = 'collierd',
   @message = 'area translation failure on',
   @subject = 'area translation failure on'

Thanks

Damian.

 

[r937]

you might try forum183 (the microsoft sql/server forum)


rudy

 

[fluteplr]

xp_sendmail like all extended stored procs only exists in the master database.

So

exec master..xp_sendmail
@recipients = 'collierd',
@message = 'area translation failure on',
@subject = 'area translation failure on'

or

exec master.dbo.xp_sendmail
@recipients = 'collierd',
@message = 'area translation failure on',
@subject = 'area translation failure on'

 

[collierd]

Thanks fluteplr
Works fine