sqlsql-server-2008sql-scriptsfilegroup

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

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.

Solution

  • We are using APEXSQL BUILD!! problem solved!