Microsoft KB Archive/912907

= How to specify the location of a temporary database in SQL Server 2005 Compact Edition =

Article ID: 912907

Article Last Modified on 5/3/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Compact Edition

-



SUMMARY
In Microsoft SQL Server 2005 Compact Edition, you may perform some operations that require a large temporary database. In this case, you should explicitly specify a location that has sufficient storage space to hold the temporary database. If you do not specify a location, applications will fail when one of the following conditions is true:
 * The temporary database grows to a point that the storage space on the default storage device is insufficient.
 * The maximum temporary database limit is reached.

In SQL Server 2005 Compact Edition, every database has one temporary database.



MORE INFORMATION
To specify a location for a temporary database in SQL Server 2005 Compact Edition, see the following topics in SQL Server 2005 Compact Edition Books Online.

Note You must have SQL Server 2005 Compact Edition Books Online installed before you can view these topics. To download SQL Server 2005 Compact Edition Books Online, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyId=E6BC81E8-175B-46EA-86A0-C9DACAA84C85&displaylang=en

 An introduction to the temporary database in SQL Server 2005 Compact Edition

ms-help://MS.SSCE.v31.EN/ssmmain3/html/20c426a5-c679-478b-917c-8f586cc1c766.htm

 How to programmatically specify the location of the temporary database by using OLE DB

ms-help://MS.SSCE.v31.EN/ssmprog3/html/54ea9a11-09e2-4998-934d-e3bc0efeb434.htm

 How to programmatically specify the location of the temporary database by using ADO.NET

ms-help://MS.SSCE.v31.EN/ssmprog3/html/19fe2057-1b72-44e5-909f-3508f82cbd9a.htm

 How to programmatically specify the location of the temporary database by using the replication object and the remote data access (RDA) object

ms-help://MS.SSCE.v31.EN/ssmprog3/html/a5b1900a-daad-4844-a47c-25e91175b3ba.htm



