Drop and Re-Link the table.  You will be prompted to use a key column.  Select the clustered index as your primary key.  Even if it envolves multiple columns. 

Thanks for the information. I tried searching microsofts site for this and could not find it. I dont' know if it is me, or the way microsofts search...

Yes they can be on different database servers. Take a look at this link to determine what version each server needs to be on. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replimpl_4joy.asp

To...

We use a template spreadsheet with a source workbook. The source workbook is updated when the user cliks on a link.

Private Sub CreateSpreadsheet(ByVal Parameter As Long)

...

Thanks. I also did some more testing and found that I could not get the statement to work as it was. I was in need of some proof...

Good question on why. In this case, I am creating the backups on a sperate raid device. This device is a temporary solution until we get another storage...

Good point Antares686. I have also found that if you have a habbit of using the between statement and adding a date to your to_date, with the <= condition,...

I agree with you Antares686. I try to ensure that my variables are set before executing the statement. However there are times that I don't have the luxury....

Thanks for the replies. This is what I thought. Currently my approach is to create the appropriate triggers to update a local table (audit table) and then use...

Yes they can be linked permanently. How is this established? If the connection is ever lost between the two servers, how would you recomend to re-establish the connection?

If I loose one transaction backup and I am in trouble, how do others handle this? From what I understand, most DBAs do a full backup once a day...