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.
NAME = logical_device_name,
SIZE = final_size
Specifies the database device to resize.
Is the final size to which the device should be expanded, specified in 2K
A. Increase the Size of a Device
This example increases the size of DEVICE1 from it's initial size of 12 MB to 20
NAME = 'DEVICE1',
SIZE = 10240
-- Dale E. Reed Jr. (firstname.lastname@example.org)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com