CDC Administration

  • free_mascot

    One Orange Chip

    Points: 27168

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

  • Mr. Kapsicum

    SSCertifiable

    Points: 6128

    Good Question. Thanks

  • Koen Verbeeck

    SSC Guru

    Points: 258985

    Nice one, thanks.

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

  • This was removed by the editor as SPAM

  • Hugo Kornelis

    SSC Guru

    Points: 64685

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


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • This was removed by the editor as SPAM

  • Ed Wagner

    SSC Guru

    Points: 286985

    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.

  • Xavon

    SSCrazy

    Points: 2280

    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.

  • SQLRNNR

    SSC Guru

    Points: 281252

    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

  • webrunner

    SSC-Dedicated

    Points: 30368

    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

  • John Hanrahan

    Hall of Fame

    Points: 3825

    I got it right but it only applies to the enterprise/developer/eval versions of SQL 2014. CDC is not available in other versions.

  • sestell1

    SSChampion

    Points: 10230

    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:

  • Revenant

    SSC-Forever

    Points: 42467

    I went with my gut feeling... Thanks, Free Mascot!

  • Damian Widera-396333

    Ten Centuries

    Points: 1186

    Good one!

    Kindest Regards,

    Damian Widera
    SQL Server MVP,
    MCT, MCSE Data Platform, MCSD.NET

  • TomThomson

    SSC Guru

    Points: 104773

    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 17 total)

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