How to determine the maximum size of the Temp file

Posted in Connection String | Connection String Reference June 29, 2019
Tags: Connection String, SqlConnection properties, SQL Server Compact Edition, .NET Compact Framework, Temp File.
This article gives information about various commands that are applied on temp file.
  • 2340
The temporary file is a file which is used for storing the values for a very short amount of time. It is created when the execution of the programs start and is removed/deleted when it's need is over. whenever a program is started to execute then by default 128MB is allocated for temp file. hence according to our convenience we can alter the size of the temp file by using the following command.
Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=ourDestination\urInfo.sdf;SSCE:Temp File Max Size=512;

Further Readings

  You may also want to read these related articles.

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.