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 |
|
sandman.gk
Starting Member
2 Posts |
 Posted - 2007-06-21 : 12:41:01
|
| Hi,I have only been working with SQL for short time. My question is probably a basic one but I would appreciate the assistance! The scenario is I have two different tables AVCfids (on ACC database)& AVCfids (on ACC.archive database). I am trying to write a command in SQL server agent (jobs) to transfer the data on a daily basis from AVCfids to ACC.archives. The script I have created but is not working is: Database: ACC_archives Select * into avcfidsfrom server.acc.dbo.avcfidsAny feedback would be welcomed.Regards Jeff |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-21 : 12:49:41
|
| You need to be more specific than "The script I have created but is not working is"Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
sandman.gk
Starting Member
2 Posts |
Posted - 2007-06-21 : 13:21:03
|
[quote]Originally posted by dinakar
You need to be more specific than "The script I have created but is not working is"Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar//quote]Dinakar,When I try to execute the command in SQL server agent/jobs, I receive the following error message:Execution of job failed 'avcordersdu' failed.I am trying to transfer all the data from one table to anohter.Regards Jeff |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-21 : 14:30:13
|
| When you look into the job history, what is the exact error message? What is 'avcordersdu'? Does the table avcfids already exist in the archive DB?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-21 : 16:27:38
|
| Are those tables in same db on the server? If so, why use four-part name? If not, did you create linked server? |
|
|
|
|
|
|
HVC Basic Question