Post reply

database-scoped credential (SQL2016 CTP2)

  • June 26, 2015 at 12:12 am

    #319405

    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/

  • June 26, 2015 at 2:14 am

    #1808328

    -- Using credentials on database requires enabling traceflag

    DBCC TRACEON(4631,-1)

    Instead of

    -- Using credentials on database requires enabling traceflag

    DBCC TRACEOFF(4631,-1)

  • June 26, 2015 at 5:06 am

    #1808352

    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

  • June 26, 2015 at 6:00 am

    #1808364

    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.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • June 26, 2015 at 9:24 am

    This was removed by the editor as SPAM

  • June 29, 2015 at 12:44 am

    #1808668

    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/

  • June 29, 2015 at 1:50 am

    #1808674

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

    I had to be TRACEON !

  • June 29, 2015 at 2:50 am

    #1808683

    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

  • June 29, 2015 at 12:38 pm

    #1808889

    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

  • July 2, 2015 at 8:19 am

    #1809901

    Thank you for your question.

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

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