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 |
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. |
|
|
|
|
|