session is single_user mode, or the database?

if it's the database,

you can look in sys.databases for any databases with user_access_desc = 'single_user', and then compare the results to who's currently in it via sp_who2:

this worked for me, when i moved a database into single_user mode.

declare @RESULTS TABLE(

[WHORESULTSID] INT IDENTITY(1,1) NOT NULL PRIMARY KEY,

[SPID] CHAR (5) NULL,

[INSERTDT] DATETIME NULL DEFAULT(GETDATE()),

[STATUS] VARCHAR(30) NULL,

[LOGIN] VARCHAR(30) NULL,

[HOSTNAME] VARCHAR(30) NULL,

[BLKBY] VARCHAR(30) NULL,

[DBNAME] VARCHAR(30) NULL,

[COMMAND] VARCHAR(30) NULL,

[CPUTIME] INT NULL,

[DISKIO] INT NULL,

[LASTBATCH] VARCHAR(30) NULL,

[PROGRAMNAME] VARCHAR(200) NULL,

[SPIDINT] INT NULL,

--column added in SQL 2008--REMOVE FOR sql2005

[REQUESTID] INT NULL

)

INSERT INTO @RESULTS(SPID,Status,Login,HostName,BlkBy,DBName,Command,CPUTime,DiskIO,LastBatch,ProgramName,SPIDINT,REQUESTID)

EXEC sp_who2

select * from @results where dbname in(select NAME from sys.databases where user_access_desc = 'SINGLE_USER')