MSSQLTips.com - your daily source for SQL Server tips

Google
 
Web mssqltips.com

ESSENTIALS: Home | Tips | Search | Categories | Top 10 | Products | Authors | Blogs | Forums | Webcasts | Advertise | About
Browse by Tags -

in Search

Browse by Tags

All Tags » growth settings (RSS)
Sorry, but there are no more tags available to filter with.
  • Re: Unrestricted File Growth

    To do this using T-SQL you can issue this command: ALTER DATABASE Test MODIFY FILE ( NAME = Test , MAXSIZE = UNLIMITED ); GO This will change the "Test" data file to unlimited growth. To get the names of the data files runs this command: sp_helpdb "databaseName" i.e. sp_helpdb TEST...
    Posted to Forum by admin on 05-07-2008
Page 1 of 1 (1 items)