June 18, 2008 at 4:50 am
Excuse me if this has already been posted but i couldn't find it within this area...
I have setup replication between 2 physical servers (both SQL 2000) for a particular database. The initial snapshot appears to have worked and it's status is "Succeeded". The problem lies with the PUSH replication. When the agent is run, i receive an error which states "Invalid Column Name 'area'."
Can anyone please offer any advice? I haven't done a great amount with replication so please feel free to treat me as a Newb on this subject.
Regards.
Brett
June 19, 2008 at 1:52 pm
This problem occurs because the Snapshot Agent always sets the QUOTED_IDENTIFIER option to ON, regardless of the actual setting. Therefore, if the stored procedures or views use double quotation marks, the Distribution Agent or the Merge Agent assumes the default behavior of using double quotation marks for identifiers only. To get round this, you can change the object script to refer to literals using single quotes, or use DTS to transfer the objects.
From:
http://www.replicationanswers.com/General.asp
June 23, 2008 at 1:43 am
Thanks for your response Wildcat..
Do you know of a good source of info regarding setting up replication? As i said in my original post, i'm new to replication and certain parts of SQL Server in general...
Thanks again from a Newbie. :unsure:
June 23, 2008 at 11:46 am
You can google the instruction.
Here is one:
http://www.devarticles.com/c/a/SQL-Server/Replication-SQL-Server-2000-Part-2/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply