Can I copy a selected row from one table in one database to another table in another database?<BR>The idea is that a selected row would be moved to this backup database, the original deleted, thus making the &#039;live&#039; database a reasonable size...?<BR><BR>I know I could copy the data into an array... and then open another connection and copy the array into the second table... but I am wondereing if there is a better way of doing it, something on the lines of &#039;INSERT (8) Conn2.Candidates SELECT * FROM Conn.Candidates WHERE Candidate_ID= 29