Re: SQL Mobile and Datasets Problem

Hi Peter,

First, thanks for your quick reply.

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.

With this option, I've been able to create successfully the datasets in the replicated tables.

Now, my sql server 2005 tables used to replication doesn't have any identity column. In your response you said to use two columns, one primary key and other for identity. Can i use the sql server 2005 tables for RDA replication without any identity columns defined?

I have another question, can you help me on how to change the value of the attribute rowguid using transact sql (the desktop software on which i'm working has already been released and if the change on the attribute rowguid fix the sync problem, i have to send a sql patch to change this).

Thanks in advance,
Nuno Silva

privatenews wrote:
Hello Nuno,

I understand that you encountered the following exception when you try to generate dataset on replicated tables. If I'm off-base, please let me know.

"Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information".

Based on my research, if the a column with datatype is uniqueidentifier and set ROWGUIDCOL and PRIMARY KEY on SQL mobile, this issue might occur. This is a known issue of SQL mobile, and product team is evaluating the impact and consider a fix for the issue. If you'd like to know more details about this, I recommend that you open a Support incident with Microsoft Customer Support Services (CSS) so that a dedicated Support Professional can work with you in a more timely and efficient manner. If you need any help in this regard, please let me know.

For a complete list of Microsoft Customer Support Services phone numbers, please go to the following address on the World Wide Web:
<http://support.microsoft.com/directory/overview.asp>

If you are outside the US please see http://support.microsoft.com for regional support phone numbers.

To work around the issue at present, you may want to use a different column as primary key or add another identity column as the primary key for the tables.

Please feel free to let's know if you have any concerns or questions on this, please feel free to let's know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


.

Relevant Pages

  • 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)
  • Merge Replication and Stored Procedures
    ... 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 ... replication and both say that stored procedures (presumably to be run against ...
    (microsoft.public.dotnet.framework.compactframework)
  • RE: SQL CE merge replication erros
    ... perform update action during the merge replication process. ... SQL Server CE merge replication. ... Customer Support Services for the best support of mobile related ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.replication)
  • Re: Cant view merge agent properties (trying again)
    ... that you open a Support incident with Microsoft Product Support Services ... However, If you'd still like to continue working via the newsgroup, I want ... me know how do you configure the merge replication? ... You use your SQL CE as ...
    (microsoft.public.sqlserver.replication)
  • 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)