SQL

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.

Advertisement

Published by

isalom

I was born in Barranquilla, Colombia in 1975. When I was 17 I moved to Curacao where I lived 10 years and then move to The Hague, The Netherlands. I speak 4 languages (Dutch, English, Papiamento and Spanish). I'm a Systems Engineer graduated from The Hague University (http://www.thehagueuniversity.com/). I have been working in IT for over 15 years. Since November 2014 I started www.cenlinea.com a webportal were the focus is to make learning more fun. At Cenlinea we are currently promoting PLAYDIOM a new methodology to learn English. While currently working part-time time at Cenlinea, I am also working as Senior Princiapal Consultant at www.ccgroep.com which helps me to keep up to date with Microsoft SQL Server, which I consider to be one of my favorite things in life as it has changed my life in many ways. I hope you enjoy my blog and if you want to send a question, just drop me a mail at ignacio.salom@cenlinea.com or ignacio@ccgroep.com

Leave a Reply

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

Gravatar
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 )

Cancel

Connecting to %s