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 |
|
missMac
Posting Yak Master
124 Posts |
 Posted - 2008-10-15 : 08:00:13
|
| Hello,I tried addinggrant exec sp_sendMailMessage to public;gobut i get an errorMsg 102, Level 15, State 1, Line 1Incorrect syntax near 'sp_sendMailMessage'. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-15 : 08:10:27
|
Where is the ON keyword?grant exec on sp_sendMailMessage to public;Took me about 10 seconds to find out with Books Online.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
missMac
Posting Yak Master
124 Posts |
Posted - 2008-10-15 : 08:26:55
|
10 Seconds ??? You must be the fastest online, transaction, multi- browsing human RDBMS  Thanks Peso |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-15 : 08:39:12
|
you're welcome!don't hesitate to ask again.Type GRANT in query window : 2 secondshightlight the text and press shift f1 : 1 secondwait for books online to start : 2 secondsread the text : 5 seconds
E 12°55'05.63"N 56°04'39.26" |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-15 : 10:11:15
|
What is that ?Peso:Peformance monitor ?  |
|
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2008-10-15 : 11:00:49
|
quote:
Originally posted by PesoType GRANT in query window : 2 secondshightlight the text and press shift f1 : 1 secondwait for books online to start : 2 secondsread the text : 5 seconds
you could have saved .5 seconds here, you don't need to highlight. |
|
|
|
|
|
|
HOw do i add exec permissions to an MSDB sp ?