Qasim
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 08, 2004 10:11 PM
To: CF-Talk
Subject: RE: OT - Remove SQL Server user
> Sorry for an off topic question. How would one proceed to
> remove the remove a user from a SQL server db who has
> ownership for some objects.
> Here is my scenario, I restored a backed up database using
> the from device option. When this database is restored it has
> a default user name which doesn't exist on my SQL Server
> Security settings. Now I want to remove that user and
> recreate a new one but the SQL won't let me delete the object
> and will give a message "The user cannot be dropped because
> user own object". Any thoughts?
You might find this useful:
http://support.microsoft.com/default.aspx?kbid=274188
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
