Escape Logic Ideas that Escape conventional Logic

If you receive this error when trying to create a new table, then read on.
Property DefaultSchema is not available for Database '[dbName]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.

This error occurs when all of the following conditions are met:
-You try to use the GUI to create a table
-Are not sysadmin
-Your access to the SQL Server 2005 database is from a Windows group

This is a known bug. There are two workarounds.

1) Explicitly create a user for [Domain\user1] with whatever default schema you like. This is the simplest, but you have to do this for each and every user.

2) Create the first object using TSQL directly:

a. Click on “New Query” and connect to the right server

b. Write the script to create the table and click on “Execute”, for example:

use [db_Test]

go

CREATE TABLE [MyTable]( data varchar(10) )

go

c. If you refresh the view in Object explorer you will notice the following changes:

i. Table created = [user1].[MyTable]

ii. New user = [Domain\user1]

iii. New schema = [Domain\user1]

NOTE: At this point you can drop this “dummy” table and everything should work fine from now on for this particular user.