· 8 years ago · Dec 21, 2017, 01:20 PM
1USE [StackExchange]
2GO
3ALTER DATABASE [StackExchange] ADD FILE ( NAME = N'StackExchange_DefRO', FILENAME = N'C:SQLSQL_DATAStackExchangeRO.ndf' , SIZE = 5120KB , FILEGROWTH = 1024KB ) TO FILEGROUP [DEFAULTRO]
4GO
5
6USE [master]
7GO
8declare @readonly bit
9SELECT @readonly=convert(bit, (status & 0x08)) FROM sysfilegroups WHERE groupname=N'DEFAULTRO'
10if(@readonly=0)
11 ALTER DATABASE [StackExchange] MODIFY FILEGROUP [DEFAULTRO] READONLY
12GO
13
14GO
15USE [StackExchange]
16GO
17IF NOT EXISTS (SELECT name FROM sys.filegroups WHERE is_default=1 AND name = N'DEFAULTRO') ALTER DATABASE [StackExchange] MODIFY FILEGROUP [DEFAULTRO] DEFAULT
18GO
19
20USE [StackExchange]
21GO
22
23/****** Object: Table [dbo].[NewTable] Script Date: 21.12.2017 14:12:11 ******/
24SET ANSI_NULLS ON
25GO
26
27SET QUOTED_IDENTIFIER ON
28GO
29
30CREATE TABLE [dbo].[NewTable](
31 [ID] [int] NULL,
32 [Test] [nchar](10) NULL
33)
34
35GO
36
37Msg 1924, Level 16, State 2, Line 11
38Filegroup 'DEFAULTRO' is read-only.