declare @newfilegroup varchar(60)

set @newfilegroup = substring(CONVERT(VARCHAR, DATEPART(YEAR, GETDATE())), 3, 4)

EXEC ('ALTER DATABASE northwind ADD FILEGROUP [' + @newfilegroup + ']')

It needs to be wrapped in the [ ].

My guess (note, guess) is that filegroup names cannot start with a number.

I think you should consider doing your own homework. 🙂

Oh jeez, somehow I missed these replys.

homebrew01: The issue is that, as Paul Randal said, the metadata requires X for space, even tho, it may only use X-Y. ...

Okay - I have a followup question, as I am trying to do this myself, only from standard 2005 to enterprize 2005 - What sort of downtime could be expected?...

Did this work for you?

http://cwashington.netreach.net/depo/view.asp?Index=869

I think I originally found this somewhere on SSC, but here is the link:

It is not TSQL based, but can be modified to get what you want.

can you give some sample data that you are seeing?

Hey Steve -

I have been working in this all day, and I realized that when I am in a forum, it states the time at the bottom,

"All times...

YES, searching scripts / forums / articles was easier before...

Otherwise, I really like it!

I cannot find the SEARCH - I see the goggle search, but I liked the search articles / scripts / forums...

I use a variety of tools from Idera.  Diagnostic Manager for quick overview of DB Perfomance, Mobile Manager for overview and administration on the go, Change Management for watching what...

This looks really good...now, I need to understand what infomation I have here...still looking.

THANKS!

C

Because mistakes tend to be made pushing scripts like this, I require a USE <DBNAME> to start all the scripts I run...its safer, and, would solve this issue...

search this site I found this:

http://sql-articles.com/articles/lship/fail-lship.htm.

good luck!