database-scoped credential (SQL2016 CTP2)

  • psingla

    Hall of Fame

    Points: 3840

    Comments posted to this topic are about the item database-scoped credential (SQL2016 CTP2)

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014

    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

  • Carlo Romagnano

    SSC-Insane

    Points: 21987

    -- Using credentials on database requires enabling traceflag

    DBCC TRACEON(4631,-1)

    Instead of

    -- Using credentials on database requires enabling traceflag

    DBCC TRACEOFF(4631,-1)

  • TomThomson

    SSC Guru

    Points: 104773

    Carlo Romagnano (6/26/2015)


    -- Using credentials on database requires enabling traceflag

    DBCC TRACEON(4631,-1)

    Instead of

    -- Using credentials on database requires enabling traceflag

    DBCC TRACEOFF(4631,-1)

    And that is 100% clear in the page given as reference in the explanation. Seems a very strange error in the question. Or is it a very strange error in the referenced page? Given how many errors BOL manages to have another one wouldn't be a big surprise.

    Anyway, it would be nice to see an SQL 2016 version of the Trace Flags page.

    Tom

  • Ed Wagner

    SSC Guru

    Points: 286982

    Agreed, Tom - an updated go to page would be nice. Not too sure about turning a flag on by turning it off, but we all make mistakes. That's why we test.

  • This was removed by the editor as SPAM

  • psingla

    Hall of Fame

    Points: 3840

    Sorry Guys! It's my bad, I was testing this traceflag and by mistake I pasted traceoff instead of traceon.

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014

    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

  • Arno Kwetters

    Hall of Fame

    Points: 3383

    Yeah Carlo, I noticed also that all options were wrong !

    I had to be TRACEON !

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Thanks for the question.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • SQLRNNR

    SSC Guru

    Points: 281243

    psingla (6/29/2015)


    Sorry Guys! It's my bad, I was testing this traceflag and by mistake I pasted traceoff instead of traceon.

    Easy enough mistake but it could cause a bit of confusion.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thank you for your question.

Viewing 10 posts - 1 through 10 (of 10 total)

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