I know it's an old post, but I thought I'd mention what helped me.

The message indicates that sessions are active inside workgroups that are changing.

To get past the error, you...

I've tried to look at some deadlocks in Management Studio but I get the same error that mentions "key cannot be null".
In my case, I've noticed a few interesting...

philcart (5/19/2011)

---

I'd suggest never run the Profiler GUI on a production server without very limited events/columns and strict filters. Even then, on a very busy server, there will be an...

Your method of analyzing blocking was interesting. Could you compare it to the "blocked process report" event that is available in system traces (i.e. profiler)

Hi Jeff,

Records aren't always stored physically ordered on a data page. Most of the time they are physically ordered correctly, but the actual order comes from the slot array....

Ha!

CREATE PROCEDURE enTibble AS

DECLARE @tableName sysname = NULL;

DECLARE @newName sysname = NULL;

SELECT TOP (1) @tableName = name,

@newName = 'tbl' + name

FROM sys.tables

WHERE name not like 'tbl%';

WHILE (@tableName IS NOT NULL)

BEGIN

EXEC...

If we change domains slightly: Consider a text-editing problem rather than a programming problem:

When working in Management Studio if you want to replace one (and only one) string of spaces...

For what it's worth, there is now a microsoft connect item for this problem.

Issue 388403