user and database

[Guest_imported]

I have imported a database from another network that had users not created as connexion user in my sql server.
When the database is imported, I can't destroy the sign of these users in the roles of the imported database and I can't create the equivalent connexion users on the server.

Thanks

 

[tlbroadbent]

What messages do you get when you try to drop the users?

If the users own any objects in the database you will not be able to drop them. Use sp_Changeobjectowner to change owners of objects if this is the problem.

EXEC sp_changeobjectowner 'MyTbl', 'dbo'

Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin