USE [master]
GO
ALTER DATABASE SandBox ADD FILEGROUP onlyLookups
GO
ALTER DATABASE [SandBox] ADD FILE ( NAME = N'SandBox_Lookups', 
                                    FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\SandBox_Lookups.ndf' , 
                                    SIZE = 2048KB , 
                                    FILEGROWTH = 1024KB ) 
                         TO FILEGROUP [OnlyLookups]
GO
USE [SandBox]
GO
declare @readonly bit
SELECT @readonly=convert(bit, (status & 0x08)) FROM sysfilegroups WHERE groupname=N'OnlyLookups'
if(@readonly=0)
  ALTER DATABASE [SandBox] MODIFY FILEGROUP [OnlyLookups] READONLY
GO
USE [master]
GO
declare @readonly bit
SELECT @readonly=convert(bit, (status & 0x08)) FROM sysfilegroups WHERE groupname=N'OnlyLookups'
if(@readonly=0)
  ALTER DATABASE [SandBox] MODIFY FILEGROUP [OnlyLookups] READONLY
GO

--are we readwriteable or not?
USE [SandBox]
GO

--#################################################################################################
--toggle read only, add table, put it back
--#################################################################################################
declare @readonly bit
SELECT @readonly=convert(bit, (status & 0x08)) FROM sysfilegroups WHERE groupname=N'OnlyLookups'
if(@readonly=1)
  ALTER DATABASE [SandBox] MODIFY FILEGROUP [OnlyLookups] READWRITE
GO
--switch db context so we can alter
USE [master]
GO
declare @readonly bit
SELECT @readonly=convert(bit, (status & 0x08)) FROM sysfilegroups WHERE groupname=N'OnlyLookups'
if(@readonly=1)
  ALTER DATABASE [SandBox] MODIFY FILEGROUP [OnlyLookups] READWRITE
GO
--#################################################################################################
--add table
--#################################################################################################
USE [SandBox]
 GO
CREATE TABLE [dbo].[CITYDATA] ( 
[CITYNAME]      VARCHAR(28)                          NULL,
[COUNTYNAME]    VARCHAR(64)                          NULL,
[STATE]         VARCHAR(2)                           NULL,
[STATEFIPS]     VARCHAR(2)                           NULL,
[COUNTYFIPS]    VARCHAR(3)                           NULL,
[ZIPCODE]       VARCHAR(5)                           NULL,
[STATETBLKEY]   INT                                  NULL,
[COUNTYTBLKEY]  INT                                  NULL,
[CBSA]          AS ([STATEFIPS]+[COUNTYFIPS]))
ON onlyLookups

--#################################################################################################
--toggle read only back again
--#################################################################################################
 USE [SandBox]
GO
declare @readonly bit
SELECT @readonly=convert(bit, (status & 0x08)) FROM sysfilegroups WHERE groupname=N'OnlyLookups'
if(@readonly=0)
  ALTER DATABASE [SandBox] MODIFY FILEGROUP [OnlyLookups] READONLY
GO
USE [master]
GO
declare @readonly bit
SELECT @readonly=convert(bit, (status & 0x08)) FROM sysfilegroups WHERE groupname=N'OnlyLookups'
if(@readonly=0)
  ALTER DATABASE [SandBox] MODIFY FILEGROUP [OnlyLookups] READONLY
GO

We walk in the dark places no others will enter
We stand on the bridge and no one may pass