Running this command provided no results.

BEGIN TRAN

INSERT INTO OplatesStagingArchive.dbo.ACHBatches

SELECT * FROM OplatesStaging.dbo.ACHBatches

WHERE ProcessDate < '@1999-01-01'

This is what I got as a result. I had the same error with the ( ) in so I...

Well Ive started back on this project and have gotten a descent amount futher. I have my archive db created with a cloned schema of the original. Now...

I...

John Mitchell (10/18/2007)

The easiest way to do it is to right-click on your existing database in Enterprise Manager and choose All Tasks, Generate SQL Scripts, and use the dialog box...

Thank you very much for the responses! Im going to try it right now and will let you know how it works out.

THANKS!

Ok so I am a novice when it commands to SQL commands so maybe you could help me with this one...

Is there a command that I can run to create...

Thanks for the response. All the tables do have a date but I am going to have to work on the foreign keys.

Found out what was wrong... I feel stupid now as well.

I started looking at this problem a couple of days and found right away that the error code that...

Your right.

I have been trying to remote in to get to them but I am unable to do so at the moment.  I have my jr admin mailing them...