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.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 how to hide MSREPL_Ver column from an app

Author  Topic 

jmcgeejr
Starting Member

2 Posts

Posted - 2008-10-09 : 16:16:06
I have an application that wont work when I setup replication because it says the MSREPL is an unsupported format (probably because it's a unique identifier). Is there any way to hide it from the app or how can I setup 2 way replication btw a host server and 4 outside PC's. there are little to no changes made and when it is it's just a new address and such added. thanks in advance!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-09 : 16:16:49
Are you using select * to query the replicated tables?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

jmcgeejr
Starting Member

2 Posts

Posted - 2008-10-09 : 16:31:38
Unfortunately I am not the application creator. That is pitney bowes mapinfo proffesional product that we use. I merely support the database of ours that the software points to so I have no idea how it does it's query nor can I change it.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-09 : 16:33:28
You can find out if it is using select * (which is the only reason I can think of that you are encountering this issue) by running SQL Profiler. If it is using select *, then you'll need to contact the vendor to modify it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -