We're using Windows Authentication with our SQL Server. We've added a domain group to the SQL Server groups and would like to give it a default schema. The properties window is the same for users and groups but the default schema field is enable only for user entities. We cannot add a default schema to a group.
Is this by design, a bug or a problem with our SQL Server installation? Updated on 2005/08/29
My first try was done at through Database\Security\Users. I tried going through Server\Security\Logins and I got this error message
Alter failed for User 'Domain\Group'. (Microsoft.SqlServer.SMO)
--> An exception occured while executing a Transact-Sql statement or batch.
--> The DEFAULT_SCHEMA clause cannot be used with a Windows group or
with principals mapped to certificates or asymmetric keys.
(Microsoft SQL Server, Error: 15487)
Why can we not set a Default Schema to a Windows group? This would be
View Complete Post