Property DefaultSchema is not available for Database
-
Hi
After adding a NT Group to the Logins, I made it db_owner of a DB. When I opened SSMS with a member of the NT Group by creating a view or a table you will get the following error:
Property DefaultSchema is not available for Database '[Test]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (SQLEditors)
Editing objects is not a problem.
The only advice I found is in the msdn Forum:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=79418&SiteID=1&PageID=1
It seems to be a known problem. So I tried to install SP 2, but the result is the same. I tried a trick with a custom DB-Role without success.
Of course is possible to create objects through T-SQL (it is very important to specify the schema otherwise a schema for the user will created), but in my opinion this is not a solution.
Any suggestions ?
Regards, Moreno
-
This was removed by the editor as SPAM
-
I am having the same issue, did you ever find a solution?
-
Try this link http://forums.microsoft.com/msdn/showpost.aspx?postid=79418&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=0
is all what I found
-
It seems to have been fixed in SP3.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply