sql server connect: Hi,

I have a problem to delete a user and it gives me this message in SQL2K5:

The database principal owns a schema in the database, and cannot be dropped.
(.Net SqlClient Data Provider)

Can any body help me. I will be grateful

This databade came from a SQL2K and I can connect from any client
application to SQL2K5.

--
Thanks ,

Hi,

like the messsage says, the principal (user) owns some objects in the
database. You either transfer the ownership of the schema to another
user or drop the existing objects under the schema and drop the schema
first. After that you can drop the user.

HTH, Jens SUessmeyer.

---
http://www.sqlserver2005.de
---