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.
>