471,086 Members | 1,073 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,086 software developers and data experts.

Row versioning in SQL 2000?

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

Sep 15 '06 #1
1 1968
(be*******@gmail.com) writes:
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?
No.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Sep 15 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Sandman | last post: by
5 posts views Thread by Jerry | last post: by
2 posts views Thread by PatrickSA | last post: by
1 post views Thread by MrNobody | last post: by
3 posts views Thread by Modica82 | last post: by
4 posts views Thread by giddy | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.