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
    mbaldwin

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

    http://support.microsoft.com/?id=889696

    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!

    -matt

Conversation locked

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