Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


What is the proper syntax for sql ce max db size?

Posted on 2008-11-07
Medium Priority
Last Modified: 2012-08-14
Hello all:

    Here is my problem.  Microsoft.   I use a SQL CE database in my application and it works fine but microsoft defaults the database size to 256mb.  I know SQL ce can use databases much much larger than this.  Somewhere in the 4 gig range max I think.  My question is what is the syntax for the connection string to set the max size?
Here is my current connection string
const ConSting = "Data Source = C:\Program Files\MyAppFolder\MyAppDB.sdf; password = MyAppDBPassword"
To me this is an idiotic setting it seems like if you wanted to limit the size of the db you would have to over ride the default max db size of 4gig not the other way around.

Thanks in advance
Question by:MedSouth
  • 2
LVL 21

Expert Comment

ID: 22907010
LVL 21

Accepted Solution

oleggold earned 2000 total points
ID: 22907020
from there,set Max Database Size=4090

Author Closing Comment

ID: 31514428
Thanks for the help and sorry it took so long to get back with you.  It works great now.

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question