December 26, 2007 at 10:09 am
I am playing around with the system stored procedures, specifically sp_addsrvrolemember.
so logged in with SA and I added just a dummy account through E.M. called lee and went into the SERVER ROLES and checked off sysadmin entered a password and hit OK.
Go into Q.A. and do the following SELECT * FROM master..syslogins where name = 'Lee'
Get the results and everything RIGHT of the password column is off by one column...
The language column is housing the encrypted password.
The denylogin column is housing the language.
So on until the end...the columns are one off to the RIGHT.
Can anyone explain this? I only found one other post on Google that was similar to what I am experiencing...but didn't really give a reason for the issue...
http://www.dbforums.com/showthread.php?t=627549
When I query the sysxlogins table to look at the xstatus it shows an xstatus of 18...
The login has no specific rights granted to anything else except the sysadmin SERVER ROLE...and a general password.
Any info would be greatful because I feel like a dumb arse right now
Thanks in advance,
Lee
December 26, 2007 at 10:40 am
Haven't really noticed this, but I haven't messed with the system tables much. Does the login have SA rights? Are there any problems?
My guess is that it's a display issue and not a real problem
December 26, 2007 at 11:42 am
SA has rights on the server and it isn't a real problem as I verified it within E.M. that the login does have the correct rights also, when I open the view within E.M. it shows up correctly.
This seems to ONLY be an issue when you are displaying the results within QA and Results to Grid.
If you run the same exact query in Results to Text it displays correctly...
To verify if you are interested just add a dummy account and give it SA rights...
If you give a password then the results in Grid will be messed up
If you don't give a password the results in Grid show correctly
guess this isn't a real issue but it is annoying none the less...
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply