Viewing 9 posts - 1 through 9 (of 9 total)
Great question, but I think the answer is incorrect.
The first reference states "This setting is ON for all system databases. tempdb is the only system database that supports OFF."
😉
February 14, 2017 at 1:24 am
Good question Steve, but the reference supplied specifically states that Transparent Data Encryption is not available on Standard Edition.
😀
December 8, 2016 at 10:01 pm
Option 4 does not work as there is no orderstatus column.
Should have been ADD instead of ALTER COLUMN
😉
December 30, 2015 at 4:05 am
On SQL 2012 I get script B before and after inserting the data.
Microsoft SQL Server 2012 (SP1) - 11.0.3153.0 (X64)
Jul 22 2014 15:26:36
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit)...
June 3, 2015 at 11:28 pm
Thanks Steve. A tricky question.
The MSDN library on this is contradicting.
The first article in the links below states
An availability group supports a set of read-write primary databases...
April 23, 2014 at 11:49 pm
Great question...
The specified article specifies under 'Limitations and Restrictions' that indexes are not transferred to the new table and has to be created after executing the SELECT... INTO..
Limitations and Restrictions
You...
March 12, 2014 at 12:01 am
February 21, 2014 at 3:14 am
Viewing 9 posts - 1 through 9 (of 9 total)