DBCC dllname (FREE)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

George - 24 Oct 2006 14:32 GMT

According to SQL Server 2000 Books Online, this command requires membership
in the sysadmin or db_owner role. We have added the user to the db_owner
role of database 'master', yet the command fails and reports error 2571. Is
this the correct database? (The command succeeds so long as the login is a
member of sysadmin.)

Thanks,
Dana

Reply to this Message

Charles Wang[MSFT] - 25 Oct 2006 04:32 GMT

Hi Dana,
My understanding of your issue is that:
You found that DBCC dllname(FREE) could not be executed with db_owner. You
could run it with sysadmin.
If I have misunderstood, please let me know.

I looked through our internal database and found that this was a
documentation issue ( 223167 ) of BOL.
BOL should read:
DBCC dllname (FREE) permissions default to members of the sysadmin fixed
server role, and are not transferable.

Please assign the login account with sysadmin permission to run the
statement.

If you have any other questions or concerns, please feel free to let me
know. It is my pleasure to be of assistance.

Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

Reply to this Message

Charles Wang[MSFT] - 27 Oct 2006 14:10 GMT

Hi Dana,

I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.

Have a great day!

Charles Wang
Microsoft Online Community Support

Reply to this Message