locked
insert query fails with invalid object name error RRS feed

  • Question

  • I have a SQL server where an insert statement like:

    INSERT INTO FCRasStateLogToday (dcServerID, dnGlobalID, dnStateStartTime, dnStateStopTime, dnStateWDay, dcAgentID, dcAgentExtension, dnAgentState, dnAgentReasonCode) VALUES (0x001143b988030000017c0028, 1243527321, 1243817607, 1243817642, 0, N'RArnold', N'RArnold', 18, 0)

    Throws error saying:

    Invalid object name 'tsvw_78A7004190BD4405A655BA60E8BBA361'. [SQLSTATE 42S02] (Error 208) Invalid object name 'ctsv_78A7004190BD4405A655BA60E8BBA361'. [SQLSTATE 42S02] (Error 208)

    Any idea what could be wrong?
    Monday, June 8, 2009 9:12 AM

All replies

  • You are missing replication metadata objects. Either take these objects from another working subscriber or reinitialize.
    looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    Monday, June 8, 2009 10:37 AM
    Answerer