d4mn ?t ...

h0ly sh?t !

4W F?CK !!!

Why not call it ZULU Time ?

International aviation and the military (NATO included) do with out much ado (and have for quite a number of decades already !)

I think now that it is time to have an AA Admin sit next to you and check as you are doing this.

Have you tried dropping the login from the SQL Server and then readding it ?

I am guessing that this is the only recourse left.

what does the output of the following produce:

exec sp_logininfo 'INTL\Rtxie'

Please post the SQL executed to return the 2 successful executions and the results.

Then I would check with the AD folks to see if that account was dropped and readded within AD (if it has is got a new SID). This may seem...

my browser just went 'whack' ...

let's try some variations of xp_logininfo now:

exec xp_logininfo 'intl\abc' --> we know this fails

How about some variations to take into account character...

I would first try to execute:

exec sp_validatelogins

If this does not produce any results the next step is to retry xp_logininfo:

exec xcp_logininfo 'intl\abd

The more things change, the more things stay the same !

WOW David !

This should be required reading for all System Architects, Database Designers and SQL Programmers. It is clear and succinct in its explanation of what we collectively know as...

While the articles author made a contribution that he thought he was helping his community - the discussion responses speak otherwise. The SSC community stepped in to clarify, augment and...

Being a production support DBA is like any other 'niche' title/occupation within IT. There are always tradeoffs in salary, working hours and benefits both within a given company and between...

Live long and propsper ....

Bartlesville, Oklahoma