ViaThinkSoft CodeLib
This article is in:
CodeLib → Programming aids → SQL Server
First of all, you need:
Then, if you want to check if any other computer or user is accessing the database:
If you want to check if any other connection is open (even if it is on the same computer or the same app), use this:
DECLARE @AllConnections TABLE(
SPID INT,
Status VARCHAR(MAX),
LOGIN VARCHAR(MAX),
HostName VARCHAR(MAX),
BlkBy VARCHAR(MAX),
DBName VARCHAR(MAX),
Command VARCHAR(MAX),
CPUTime INT,
DiskIO INT,
LastBatch VARCHAR(MAX),
ProgramName VARCHAR(MAX),
SPID_1 INT,
REQUESTID INT
)
INSERT INTO @AllConnections EXEC sp_who2Then, if you want to check if any other computer or user is accessing the database:
SELECT * FROM @AllConnections WHERE DBName = ( select DBName from @AllConnections where SPID_1 = @@spid )
and LOGIN+'@'+HostName not in ( select LOGIN+'@'+HostName from @AllConnections where SPID_1 = @@spid )If you want to check if any other connection is open (even if it is on the same computer or the same app), use this:
SELECT * FROM @AllConnections WHERE DBName = ( select DBName from @AllConnections where SPID_1 = @@spid )
and SPID_1 <> @@spidDaniel Marschall
ViaThinkSoft Co-Founder
ViaThinkSoft Co-Founder