Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-06-19 : 18:49:01
|
| John writes "Hi,I recently discovered that MSSQL 7 will allow me to do transactional replication to heterogenous data sources. This is great, because it fills a need that I've had for a while.So I went through several steps to do some simple testing of the functionality, and I think I've got everything figured out to do simple replication to another database first going through OLE DB and then through the other db's ODBC driver.Everything is fine, *except* the fact that my table & column names in MSSQL have capitalization, like TableName. Unfortunately, the MSSQL replication process double quotes the table & column identifiers when generating SQL to be run on the second database.This causes me a problem for various unimportant reasons.I was wondering if there is some obscure (or not so obscure) option that would allow me to tell MSSQL *not* to put the double quotes around the identifiers. I did notice during the replication setup process that you are allowed to specify a stored procedure call in lieu of the standard INSERT/UPDATE/DELETE call, but I wasn't sure if I could just replace that my own custom SQL and how well that'd work anyway.Do you have any suggestions?Thanks,John" |
|
|
|
|
|
MSSQL 7 Replication via OLE DB & unwanted quoted identifiers