• Thanks for nice article.

    But, BOL is also using "sp_detach_db" command to describe attach database command as below:

    USE master;

    GO

    sp_detach_db Archive;

    GO

    CREATE DATABASE Archive

    ON (FILENAME = 'D:\SalesData\archdat1.mdf')

    FOR ATTACH ;

    GO

    Thanks