How to set autoshrink off?


I hope you already know the answer to this question, but if you don’t know the answer, here it is:

1- Open SQL Server Management Studio.

2- Connect to the SQL server.

3- Right click on the database.

4- Select properties.

5- Select options.

6- On “Auto Shrink” set the value to “false”.

7- Click on “OK”.

I hope it helps. There are many other options you can change, I advise you to check SQL Server Books Online before you change anything.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s