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...

The pk column in question is named "signon"; not "identity_signon" I tried without the word identity and received this error:

Table 'dbo.query' does not have the identity property. Cannot perform...

I opt to try your second suggestion:

set

identity_insert dbo.query on

update

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:

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '?'.

One of my column name...

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

Thanks

insert

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.