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

Posted on 2008-11-07
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
    LVL 21

    Expert Comment

    LVL 21

    Accepted Solution

    from there,set Max Database Size=4090

    Author Closing Comment

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

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    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.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now