• If you have replication set up it won't let you detach, you have to drop replication first.

    Andy

    http://qa.sqlservercentral.com/columnists/awarren/