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 - 2003-05-01 : 07:10:19
|
| Ashish writes "i am trying to execute the following query through query anaylizer and i get the following errorexec sp_procoption @ProcName = 'sp_test',@OptionName = 'startup',@OptionValue = 'on'error:Only objects in the master database and owned by a member of the sysadmin role can have the setting changed for option startup.i understand the problem but don't know how to solve it" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-05-01 : 07:29:40
|
| Compile sp_test in the Master database adn set the owner of the object to the dbo of Master ...Jay White{0} |
 |
|
|
|
|
|
urgent