August 13, 2011 at 1:29 pm
Comments posted to this topic are about the item Deprecated features
Thanks
August 13, 2011 at 1:31 pm
ANSI_PADDING also has the same deprecated warning
August 14, 2011 at 2:11 pm
This, unfortunately, needs two correct options, not one.
From Books Online (SQL 2008 R2)
In a future version of SQL Server, ANSI_NULLS will always be ON and any applications that explicitly set the option to OFF will generate an error. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
and
In a future version of Microsoft SQL Server ANSI_PADDING will always be ON and any applications that explicitly set the option to OFF will produce an error. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 15, 2011 at 1:46 am
Hello,
ANSI_PADDING is also a correct answer !!!!!
August 15, 2011 at 2:26 am
ANSI_PADDING should also be a correct answer!
Below from BOL;
In a future version of Microsoft SQL Server ANSI_PADDING will always be ON and any applications that explicitly set the option to OFF will produce an error. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
August 15, 2011 at 3:21 am
chris.mcgowan (8/15/2011)
ANSI_PADDING should also be a correct answer!Below from BOL;
In a future version of Microsoft SQL Server ANSI_PADDING will always be ON and any applications that explicitly set the option to OFF will produce an error. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
I agree, with you. The ANSI_PADDING was my first option as I knew it was deprecated.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
August 15, 2011 at 3:22 am
I thought this was ansi padding too, so got a wrong answer slightly unfairly 🙁 as I thought as only one would be possible I did not need to consider any other answers.
August 15, 2011 at 3:32 am
Nice question!
August 15, 2011 at 4:16 am
Important subject, good question, wrong answer - it should allow two answers to be ticked.
As it only allows one item to be ticked, all the people who chose ansi padding should be given a point as well as those who made the same arbitrary choice as the question setter.
Tom
August 15, 2011 at 4:37 am
Thanks for the good Q, but 2 answers are possible.
Regards
August 15, 2011 at 5:13 am
*whew* I'm SO glad I wasn't the first to notice that this was true for Ansi padding too... I was afraid I'd missed some slight trick of the working.
August 15, 2011 at 5:22 am
ANSI_PADDING and ANSI_NULLS are options that will be ON!!! like too CONCAT_NULL_YIELDS_NULL
ANSI_NULLS = http://msdn.microsoft.com/en-us/library/ms188048.aspx
ANSI_PADDING = http://msdn.microsoft.com/en-us/library/ms187403.aspx
CONCAT_NULL_YIELDS_NULL= http://msdn.microsoft.com/en-us/library/ms176056.aspx
August 15, 2011 at 5:44 am
Yet another poorly researched question.
ANSI_PADDING should also be a correct answer:
http://msdn.microsoft.com/en-us/library/ms187403.aspx
In a future version of Microsoft SQL Server ANSI_PADDING will always be ON and any applications that explicitly set the option to OFF will produce an error.
Trevor.
August 15, 2011 at 6:16 am
I like the fact that the author spelled deprecated correctly. I'm tired of seeing it spelled depreciated. 🙂
August 15, 2011 at 6:36 am
Glad I went with the first option of ANSI_NULLS and got my point.
http://brittcluff.blogspot.com/
Viewing 15 posts - 1 through 15 (of 28 total)
You must be logged in to reply to this topic. Login to reply