Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
asarak
Starting Member
36 Posts |
Posted - 2005-11-21 : 02:59:43
|
Hi fellows,i would like to change the Autoshrink status from ON to OFF and viceversa, i just found only how to check what the status is with SELECT DATABASEPROPERTY('myDatabase', 'isAutoshrink')Is there anybody to know how to change it (not by Enterprise manager)just with a query.Thanks a lot ASARAK |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-11-21 : 03:09:04
|
use sp_dboption @dbname, 'autoshrink', TRUEcheck out the Book Online for details[KH] |
|
|
asarak
Starting Member
36 Posts |
Posted - 2005-11-21 : 03:16:23
|
Thanks a lot Khtan, it is working fine |
|
|
|
|
|