SQL SERVER 2005 /Database/Resize

[gandalf_le_blanc]

Hi, The actual size of my database isn't enought, autogrow is activate and I can change the parameters but I want to increase from 6Go to 50Go. Do you know if there is a command or a procedure to resize the size of the database without to recreate a database. Best regards -- modified at 9:05 Tuesday 20th November, 2007

[Kishore P]

Using enterprise manager you can change the database file grow size or use ALTER DATABASE command. see SQL Server 2005 BOL.