I have never read the statement "do not use cursors" in any other way than interpreting it as "do not use row-by-row operations, use set operations instead".

So I do...

I think you are absolutely right.

Once I was asked to take over a different position in our company and I refused at the time, I did not really want...

First, it is actually not true that an expression containing NULL evaluates to FALSE.

It evaluates to UNKNOWN.

A WHERE clause filters out all UKNOWN values, and that is why you...

I checked the sys.login_token view but it won't help me because the Windows group in the working database is a different one than the group in the non-working one.

I managed...

@GregEdwards - there has been no movement of this database nor any change in AD. The database in question was created on that server. The older databases did come from...

Additional data:

The error log shows: Error 18456 Severity 14 State 38

According to this site

http://sqlblog.com/blogs/aaron_bertrand/archive/2011/01/14/sql-server-v-next-denali-additional-states-for-error-18456.aspx

error state 38 indicates:

"The database specified in the connection string, or selected in the...

jcb - thanks, I checked, in fact there are no triggers anywhere in the database. Actually in the production database the AccountID column is an Identity column, sorry, I did...

Lutz - I am going to rewrite it set-based, sure.

As I see it, cursors are really meant for interaction between SQL Server

and applications which just cannot understand set-based operations.

Not...

Here is some test code.

I am afraid you won't find any problem on the test code, as I could not do so myself. It occurs only in my production...

Well, I guess you're right, and I agree. I inherited the code and yes, it won't stay this way.

But my question is rather why does something like this occur -...

Gordon,

what program creates your dBase files?

Newer version of dBase, and their clones such as Visual Foxpro, have support for converting tables to XML files.

Otherwise it is quite elementary,...

Cannot download your stored procedure - link is broken?