Post reply

sp_attach_db with ATTACH AS

  • January 19, 2012 at 9:57 pm

    #266911

    Hi,

    I wanted to know how do I use sp_attach_db for attaching EDM with "attach as" option.

    Thanks,

    Ankit

    ______________________________________________________________________

    Ankit
    MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
    "Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
    You are already naked. There is no reason not to follow your heart.”

  • January 20, 2012 at 1:26 am

    #1436306

    Well, firstly you don't use sp_attach_db as it it deprecated. Use CREATE DATABASE <new database name> .... FOR ATTACH

    What do you mean 'attach as'?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 20, 2012 at 2:23 am

    #1436322

    Thanks Gila monster ..I used Create Database and it works fine ... thanks for your guidance 🙂

    ______________________________________________________________________

    Ankit
    MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
    "Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
    You are already naked. There is no reason not to follow your heart.”

Viewing 3 posts - 1 through 2 (of 2 total)

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