Posted by betbubble on 09/15/06 03:41

I replicate (transactional replication) my data entry database to a
read-only database. Both are SQL 2000+SP4. The web server reads the
read-only database. At times, there will be lots of changes in the data
entry database, thus lots of replications to the read-only database. I
am concerned that the replication may lock the data in the read-only
database, causing slow response to the web server.

I would like to use row versioning so that the read-only database can
supply old data when the same row is being written by replication. I
read that row versioning is a feature in SQL 2005. Is there any
versioning capability in SQL 2000?

Thanks

• Next in forum: Re: sql server i/o bottle neck ?
• Prev in forum: Line Break in T-SQL
• Thread view: Row versioning in SQL 2000?

[Reply to this message]