This is from the TSQL docs. You can get it by selecting Transact
SQL Help from the HELP pull down menu in isql_w or Enterprise manager.
DISK RESIZE
NAME = logical_device_name,
SIZE = final_size
where
logical_device_name
Specifies the database device to resize.
final_size
Is the final size to which the device should be expanded, specified in 2K
pages.
Remarks
Examples
A. Increase the Size of a Device
This example increases the size of DEVICE1 from it's initial size of 12 MB to 20
MB.
DISK RESIZE
NAME = 'DEVICE1',
SIZE = 10240
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com