New server is very similar to old server just newer (i.e. better CPU, more ram, more storage - but same raid / SSD setup etc). Nothing seems to explain why...

a scholar and a gent.

*tips hat.

Some reports need to be real time but most do not (a day late isn't a killer).

I do like the idea of a view, but do I have any control...

Well I put that into the stored proc (as I assumed it would have the same affect) and the problem has gone away? But when I take it out (or...

Actually just spotted one difference (except for the normal stuff you'd expect, login name etc) was:

arithabort

0

arithabort

1

It was set to '1' on SSMS. Could this cause the problem? If so, (or...

I've tried running:

select *

from sys.dm_exec_sessions

And they seemed to be both have the same ANSI stuff.

Don't suppose you could tell me how to do such a thing? Also, not sure if this is more of a SQL or ASP question, but is there any way...

I think I remember being told that constraints reserve the next ID before checking whether they pass or fail. Do you have any constraints on the table?