SQL Server Autogrowth settings
08-Nov-1010 Leave a comment
Do not use default setttings. See
http://support.microsoft.com/kb/315512
You can view the current settings through the database properties in SQL Enterprise Manager (SEM). Or, you can run the following Transact-SQL command:
sp_helpdb [ [ @dbname= ] 'name' ]