6

Quick context of my problem, some of our compact databases in production are going corrupt and we need to do investigate the cause. I found some great pointers here, one of them being "Turn off Auto-Shrink".

So my question is How do I check what my Auto Shrink level is on an existing compact database?

With Sql Server I can use sys.databases as follows:

SELECT
   name,
   is_auto_shrink_on
FROM sys.databases

But alas sys.database does not exist in SQL Compact (understandably so).

I've read here at MSDN that you can set the Auto_Shrink value in the connection string and they mention that the default Auto_Shrink value is 60. This is great, but in my case I need to find out what the Auto_Shrink is on an existing database, not change it.

Does Auto_Shrink perhaps work differently with a compact database and I am misunderstanding it?

Community
  • 1
  • 1
Niels Filter
  • 4,430
  • 3
  • 28
  • 42

1 Answers1

1

It is specified as a per session setting, so you need to look at the connection string in use.

It is also important the client uses the latest SQL Compact enigine binaries.

ErikEJ
  • 40,951
  • 5
  • 75
  • 115