January 8, 2009 at 12:40 pm
I'm running SQL 2000, sp4. Usually I use sp_helplogins to get the info when I need it. Today however, I queried syslogins directly. I noticed something weird with the data. For all the SQL users, in the language column, it's filled with hex or binary data, under the denylogin column it states "us_english" and loginname is blank. However, for all the windows users, the language column states "us_english", under the denylogin column it has either 1 or 0 and loginname is correctly populated. I am NOT experiencing any issues so I'm not overly concerned. Just thought it quite odd. It's like something in the view but darned if I can find it.
Lastly, the CHECKDBs are always clean, and as stated before, we aren't having any issues.
Anybody see this before?
-- You can't be late until you show up.
January 8, 2009 at 2:13 pm
Ok, this is getting weirder. If I run the following:
select *, 'servername' as location from syslogins
For Windows users location displays "servername" but for sql users, it shows their loginname. It's like the flippin' Twilight Zone - I can even hear the music :w00t:
-- You can't be late until you show up.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply