table sanpshot 
Author Message
 table sanpshot
In Database B, I need to create a snapshot of DataBase A's table. Any clues?
I am new user of SQL Server, but quite familar with Oracle. In Oracle, you
can just create a table snapshot and define the update interval. Any Clues?
SQL Server 7.0
TIA


Tue, 12 Aug 2003 22:21:36 GMT
 table sanpshot

SQL Server does not support table snapshots like you describe. You have to create some
job (SQL Server Agent, perhaps) which refreshes the copy.

--
Tibor Karaszi, SQL Server MVP
FAQ from Neil at: http://www.sqlserverfaq.com
Please reply to the newsgroup only, not by email.


Quote:
> In Database B, I need to create a snapshot of DataBase A's table. Any clues?
> I am new user of SQL Server, but quite familar with Oracle. In Oracle, you
> can just create a table snapshot and define the update interval. Any Clues?
> SQL Server 7.0
> TIA



Tue, 12 Aug 2003 23:00:08 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Replicating (sanpshot replication) Referenced tables

2. sanpshot replication with immediating update

3. testing last sanpshot in QNX platform

4. sanpshot too old

5. testing last sanpshot in QNX platform

6. sanpshot output

7. How to distribute the Sanpshot image of filtered Merge Replicatio n effectively?

8. Table scans with large table joined to small table

9. ALTER TABLE on temp tables, table variables

10. Access 97/SqlServer 7: Appending Access Tables into Sql Server tables doesnt work for big tables

11. Joining tables from a table variable with SQL tables

12. Cross Table (Pivot Table) with Oracle Spread Table Control (MMTX32.OCX)


 
Powered by phpBB® Forum Software