User-defined logins from Syslogins

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

User-defined logins from Syslogins

Author

Topic

simondeutsch
Aged Yak Warrior

547 Posts

Posted - 2003-03-06 : 13:30:30

How do I return the User-defined logins from the syslogins table? I don't want the Builtin/Adminstrator, and the Servername/Administrator logins. They have a different sid, but I don't know how to query the sid column.

Sarah Berger MCSD

simondeutsch
Aged Yak Warrior

547 Posts

Posted - 2003-03-06 : 14:40:23

The Answer is: SELECT .... WHERE LoginName NOT LIKE '%/%'.

Robvolk, I have a suggestion: For answering your own questions with the right answers, you should get double points. (for doing the homework, and bothering to post up the answer to help future searchers.)

Sarah Berger MCSD

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-03-06 : 14:51:51

I agree! Just buy yourself a double

. Hell, buy as many

as you want!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources