Ceppek's

Adventures,friends,love,life,art, IT geeks, photography

SQL : mengetahui user dan session pada MSSQL

Leave a comment


Script berikut bisa di gunakan untuk mengetahui siapa saja yg lagi login ke database MSSQL 2005 dan 2008

SELECT 'Authentication Method'=(

CASE

WHEN nt_user_name IS not null THEN 'Windows Authentication'

ELSE 'SQL Authentication'

END),

login_name AS 'Login Name', ISNULL(nt_user_name,'-') AS 'Windows Login Name',

COUNT(session_id) AS 'Session Count'

FROM sys.dm_exec_sessions

GROUP BY login_name,nt_user_name

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s