Tech Off Thread

1 post

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

Modifying sys.sp_MSdbuseraccess in SQL 2005

Back to Forum: Tech Off
  • User profile image

    Just wondering if anyone has tried the following KB article with SQL 2005?

    Doing a diff between the sproc in 2000 and 2005 there are no changes except in the comments, so I'm pretty sure the above KB's modified code can apply to 2005; however, in 2005, the modified sp_MSdbuseraccess fails to execute correctly citing that the user 'SA':

    "Cannot drop the procedure 'sp_MSdbuseraccess', because it does not exist or you do not have permission."

    I've tried dropping SQL into single-user mode and this didn't allow me to make changes to that sproc.  Additionally, if I attempt to do a direct modify via the Management Studio I get the error:

    "Invalid object name 'sys.sp_MSdbuseracccess'. 

    when I execute the ALTER query. 

    Does anyone out there have any insight into this?  Any help would be much appreciated.  Thanks!


Conversation locked

This conversation has been locked by the site admins. No new comments can be made.