Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Databases (Level 1)

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.

© 2015 Microsoft