Maximum size of the database in SQL Server Mobile OLEDB

This article deals with commands that can be used to determine maximum size of SQL Server Mobile OLE DB Providers in .NET Compact Framework.
  • 2438

Database is a ordered collection of data made by the user for his/her convenience. When a database is created then by default maximum of 128MB is allocated by the server. The maximum size of the database is by default 128 MB. But we can change this maximum limit by using the following code. 

Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=myPath\myData.sdf;SSCE:Max Database Size=256;

Ask Your Question 

Got a programming related question? You may want to post your question here

Programming Answers here

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.