Use the default database path to create a filegroup in a script sql server 2008

Question

Quick question, it is possible to include in a SQL Script something like this?

IF FILEGROUP_ID('FG') IS NOT NULL
ALTER DATABASE [MYDB]
ADD FILE (Name=[FG_DATA], Filename='{My default server path}') TO FILEGROUP [FG]
GO

The idea is to create a script in development that when promoted to production it can be used without changing anything.

we are running the scripts directly in Management Studio and we also create the scripts form it. — Ray, Sep 25 '14 at 15:19

score 1 · Accepted Answer · answered Dec 31 '14 at 05:09

1

We are using APEXSQL BUILD!! problem solved!

answered Dec 31 '14 at 05:09

Ray

1 Answers1