Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to check the authentication method in SQL 2000 server Expand / Collapse
Author
Message
Posted Monday, February 23, 2009 11:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 11:08 AM
Points: 4, Visits: 205
Great article Brian. I have a question. The following query you presented only works in SQL2005 server. I have several SQL2000 server installations in my shop. How can I check the authentication method in SQL2000 server then? Thanks.

SELECT
s.session_id
, c.connect_time
, s.login_time
, s.login_name
, c.protocol_type
, c.auth_scheme
, s.HOST_NAME
, s.program_name
FROM sys.dm_exec_sessions s
JOIN sys.dm_exec_connections c
ON s.session_id = c.session_id
Post #663240
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse