|
evanburen
Posting Yak Master
167 Posts |
 Posted - 2008-03-31 : 09:43:02
|
| I have 2 databases, HS and BoardAnalyst and the table TCompanies exist in both. I want to delete all of the records from HS.TCompanies and repopulate it with data from BoardAnalyst.TCompanies. I'm getting the error message "Table 'HS.dbo.CompID' does not exist or cannot be opened for SET operation." CompID is the PK for the table. I'm not sure what the problem is. ThanksDELETE FROM HS.dbo.TCompaniesGOSET IDENTITY_INSERT HS.dbo.TCompanies ONGOINSERT INTO HS.dbo.TCompanies(HS.dbo.AnnualMtg, HS.dbo.BdMtgs,HS.dbo.CompanyName,HS.dbo.CompID,HS.dbo.DirectorsTotal,HS.dbo.Exchange,HS.dbo.IndexFortune,HS.dbo.Industry,HS.dbo.LinkComp,HS.dbo.MailAddress,HS.dbo.MailCity,HS.dbo.MailCountry,HS.dbo.MailFax,HS.dbo.MailingAddress1a,HS.dbo.MailingAddress2,HS.dbo.MailPhone,HS.dbo.MailPostCode,HS.dbo.MailState,HS.dbo.MarketCap,HS.dbo.ProxyDate,HS.dbo.Revenues,HS.dbo.StateHQ,HS.dbo.Ticker,HS.dbo.Updated)SELECTBoardAnalyst.dbo.TCompanies.AnnualMtg,BoardAnalyst.dbo.TCompanies.BdMtgs,BoardAnalyst.dbo.TCompanies.CompanyName,BoardAnalyst.dbo.TCompanies.CompID,BoardAnalyst.dbo.TCompanies.DirectorsTotal,BoardAnalyst.dbo.TCompanies.Exchange,BoardAnalyst.dbo.TCompanies.IndexFortune,BoardAnalyst.dbo.TCompanies.Industry,BoardAnalyst.dbo.TCompanies.LinkComp,BoardAnalyst.dbo.TCompanies.MailAddress,BoardAnalyst.dbo.TCompanies.MailCity,BoardAnalyst.dbo.TCompanies.MailCountry,BoardAnalyst.dbo.TCompanies.MailFax,BoardAnalyst.dbo.TCompanies.MailingAddress1a,BoardAnalyst.dbo.TCompanies.MailingAddress2,BoardAnalyst.dbo.TCompanies.MailPhone,BoardAnalyst.dbo.TCompanies.MailPostCode,BoardAnalyst.dbo.TCompanies.MailState,BoardAnalyst.dbo.TCompanies.MarketCap,BoardAnalyst.dbo.TCompanies.ProxyDate,BoardAnalyst.dbo.TCompanies.Revenues,BoardAnalyst.dbo.TCompanies.StateHQ,BoardAnalyst.dbo.TCompanies.Ticker,BoardAnalyst.dbo.TCompanies.UpdatedFROMBoardAnalyst.dbo.TCompaniesGOSET IDENTITY_INSERT HS.dbo.CompID OFFGO |
|
IDENTITY_INSERT