Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
eteo78
Starting Member
1 Post |
 Posted - 2010-01-27 : 17:59:22
|
| Hi all,when I query loginname from sysusers, is all the loginname actually username?Or is it a role? How can I verify which is which?Thank and RegardsEugene |
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-01-27 : 19:50:50
|
| http://msdn.microsoft.com/en-us/library/ms179871.aspxLook at the options in the table.islogin int 1 = Account is a Windows group, Windows user, or SQL Server user with a login account. isntname int 1 = Account is a Windows group or Windows user. isntgroup int 1 = Account is a Windows group. isntuser int 1 = Account is a Windows user. issqluser int 1 = Account is a SQL Server user. isaliased int 1 = Account is aliased to another user. issqlrole int 1 = Account is a SQL Server role. isapprole int 1 = Account is an application role. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-01-28 : 00:03:29
|
| Why not Syslogins? |
|
|
|
|
|
|
SQL Users in Express 2005