Prev: 728814 Reserch anything, nerw content up to date all sites 81
Next: Location Intelligence demo
From: Giri on 27 Mar 2010 02:05
You can set Autoshrink by using following system stored procedure.
Exec Sp_dboption 'Tempdb', 'Autoshrink', 'True'

From http://www.developmentnow.com/g/95_2004_3_0_0_378026/SQL-2000-SERVER--BIG-PROBLEM-WITH-BIG-DATABASE-.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/
From: Erland Sommarskog on 27 Mar 2010 06:09
Giri (girijesh.ipec(a)gmail.com) writes:
> You can set Autoshrink by using following system stored procedure.
> Exec Sp_dboption 'Tempdb', 'Autoshrink', 'True'

But don't do that! Autoshrink is a completely evil option. Shrinking databases should be done sparingly, and not at whim. And least of
all automatically.

This Connect item calls for deprecation of Autoshrink as well as some
more bad shrinking options.
https://connect.microsoft.com/SQLServer/feedback/details/486614/deprecate-all-shrink-database-options


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: 728814 Reserch anything, nerw content up to date all sites 81
Next: Location Intelligence demo