Mega Code Archive
Categories
/
MSSQL
/
Database
Autoshrink
1> --autoshrink: 'True' indicates this database can be shrunk in size safely. 2> CREATE DATABASE myDatabase; 3> EXEC sp_dboption 'myDatabase', 'autoshrink', 'False' 4> GO 1> 2> Drop database myDatabase 3> GO 1>