Cacher is the code snippet organizer for pro developers

ALTER DATABASE [dbName] SET EMERGENCY
ALTER DATABASE [dbName] SET MULTI_USER
EXEC sp_detach_db 'dbName'

EXEC sp_attach_single_file_db @dbname = 'dbName', 
     @physname = N'F:\Data\dbName.mdf'