Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Default schema windows group Expand / Collapse
Author
Message
Posted Monday, December 15, 2008 8:56 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 2:37 PM
Points: 216, Visits: 702
What is the best way to assign a default schema in a database for a Window group?

I am trying to do it, but each time I am getting message sing the "The DEFAULT_SCHEMA clause can't be used with a Windows Group".

Thanks

Post #619659
Posted Monday, December 15, 2008 9:06 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 16, 2014 6:53 AM
Points: 1,145, Visits: 1,932
You can not assigned a default schema to an NT group.

Read up in this thread, as you'll see, this has been quite an inconvenience for many people.



---
SQLSlayer
Making SQL do what we want it to do.

Post #619678
Posted Monday, December 15, 2008 11:24 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 2:37 PM
Points: 216, Visits: 702
As everyone, I am surprise that we are still having this issue. Meanwhile, as anyone as found a workaround?

I have and old apps that with lots of users in the Window groups. I don't want to create news users for all members of the NT group. Since it will be harder to manage and not sure how the application will react.

Thanks,
Post #619838
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse