Prev: Estimated plan using view vs. guts of view
Next: help
From: SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD. on 7 Aug 2010 07:44
Dear Sir,

How to find the any user is connected to SQL Server over internet using any
views like Sys.DM_Exec_Connections etc.

Sanjay Shah



From: Erland Sommarskog on 7 Aug 2010 07:54
SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD. (sanjay(a)microbrain.in) writes:
> How to find the any user is connected to SQL Server over internet using
> any views like Sys.DM_Exec_Connections etc.

The column client_net_address gives you this information. Of course,
you will have to decide what is "Internet" for you.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: Estimated plan using view vs. guts of view
Next: help