RE: FN-FORUM: Delete SQL Server User

date posted 19th March 2006 18:10

Aye you need to change the owner to somebody other than the user you are
trying to delete. There is a stored procedure to show you all these objects
I can't remember what it is atm sp_helplogins ? You could always revoke the
user login using sp_revokelogin or sp_droplogin.

Hope this helps.

Stephen

-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Kevan
Froud
Sent: 17 March 2006 10:58
To: FN-FORUM / [EMAIL REMOVED]
Subject: RE: FN-FORUM: Delete SQL Server User


17 March 2006 01:29 Craig wrote:
> Anyone know how to delete a database user from an SQL 2000
> database when you get a dialogue warning saying you can't
> remove the user because it owns objects? I can't see where

Hi Craig
I had the same problem once and IIRC I found the users UID in the sysObjects
table, changed it to the dbo uid (usually 1) and problem solved.

HTH
Kevan


--
Freelancers, contractors earn more with Prosperity4
Call 0870 870 4414 or visit www.prosperity4.com
and benefit from Inland Revenue approved expenses today.

To advertise here: http://www.freelancers.net/advertising.html