Gjoreski
Administrator
Registrovan od:02.02.2009
Lokacija:Ohrid Makedonija
Predmet:
Konekcije i IP na Databazu
Preuzmi
Izvorni kôd (SQL):
SELECT
DB_NAME
(
dbid
)
AS
DBName
,
COUNT
(
dbid
)
AS
NumberOfConnections
,
loginame
AS
LoginName
FROM
sys
.
sysprocesses
WHERE
dbid
>
0
GROUP
BY
dbid
,
loginame
SELECT
session_id
,
client_net_address
FROM
sys
.
dm_exec_connections