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. MadduriI 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=’‘ />].<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>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.</i></font id="size1"></font id="teal"></center>
]]>