Blog Post

Multiple ALTER DATABASE SET options

,

G’day,

Did you know that you can actually combine multiple SET operations into a single ALTER DATABASE statement.

It’s true, you can!

Mostly I never see this done.

Maybe it doesn’t make sense! maybe it’s just more readable if a single ALTER DATABASE statement contains a single SET operation! Maybe management studio has just got us into this habit of writing single ALTER DATABASE statements!

Whatever this reason I hardly ever see code that has one ALTER DATABASE statement with multiple SET operations – in fact mostly that’s the format I stick to myself – but just for the record,

The following set of TSQL statements

ALTER DATABASE [AdventureWorks2008] SET RECOVERY simple;
ALTER DATABASE [AdventureWorks2008] SET PAGE_VERIFY CHECKSUM;
ALTER DATABASE [AdventureWorks2008] SET MULTI_USER;
ALTER DATABASE [AdventureWorks2008] SET ONLINE;
GO

can actually be combined into a single statement

ALTER DATABASE [AdventureWorks2008]
SET
RECOVERY simple,
PAGE_VERIFY CHECKSUM,
MULTI_USER,
ONLINE;
GO

guess this comes down to personal choice in the end :)

Click here for the books online article if you require any further reading.

Have a good day

Cheers

Martin.

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating