remove default schema 1

[thamms]

Help, how can one delete the default schema for a user?

I've tried everything I can think of.

- ALTER USER... DEFAULT SCHEMA = NULL (doesn't work)

- removing the schema from user properties (it just adds it back!)

- I even deleted the schema, and it kept showing up in the login's properties, even though it didn't exist

I set the default schema to "dbo", but now I can't remove this!

I'm still having permissions problems accessing the sp_send_dbmail, and I'm beginning to suspect the schema.

Thanks

 

[mrdenny]

Users have to have a default schema. I don't think that you can remove it.

What problem are you having acessing sp_send_dbmail?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[thamms]

Right. Only windows group logins don't (and can't) have default schemas.

 

[mrdenny]

Correct. Microsoft is suppose to correct that so that domain groups can have default schemas so that the GUI will allow users who are not sysadmin to group objects, but it hasn't happened yet.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com