system stored procedure  
Author Message
wwilliam





PostPosted: Thu Jul 10 15:39:44 CDT 2003 Top

SQL Server Developer >> system stored procedure

I know I'm going to sound like an idiot, but I have to ask
anyway ...

I am trying to use a system stored procedure
(xp_sendmail) - I am trying to see if I have things
configured properly for SQL Mail.

When I go to execture the sp:


@subject = 'Testing SQL Mail'

I get an error:

Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'xp_sendmail'.

I know I'm just forgetting something, but I'm not sure
what it is.

Anyone want to help out this newbie?

TIA,
Adria

SQL Server53  
 
 
Dinesh





PostPosted: Thu Jul 10 15:39:44 CDT 2003 Top

SQL Server Developer >> system stored procedure Adria,

Use this..

exec master..xp_sendmail

--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com



> I know I'm going to sound like an idiot, but I have to ask
> anyway ...
>
> I am trying to use a system stored procedure
> (xp_sendmail) - I am trying to see if I have things
> configured properly for SQL Mail.
>
> When I go to execture the sp:
>


>
> I get an error:
>
> Server: Msg 2812, Level 16, State 62, Line 1
> Could not find stored procedure 'xp_sendmail'.
>
> I know I'm just forgetting something, but I'm not sure
> what it is.
>
> Anyone want to help out this newbie?
>
> TIA,
> Adria