@Brandie Not sure, as I didn't try that option and now the problem is resolved, so there's no way to test.

See my previous comment, I disabled the account right after my test. In any case, it's my laptop at home, nothing critical/important stored there.

Never mind. I fixed the problem by enabling the Guest user in the local database. Funny thing is, I then disabled the same user and the error did NOT happen...

I am logged in as that user, so acct is not disabled and mixed mode auth is enabled. I'm 100% sure the password was typed correctly. Notice I slightly edited...

• This reply was modified 7 months ago by  Sam-263310.

I created sysadmin user xxx . Now the wizard gives me this error:

Login failed for user 'xxx'

Which is funny because I am logged in as that user.

@Eirikur That works, of course, but SQL Server won't be able to use any index for that query.

@JeffreyWilliams Yes, the query behaves as if one had written the AND condition you mention (see the last part of the original post, where I made the same observation), but...

Yes, the query plan makes it clear, so I have to accept it, but the result still feels "wrong" to me because 2 is not in the result set (1,3,NULL)....

• This reply was modified 1 year, 11 months ago by  Sam-263310.

@jeff: I didn't resolve it, it's just that as I looked into the problem further it turned out (surprise surprise...) the situation was more complicated than what the...

Please ignore this question, the problem I'm having goes deeper and I already found a different solution.

I tried to just delete this post but there seems to be no way...

• This reply was modified 5 years, 1 month ago by  Sam-263310.

@jeff Moden, Thanks for your extensive answer. I like your suggestions on eliminating the transaction and the session key and using the cte to grab the next record...