Hi,
definately you can do this with alter database statement e.g.
USE master
GO
ALTER DATABASE Testdb
MODIFY FILE
(NAME = TestDB,
SIZE = 20MB)
GO
but why do you wants do this !? any specific reason!? And test this on development envrionment first as precasion.
With Regards
Hemantgiri S. Goswami
------------------------
"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" -Hemantgiri S. Goswami
|