Re: Row versioning in SQL 2000?

(betbubble@xxxxxxxxx) 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, esquel@xxxxxxxxxxxxx

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
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: SQLServer Connection Problems...
    ... making it all the way to SQL but its failing at the SQL login. ... Only take this step if your server is protected inside a good firewall... ... Most good judgment comes from experience. ... I can ping the SBS server from the Web Server on a local ip address ...
    (microsoft.public.sqlserver.connect)
  • Re: Using Access to access an sql database on a webserver
    ... a open sql port is not available. ... that very same web server has complete and free rein to access those files, ... Well, yes, if you are taking about ASP pages hosted on that site...right? ...
    (comp.databases.ms-access)
  • Re: Using Access to access an sql database on a webserver
    ... a open sql port is not available. ... way of directly getting to the database to execute arbitrary SQL ... This is exactly the same concept for that web server ...
    (comp.databases.ms-access)
  • SQL server authentication using impersonation
    ... I have a web server on a SBS 2003 box, ... I want to impersonate the current user when executing SQL procedures. ... The database filters rows depending on who the windows user is, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Preventing login as NT AUTHORITYANONYMOUS LOGON
    ... > So the identity impersonate needs to be there so we can connect to sql. ... designated ASP.NET to run under has login credentials to your sql database. ... If one is an external web server and the one that doesn't ...
    (microsoft.public.dotnet.framework.aspnet)