SQL Server Performance Forum – Threads Archive

User Information

Hi, I would like to create a user table in the database and would like to populate this table with the user and login information in the sys tables in the master database. I am not able to figure out the table containing this information. Please help me out how to go about this. Thanks in advance. Madduri

I found it in syslogins.

what you are trying to do . SRJ2005

I believe he is trying to get login information and looking for the master table where this is stored, found it from syslogins [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</center>

]]>