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)
 INFORMATION_SCHEMA Login In SysUsers?

Author  Topic 

simondeutsch
Aged Yak Warrior

547 Posts

Posted - 2001-12-26 : 11:07:41
Hiya,
I'm trying to run reports, some of which have UserEntered as a criteria. So I'm filling up a list with (SELECT * FROM SysUsers WHERE IsLogin = 1), which is also pulling up INFORMATION_SCHEMA as a login. I'm not really sure why this would be an islogin = 1 or issqluser = 1. Is this a server default login,and if yes,why, and what can I do about it?

Thanks,
Sarah

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2001-12-26 : 12:56:07
INFORMATION_SCHEMA appears to be automatically created along with public, dbo, and guest. INFORMATION_SCHEMA is the owner of several built-in views that are a good way to query the system tables. You might look into using those to get the information you want, or it appears that you could just add a AND UID > 3 clause to eliminate all of the above SysUsers.

Go to Top of Page
   

- Advertisement -