From: Giri on
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
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