출처 : https://sqlgate.wordpress.com/2011/05/19/sql-server-%EC%82%AC%EC%9A%A9%EC%9E%90-%EC%A0%95%EB%B3%B4-%EB%B3%B4%EA%B8%B0-%EC%BF%BC%EB%A6%AC/[SQL-Server] 사용자 정보 보기 쿼리SQL-Server sqlgate.wordpress.com SELECT obj.principal_id as [ID], obj.name AS [Name], ISNULL(SUSER_SNAME(obj.sid), N'') as [Login], ISNULL(obj.default_schema_name, N'') as [Default Schema], CAST ( CASE WHEN dp.state IN (N'G', N'W')..