ERROR
Msg 4621, Level 16, State 10, Line 1
Permissions at the server scope can only be granted when the current database is master
Msg 4621, Level 16, State 10, Line 1
Permissions at the server scope can only be granted when the current database is master
Fix/Workaround/Solution:
If you look at the database in use is AdventureWorks and when any server level permission has to be granted the database in context should be of master database. Change the database used to master and it should fix the error.
If you look at the database in use is AdventureWorks and when any server level permission has to be granted the database in context should be of master database. Change the database used to master and it should fix the error.
Reference : Pinal Dave (http://blog.sqlauthority.com/)
2 yorum:
There is a nice workaround for this problem, if the user wants to script the solution:
http://knol.google.com/k/linus-nilsson/sql-server-tips-and-tricks/g1yluc4toyn/20
Thanks, for your message.
Yorum Gönder