ms support lifecycle page might help

https://support.microsoft.com/en-gb/lifecycle/search?alpha=sql%20server

Run both through SQL Profiler and compare.

Things to look out for : Differences in connection settings, parameter sniffing, parameter conversion issues. Also maybe you could post your .net code and...

There are lots of ways.

You could convert it to a varchar(10), then find and replace the '.' with an empty string, then add a string with zero to the front.

Have...

I don't represent RedGate but I'm pretty sure if you hunt around their website you can download older versions which do support SQL 2000.

Alternatively, if you can't use that product,...

Have a look at the columns in your table and compare them to the fields in your text file.

The rowterminator looks dodgy too.

Search for 'plan eviction' - there's lots of good stuff out there, including TechNet articles

Check Regional Settings, see what the 'leading zeros' is set as.

What application are you using to view the flat file?

You'll need to use a decimal data type. Exporting a float to a text file gives exponential notation.

Have you proved that no blocking is taking place? RCSI does some locking/blocking depending on the usage scenario.

You might like to query the sys.dm_tran_locks table when testing to see...

Running a separate 'sequence' table like this is a fairly well-known pattern and it can work extremely well if done correctly.

May I ask if the system has always displayed blocking...

You have everything you need to investigate further yourself.

Return getdate(), last_request_start_time, DATEDIFF(ms, last_request_start_time, GETDATE()) in your results - right next to each other.

I suppose we can theorise that sql server...

Apologies if I'm stating the obvious as there are some big hitters on this thread but the trigger will fire exactly once if no rows are affected (or a million).

There's...

1. Use SUBSTRING function.

2. Use REPLACE function

https://msdn.microsoft.com/en-us/library/ms181984.aspx

Well, I could guess that much but when you assign a value to @deposit, you don't give it a varchar , you give it a numeric. So sort that...