View Single Post
  #2 (permalink)  
Old December 7th, 2006, 01:25 AM
ghemant ghemant is offline
Registered User
 
Join Date: Dec 2006
Location: Pune, Maharashtra, India.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to ghemant
Default

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
Reply With Quote