Checking for an existing filegroup using T-SQL

[ashvn]

Hi,

Is it possible to use T-SQL to know if a specific filegroup already exists? If so, how can this be done?

Thanks!!

 

[hmckillop]

you can use the function filegroup_id() to get an id of a filegroup. This returns NULL if filegroup doesnt exist.


"I'm living so far beyond my income that we may almost be said to be living apart

 

[ashvn]

Thanks hmckillop, that made the job!