Home Forums SQL Server 2005 SQL Server Express detach multiple databases using sp_detach_db RE: detach multiple databases using sp_detach_db

  • December 10, 2012 at 6:59 am

    #1567019

    sri6sri6 (12/10/2012)

    I ahve modified the querry as the execution satement was missing in it.

    It wasn't missing. The script you refer to generated the sp_detach statements, allowing someone to copy the output, check it over and then run it.

    p.s. 4 year old thread.

    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