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?
Thanks in advance for help
Qasim
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
