November 29, 2007 at 7:42 am
Greetings folks. I am trying to drop a login from my database, but I get an error saying I can not drop him because he owns objects. I let him create some views a while back, but now I don't know what they are. I found sp_changeobjectowner, but I need a way to find out what objects he owns before I can change the owner of them.
Greg
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 29, 2007 at 7:53 am
sysobjects.uid
November 29, 2007 at 12:41 pm
Thank you Steve, that led me right to the suspect view.
Greg
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply