Microsoft KB Archive/905395

= A change to the Readme.htm file for SQL Server 2005 Compact Edition =

Article ID: 905395

Article Last Modified on 11/2/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Compact Edition

-



INTRODUCTION
This article describes a late-breaking change to the Readme.htm file in Microsoft SQL Server 2005 Compact Edition. These changes are not documented in the Readme.htm file.



Limitations on the HostName property and the Subscriber-requested snapshot
If you try to initialize a SQL Server Compact Edition subscription by using a filtered HostName property, initialization fails. This problem occurs when the value that is supplied for the HostName property contains more than 12 characters. To work around this problem, disable Subscriber-requested snapshot delivery at the Publisher. You can also use a value for the HostName property that contains fewer than 12 characters.

To disable Subscriber-requested snapshot delivery at the Publisher, follow these steps:  Right-click the Publication name, and then click Properties. In the Publication Properties dialog box, click Data Partitions. Click to clear the Automatically define a partition and generate a snapshot if needed when a new Subscriber tries to synchronize check box, and then click OK. Regenerate the snapshot:  Right-click the Publication, and then click View Snapshot Agent Status. In the View Snapshot Agent Status dialog box, click Start. </li></ol>

For more information, see the &quot;How to: generate a snapshot for a Merge Publication with parameterized filters (SQL Server Management Studio)&quot; topic in SQL Server 2005 Books Online. To download SQL Server 2005 Books Online, visit the following Microsoft Web site:

http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx

To obtain newsgroup support, to post questions, or to find solutions to SQL Server Compact issues, visit the following Microsoft Web site:

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=152&SiteID=1

Keywords: kbtshoot kbinfo KB905395

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.