Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!



compare lock setting in sql srv 2000 and 2005

By DetroitPistons ·
Hi All,
I am new with SQL server, current my company is running SQL Server 2000 and will move the database to SQL 2005. Once I move the database over to SQL Server 2005, is there a way for me to compare the setting of the locking mechanism, such as optimistic and pessimistic, I want to make sure they will be identical. Or is it all in the coding in the app itself. I've been reading what I can find but haven't came accross any visual settings yet.

Thanks all for any help/direction in advance.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

That is in the code

by Tony Hopkinson In reply to compare lock setting in s ...

Trans Isolation levels on the connections, and specific 'overrides' within queries such as

Aside from soem deprecated syntax, I don't reemeber any specific problems when doing this.

Except, like many after upgrading the database, I forgot to set the compatibility mode to 90.
SQL 2005 syntax (especially is system stored procedures) can give you some serious funnies if you forget.

Collapse -

That is in the code

by DetroitPistons In reply to That is in the code

Thank you for your input

Related Discussions

Related Forums