Devices (Level 4)
| SQL Server 6.x | SQL Server 2000 |
|---|---|
| The DISK RESIZE statement altered the size of a database device. | The DISK RESIZE statement is supported, but may not be supported in future releases. In addition, the DISK RESIZE statement does not alter the size of the database. Instead, use ALTER DATABASE.
Expect different results as compared to earlier versions of Microsoft® SQL Server™. Use the MODIFY FILE clause of the ALTER DATABASE statement to alter the size of a database. |