SQL Server Performance

User Information

Discussion in 'Getting Started' started by madduri, May 8, 2007.

  1. madduri New Member

    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
  2. madduri New Member

    I found it in syslogins.
  3. reethu New Member

    what you are trying to do .

    SRJ2005
  4. satya Moderator

    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>

Share This Page