compare lock setting in sql srv 2000 and 2005

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.

tat

re: compare lock setting in sql srv 2000 and 2005

SQL 2005 supports all the features that are existing in 2000 including locking. Only the new features are applied in 2005. These changes won't affect already existing features what you are using in 2000 and migration would affect nothing.

You carry on.