May 2, 2013 at 9:01 am
I have a consolidated SQL Server Machine, and none of application are running on this. But I have an error like below:
The server will drop the connection, because the client driver has sent multiple requests while the session is in single-user mode. This error occurs when a client sends a request to reset the connection while there are batches still running in the session, or when the client sends a request while the session is resetting a connection. Please contact the client driver vendor.
How can i find the client driver? With Which events of Server Side Trace or Profiler trace?
May 2, 2013 at 9:47 am
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')
Lowell
May 6, 2013 at 12:05 am
I can look at concurrent sessions like above.
But, i want to trace these events with like a profiler tool. I can't catch the missed event.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply