June 15, 2006 at 1:21 pm
I have a strange issue with SQL Server 2005. When going into the database Properties and selecting Options, when scrolling down to the bottom of the options to State there is a State property called Restrict Access.
One one SQL 2005 Server, when viewing a particular database the available options are Multiple, Single, and Restricted.
However, when connecting to the same database via SQL Server Management Studio from another SQL 2005 Server, the options are listed as Multi_User, Single_User, and Restricted_User.
It's obviously a server side issue based on the SQL Server the Management Studio is installed on, as all databases viewed from Server A display all properties one way no matter on which server they reside, and all databases viewed from Server B display all properties the other way no matter on which server they reside.
Why would the same database properties on the same database have different text based on the instance of the Management Studio? Where should I go to change this so all servers display this information the same way?
As a side note, SQL Books Online lists the values for this as "Multipile, Single, and Restricted".
June 16, 2006 at 10:59 am
Sounds like the SSMS installs are from different builds or service packs.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply