Detaching restrictions

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715344

    Comments posted to this topic are about the item Detaching restrictions

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Thank you, Steve, for the post, really good one. (I was sure on what to select by practice)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • SQL_Hunt

    SSC-Dedicated

    Points: 33264

    Very nice Brain Teaser.

    Thanks.

  • This was removed by the editor as SPAM

  • Koen Verbeeck

    SSC Guru

    Points: 258924

    Nice question, thanks Steve.

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

  • patricklambin

    SSCrazy Eights

    Points: 9964

    I was lucky to find the good answer. The only two things I was sure was that it was impossible to create snapshots of system or mirrored databases. It is true that I am using now only Express Editions and snapshots are authorized only with Enterprise/Developer editions.

    As system databases case was appearing only in the last choice , the "good" answer was evident.

    Any way , a good question... Thanks as I have learnt something today.

  • Hany Helmy

    SSChampion

    Points: 13321

    Gr8 question, thanx.

  • RK Mandava

    SSCarpal Tunnel

    Points: 4152

    Nice question, thanks

  • webrunner

    One Orange Chip

    Points: 29896

    Thanks for the thought-provoking question!

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and says Can I join you?
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • Andre Ranieri

    SSCrazy

    Points: 2759

    Nice question, thanks Steve.

  • Hugo Kornelis

    SSC Guru

    Points: 64645

    Based on how database snapshots work, it was obvious that this had to be one of the restrictions. That immediately narrowed my options down to just one choice.


    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/

  • shane.green 1227

    SSC Enthusiast

    Points: 150

    Good question, although the answer was given away because there was only one answer with "system database". If you had included system database into the list earlier I would not have "guessed" it (I have not had any experience with replication or mirroring yet:-()

  • TomThomson

    SSC Guru

    Points: 104765

    shane.green 1227 (2/3/2015)


    Good question, although the answer was given away because there was only one answer with "system database". If you had included system database into the list earlier I would not have "guessed" it (I have not had any experience with replication or mirroring yet:-()

    Yes, system databases was a giveaway. But so was having a snapshot (as Hugo pointed out). So it wasn't just given away, it was doubly given away.

    Tom

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the question.

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

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