Prikazi cijelu temu 31.08.2021 23:28
Gjoreski Van mreze
Administrator
Registrovan od:02.02.2009
Lokacija:Ohrid Makedonija


Predmet:Konekcije i IP na Databazu
PreuzmiIzvorni kôd (SQL):
  1. SELECT
  2.     DB_NAME(dbid) AS DBName,
  3.     COUNT(dbid) AS NumberOfConnections,
  4.     loginame AS LoginName
  5. FROM
  6.     sys.sysprocesses
  7. WHERE
  8.     dbid > 0
  9. GROUP BY
  10.     dbid, loginame
  11.  
  12. SELECT session_id, client_net_address
  13.   FROM sys.dm_exec_connections