Concurrency Checks in MSSQL (Alternatives to TSEQUAL)

Question

I am working in development under SQL 2008, however I have a SQL 2000 database (in compatibility mode).

There are several queries that are using the "TSEQUAL" function to do concurrency checks. It seems however that this function has been completely removed in SQL 2008 and these statements (sitting in SPROCS) no longer compile.

What is the best approach to concurrency checking in SQL 2005 and later?

Answer 1

See http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126933.