Навигация

Итоги года

Другие ссылки


Реклама

Счётчики


SQL 2008 Management Studio -> SQL 2005 instance issue

30.12.2009 Среда 13:00

When you connect to to a SQL Server 2005 instance using SQL Server 2008 Management Studio you may get an error about some permissions being lacked for a database when you're trying to enumerate databases. Here's a workaround:

1. Navigate to 'Databases' in OE and open OED in that context
2. Right click on the column header and unselect 'Collation'
3. Refresh the server in OE and enumerate the databases

(C)opied from here.

Glossary:
OE — Object Explorer
OED - Object Explorer Details (invoked View -> Object Explorer Details or just by F7)