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