Databases (Level 1)

Installing SQL Server

Installing SQL Server
Databases (Level 1)
SQL Server 6.x SQL Server 2000
The ON database_device = size clause of ALTER DATABASE specified the amount of space, in megabytes (MB), allocated to the database extension and could be used following DISK INIT to alter the database device size. If the file was not created originally by DISK INIT, the ON database_device = size syntax cannot be specified with ALTER DATABASE. Instead, use the MODIFY FILE clause of ALTER DATABASE to alter the size of a database file. Remove all references of the ON database_device = size clause of ALTER DATABASE. For more information, see ALTER DATABASE.