June 26, 2015 at 12:12 am
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
-- 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
Carlo Romagnano (6/26/2015)
-- Using credentials on database requires enabling traceflagDBCC 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
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.
June 29, 2015 at 12:44 am
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
Yeah Carlo, I noticed also that all options were wrong !
I had to be TRACEON !
June 29, 2015 at 2:50 am
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
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
Thank you for your question.
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy