April 29, 2015 at 10:36 pm
Comments posted to this topic are about the item CDC Administration
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 30, 2015 at 12:11 am
Good Question. Thanks
April 30, 2015 at 3:14 am
Nice one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 30, 2015 at 5:00 am
This was removed by the editor as SPAM
April 30, 2015 at 5:49 am
Stewart "Arturius" Campbell (4/30/2015)
Interesting question, thanks...Now i'm wondering why this might be required, given the temporary nature of objects in tempdb...:-P
I am convinced that it will never be required.
When I saw the question, my initial thought was "please let the answer be no".
April 30, 2015 at 6:02 am
This was removed by the editor as SPAM
April 30, 2015 at 6:10 am
Nice question. I didn't see a case where it would be required either, so I'm glad I wasn't just being short-sighted about it.
April 30, 2015 at 6:37 am
Situation where this would be used... A sproc that creates a global temporary table, calls other sprocs on separate threads to populate/update that table and uses CDC to monitor their progress?
Nah, that's too convoluted.
I guessed yes, because I thought this was just the sort of feeping creaturism that I have come to expect from M$. Live and learn.
April 30, 2015 at 7:51 am
I was worried that logic on the question would be contradictory to reality.
CDC in tempdb makes no sense.
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
April 30, 2015 at 8:08 am
Thanks, good question.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
April 30, 2015 at 9:41 am
I got it right but it only applies to the enterprise/developer/eval versions of SQL 2014. CDC is not available in other versions.
April 30, 2015 at 11:57 am
Hugo Kornelis (4/30/2015)
Stewart "Arturius" Campbell (4/30/2015)
Interesting question, thanks...Now i'm wondering why this might be required, given the temporary nature of objects in tempdb...:-P
I am convinced that it will never be required.
When I saw the question, my initial thought was "please let the answer be no".
Mine too, but I was then surprised to find the stored procedures to enable it within the TempDB database. :blink:
Based on that, I answered incorrectly. :ermm:
April 30, 2015 at 1:33 pm
I went with my gut feeling... Thanks, Free Mascot!
May 1, 2015 at 8:09 am
Good one!
Kindest Regards,
Damian Widera
SQL Server MVP,
MCT, MCSE Data Platform, MCSD.NET
May 1, 2015 at 11:47 am
Hugo Kornelis (4/30/2015)
Stewart "Arturius" Campbell (4/30/2015)
Interesting question, thanks...Now i'm wondering why this might be required, given the temporary nature of objects in tempdb...:-P
I am convinced that it will never be required.
When I saw the question, my initial thought was "please let the answer be no".
I feel much the same. But I'm a bit worried - it doesn't work for tempdb because it doesn't work for system databases, but maybe in the future that will have to change because people may want it for MSDB - and if that's done just by dropping the restriction maybe it will accidently be made possible for tempdb (and master and model and resource too).
Tom
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply