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 |
|
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
 Posted - 2010-11-08 : 00:46:08
|
| Hi,When i try to execute sp_send_dbmail in another stored procedure. its giving following error . can any one tel how to over come.Problem With UpdateThe EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo'. |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-11-08 : 01:04:32
|
| The message clearly indicate the login used by you doesn't have sufficient permissions.Can you tell us what are the permissions / roles you have for the login id ? |
 |
|
|
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
Posted - 2010-11-08 : 01:19:28
|
| i hav given all permission , execute, alter etc |
|
|
|
|
|
|
sp_send_dbmail