|
|
|
Author |
Message |
wwilliam
|
Posted: 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
|
Posted: 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
|
|
|
|
|
|
|