SQL Server Express Database automatic deployment problem and resolution

express|server| Solution | data | database | problem

A few days ago, a program, VS. + SQL Server Express, looked over the documentation and found that SQL Server Express supports XCOPY deployments, that is, as long as the target computer has SQL Server Express, you only need to A copy of the database can be used in the same directory in the program, and then configure the AttachDbFileName parameter in the connection string. The database is automatically attached to SQL Server Express and automatically deattch when it is finished. It feels good, suit. An error occurred: "The database has been compressed and cannot be created and needs to be decompressed." Dizzy, when did you compress it? Is it a question of shinrk? For n hours, no solution, sleep.

The next day to war, access to information no solution, access the Internet without solution, want to give up, and reluctant. Inadvertently found that the Attach database in the management interface is also this error, and in the original directory of the database is not a problem. Copying the database to the program directory (D: disk, SQL Server Express installed on the C: disk) will make an error. That's not the problem, is it?

Move the program directory to C disk, incredibly all normal, and then completely dizzy death. Does the automatic hook database have to be in C disk???

Alternatively, if you set the database file to read-only, you can hook it up to a read-only database, regardless of which disk you are on.

Although solves the problem, but does not understand the principle, is the Bug, still is my system question?

In fact, Sybase SQL Anywhere is really good, when the database started to start the database management system, the system runs out, the database management system automatically ended, if SQL Server Express also support this feature is good, I don't like it. There is also a SQL Server service running when the database is not used. Access doesn't even support stored procedures, Microsoft, it's not easy to say love you.