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 |
|
incxbxs
Starting Member
7 Posts |
 Posted - 2010-12-24 : 05:08:07
|
| deleted. |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-12-24 : 05:20:30
|
| Try :EXECUTE master..sp_send_dbmail |
 |
|
|
incxbxs
Starting Member
7 Posts |
Posted - 2010-12-24 : 05:54:52
|
quote:
Originally posted by pk_bohra
Try :EXECUTE master..sp_send_dbmail
nope, same error: The module 'InitialProjectNotification' depends on the missing object 'master..sp_send_dbmail'. The module will still be created; however, it cannot run successfully until the object exists.but this time master..sp_send_dbmail object missing. |
|
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-12-24 : 06:13:02
|
| My mistake:sp_send_dbmail doesnot exist in master but exist in msdb.Try:EXECUTE msdb.dbo.sp_send_dbmailRegards,Bohra |
|
|
|
incxbxs
Starting Member
7 Posts |
Posted - 2010-12-24 : 08:04:33
|
| It works now! Thank you very much ! |
|
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-12-24 : 08:20:29
|
quote:
Originally posted by incxbxs
It works now! Thank you very much !
You are welcome  |
|
|
|
|
|
|
HELP!! missing object 'sp_send_dbmail'