Merge Replication and Stored Procedures

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bill (Bill_at_discussions.microsoft.com)
Date: 03/08/05 

Date: Tue, 8 Mar 2005 13:53:02 -0800

Im using CF and SQL CE to create an application that records to SQL 2000
database server. I would like to use merge replication for its support for
SSL & disconnected CE. (Encrypted communication over the wlan is a strict
requirement and it is my understanding that SqlClient in the CF will throw an
error if encrypted communication is attempted.)

I have read 2 books (Rob Tiffany's in particular) that discuss merge
replication and both say that stored procedures (presumably to be run against
the primary SQL 2000 server as opposed to SQL CE) are supported. No further
info is provided. My questions of course are; Has anyone out there done it?
If so, how do you do it? Are return data supported? etc. etc. Additional
info would be greatly appreciated. (I am aware that RDA will permit calls to
stored procedures using SubmitSQL but return data is not supported.)

Bill 

-- 
Senior Programmer/Analyst
Duke University Health System

Relevant Pages

  • Re: Tiger Stock
    ... a lot of money selling applications based on their own platform. ... larger players support more interfaces, ... Coming back to a point in the last paragraph: Lack of support for SQL ... So if we take that off the table and compare companies, ...
    (comp.databases.pick)
  • RE: Merge replication resets identity ranges to 1 for all subscrib
    ... manage identity columns yourself other than merge replication. ... Also, there is a known issue for SQL 2000/SQL CE 2, you may want to check ... you open a Support incident with Microsoft Product Support Services if you ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL SA Password changed?
    ... You've also posted this to a direct access newsgroup with official Microsoft ... > database connection information and make sure that the database server is ... see Help and Support Center at ... > I think the issue is related to the SQL SA access being ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: SQL Set to System Account - Sharepoint Question
    ... Administration", not System Account) account. ... after the installation there isn't normally any reason to ... SQL, don't use an instance being used for anything else. ... the App Support people why SA is required. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Mobile and Datasets Problem
    ... About the database question, in the sql server 2005 table that is used to replicate with the mobile database, i put the flag rowguid to false in the uniqueidentifier primary key. ... Can i use the sql server 2005 tables for RDA replication without any identity columns defined? ... If you'd like to know more details about this, I recommend that you open a Support incident with Microsoft Customer Support Services so that a dedicated Support Professional can work with you in a more timely and efficient manner. ...
    (microsoft.public.sqlserver.replication)