Row versioning in SQL 2000?
- From: betbubble@xxxxxxxxx
- Date: 14 Sep 2006 20:41:45 -0700
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
.
- Follow-Ups:
- Re: Row versioning in SQL 2000?
- From: Erland Sommarskog
- Re: Row versioning in SQL 2000?
- Prev by Date: Re: Line Break in T-SQL
- Next by Date: Re: sql server i/o bottle neck ?
- Previous by thread: Line Break in T-SQL
- Next by thread: Re: Row versioning in SQL 2000?
- Index(es):