December 1, 2004 at 4:14 pm
I am attempting to transactionally replicate a database that has a table naming convention similar to the following......'This Example Company$The Problem table'. They contains spaces, dollar signs and sometimes slashes in them. I have no problem setting up the initial snapshot and the tables appear with the data intact in the subscribing database. But when any data changes in the publishing database I revieve a syntax error when it tries to make the change on the subscriber. I have tried using alias names, brackets as well as brackets around the names. Nothing seems to work. Does anyone have a solution that will allow me to keep the table names in the publishing database as they currently are (I am not able to rename them) and still create a functional transactional replication between the two databases?
Any help would be greatly appreciated.
Regards,
David
December 2, 2004 at 8:24 am
Run
SELECT QUOTENAME('This Example Company$The Problem Table')
and replace the value in the stored procedures use to replicate the data.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply