Error running SP | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error running SP

I am running this user SP and its coming up with error message Msg 208, Level 16, State 1, Procedure sp_MSsendtosqlqueue, Line 40
Invalid object name ‘dbo.MSreplication_queue’. In my Stored procedure I am not calling this Table at all then why is this giving up this error message.
This could be a compatibility level issues, what is the level set against on the databases that are involved in the replication. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
I am trying to run a stored procedure against a database which is on sql server 2005 sp1 and then I am getting this error message.
Compatability of this database is "SQL Server 2005…………….90"
Also this table do not exist in the database, however replication and everything else is working fine.
Any idea, how I can create this table or how to resolve this issue??? Urgent help required..,,..

]]>