Post reply

Detaching restrictions

  • February 2, 2015 at 8:39 pm

    #74266

    Comments posted to this topic are about the item Detaching restrictions

  • February 3, 2015 at 12:13 am

    #1774947

    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.

  • February 3, 2015 at 12:23 am

    #1774949

    Very nice Brain Teaser.

    Thanks.

  • February 3, 2015 at 1:33 am

    This was removed by the editor as SPAM

  • February 3, 2015 at 1:40 am

    #1774961

    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

  • February 3, 2015 at 2:27 am

    #1774969

    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.

  • February 3, 2015 at 4:00 am

    #1774978

    Gr8 question, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • February 3, 2015 at 7:06 am

    #1775018

    Nice question, thanks

  • February 3, 2015 at 8:10 am

    #1775038

    Thanks for the thought-provoking 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

  • February 3, 2015 at 9:15 am

    #1775059

    Nice question, thanks Steve.

  • February 3, 2015 at 10:24 am

    #1775079

    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/

  • February 3, 2015 at 1:47 pm

    #1775140

    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:-()

  • February 3, 2015 at 6:09 pm

    #1775175

    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

  • February 5, 2015 at 7:55 am

    #1775699

    Thanks for the question.

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

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