I came across an interesting bug in Management Studio in the latest Katmai CTP today – when a connection disconnects from a database, SSMS doesn’t release the shared database lock that it holds. This prevents any operations that need exclusive database access (like a RESTORE) and can be somewhat disconcerting if you don’t realize what’s going on. Try executing the following in SSMS in the November CTP:

USE

master;GO

CREATE

DATABASE MySSMSTest;GO

USE

MySSMSTest;GO

CREATE

TABLE test (c1 INT);GO

USE

master;GO

DROP

DATABASE MySSMSTest;GO

And you’ll see:

Msg 3702, Level 16, State 4, Line 1Cannot drop database “MySSMSTest” because it is currently in use.

It works perfectly in SQLCMD in the same CTP, and also in SQL Server 2005. You can work around this by doing something like:

ALTER

DATABASE MySSMSTest SETRESTRICTED_USERWITHROLLBACK IMMEDIATE;

GO

Not exactly ideal – but, hey, it’s only a CTP. This has already been reported in Connect as issue 320135 - I added a workaround.

I’ll post any further bugs that I find here as well as making sure they’re on Connect.