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
 Filegroup Rename?

Author  Topic 

richardps
Starting Member

33 Posts

Posted - 2007-09-10 : 04:21:21
Hi,

Is there a way to rename a Filegroup "FG1" to "FG2"?

For those interested, I'm trying to script a sliding window procedure for my partitioned table and rather than use dynamic SQL I'd like to always refer to the same Filegroup name (ie. "FG1").

Many thanks,
Richard.

PeterNeo
Constraint Violating Yak Guru

357 Posts

Posted - 2007-09-10 : 05:44:04
check "ALTER DATABSE <dbname> MODIFY FILE" sysntax in BOL, it may help u
Go to Top of Page
   

- Advertisement -