Thank you! You're a life saver.

I was thinking I could modify the identity column and change the starting number but when I modify and change it won't save.  Here's a list of my columns in...

identity_insert dbo.query on

dbo.query set...

I'll try this.  Thanks for all your help.  This forum and people like you are a lifesaver!

Thanks so much! It worked.  One more thing.  I ran this query against an empty table.  Now that the table has data in it I can't append duplicate primary keys...

You lost me but I put in all of the columns and got this error:

I have 14 columns in the table.  You're saying that I have to name all the column names in the query?

Thanks

into dbo.table_signon select * from dbo.query

I was...

You've given me some great suggestions and try to link the servers and go from there.  I'll let you know how it goes.  Thanks so much.

I'm talking about exporting out of one table on the old server and appending the data for this particular day in the table on the new server.

Ok.  I am not familiar with any of those features.  Can you explain more?  Thanks

Thank you all.  I'll give all your suggestions a try.

I glad you clarified this because I am having a problem running this code.  How do I configure the server to run with the network and doe I need this...

Thank you so much.  I thought I was losing it.