Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-25 : 11:43:25
|
| Oli writes "I am trying to write a stored procedure the will email a file. The SQL Mail extended procedures; xp_startmail, xp_sendmail, xp_stopmail , etc, appear to be available ONLY on the master database, i.e. If I run the following via SQL Query Anlaylzer on Northwind database;exec xp_sendmail @recipients = 'mymail@address', @subject='test subject', @message = 'test message'The follwoing error is returned;Server: Msg 2812, Level 16, State 62, Line 1Could not find stored procedure 'xp_sendmail'.If I run on master database, it's ok! Sureley xp_* procedures are not restricted/limited to the master database? So how do I get this to work?Many thanks. " |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-04-25 : 12:44:09
|
| try something like this....exec master.dbo.xp_sendmail @recipients = 'mymail@address' , @subject='test subject' , @message = 'test message' Paul |
 |
|
|
|
|
|
SQL Mail extended procedures can only run on master?