Connect to Server (Connection Properties Page) SQL Server Compact
Use this tab to view or specify options when connecting to Microsoft SQL Server Compact 3.5 SP2. or registering SQL Server Compact 3.5 SP2 in Registered Servers. Connect and Options only appear in this dialog box when connecting. Test and Save only appear in this dialog box when registering SQL Server Compact 3.5 SP2.
Enter the number of seconds to wait for a connection to be established before timing out. The default value is 15 seconds.
Enter the amount of time in seconds to wait before execution of a task is completed on the server. The default value is zero seconds, which indicates there is no time-out.
Maximum database size
Default size is 128 MB.
Default lock escalation
Default value is 100 locks.
Replace all manually entered connection property values with the default values.
Attempt a connection using the listed values.
Click to change the dialog and hide the additional server connection options, such as remembering the password.
When registering SQL Server Compact 3.5 SP2 in Registered Servers, click to test the connection.
Saves the settings in Registered Servers.
SQL Server Management Studio does not support SQL Server Compact 4.0.