• Jason, for an article on the benefits of alter database method and why it is the preferred method for SQL2005 onwards see here[/url]

    I would add another reason, with detach\attach the owner of the database can be changed, using alter database that will not happen.

    In a nutshell any metadata about a database held in master is lost when it is detached, but not when alter database is used

    ---------------------------------------------------------------------