sql server (alternate): Row versioning in SQL 2000? -- sql server (alternate)

Row versioning in SQL 2000?

betbubble NO[at]SPAM gmail.com
9/14/2006 8:41:45 PM

sql server (alternate): 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

Re: Row versioning in SQL 2000?

Erland Sommarskog
9/15/2006 6:58:30 AM

(betbubble@gmail.com) writes:
[quoted text, click to view]

No.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at