Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Creating databases

Author  Topic 

lisa_baria03
Yak Posting Veteran

60 Posts

Posted - 2007-10-13 : 23:41:22
When i create a database and later on want to add a file in it

Alter database db1
Add File
( Size = 2MB,
Maxsize = 5MB,
Filegrowth = 20%)

this gives me an error because there's no filename.
I would like to know if filename is mandatory?
Thanks as i got an error when running saying no filename.

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-10-13 : 23:46:26
filename is mandatory, that is what the error said!

read BOL for details on ALTER DATABASE

http://msdn2.microsoft.com/en-us/library/ms174269.aspx



-ec
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-14 : 01:36:38
And you can find lot of sample code in books online.
Go to Top of Page
   

- Advertisement -