Deprecated features

  • Comments posted to this topic are about the item Deprecated features

    Thanks

  • ANSI_PADDING also has the same deprecated warning

    http://msdn.microsoft.com/en-us/library/ms187403.aspx

  • 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

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

    ANSI_PADDING is also a correct answer !!!!!

  • 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 am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------
  • 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

  • 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.

    http://msdn.microsoft.com/en-us/library/ms187403.aspx

  • Nice question!

  • 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

  • Thanks for the good Q, but 2 answers are possible.

    Regards

  • *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.

  • 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


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • 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.

  • I like the fact that the author spelled deprecated correctly. I'm tired of seeing it spelled depreciated. ๐Ÿ™‚

  • 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 29 total)

You must be logged in to reply to this topic. Login to reply