A little SQL 2008 Management Studio "oops"

home
database
view story

2 Kicks

A little SQL 2008 Management Studio "oops" (sqlblog.com)

submitted by wisemx(8074) 3 years, 10 months ago

For those of you who connect to database servers where you are not in full control over all databases, or where some of your databases are ever offline (or auto-closed), the new version of Management Studio that is shipping with SQL Server 2008 is going to bring you some surprises, when you try to present a list of databases in Object Explorer. It seems that the ability to do so is hinged upon the columns that are set up in Object Explorer Details by default. In the case I came across yesterday, the offender was "Collation." The problem is that for a database that is offline or has been auto-closed, collation comes back as NULL. Well, that's not really the problem... the real problem is that SSMS throws its hands in the air when it comes across NULL for these values, and assumes this is NULL because you don't have permission.

add a comment |category: Database |Views: 14
Tweet