Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ikaddoura
Starting Member
3 Posts |
 Posted - 2006-01-18 : 11:59:47
|
| i need help in creating a dump file in any way in SQL that do the following:1- create a new table that contains the same info from my production table without effecting it2- every 1 hour any change happend in the real table should take a place in the dump tableif that contains queries, i need them too.thank youkaddoura |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-18 : 13:12:15
|
| 1. U can run one-time querySelect * into MyDump from MyTbl2. U can write a stored procedure to check for the different records in MyTbl and insert it to the MyDump and can schedule that task to run hourlyor more easily u can make use of DTS packages and schedule it to run hourly |
 |
|
|
|
|
|
creating dump file from store procedure or triger