Msg 4621, Level 16, State 10, Line 1 Permissions at the server scope can only be granted when the current database is master



ERROR

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.



Reference : Pinal Dave (http://blog.sqlauthority.com/)

2 yorum:

LN dedi ki...

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

Serkan SÖNMEZ dedi ki...

Thanks, for your message.

2018 SGK İşten Çıkış Kodları (696 sayılı KHK kapsamında eklenenler dahil)

2018 SGK İşten Çıkış Kodları 1- Deneme süreli iş sözleşmesinin işverence feshi 2- Deneme süreli iş sözleşmesinin işçi tarafından feshi ...