USE master;
GO
EXEC sp_detach_db @dbname = 'AdventureWorks';
EXEC sp_attach_single_file_db @dbname = 'AdventureWorks',
    @physname = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf';

     sp_configure 'allow updates',1
     go
     reconfigure with override
     go
     update sysdatabases set
        status=-32768 where dbid=DB_ID('fake')
     go
     sp_configure 'allow updates',0
     go
     reconfigure with override
     go

    dbcc rebuild_log('fake','h:\fake_log.ldf')
    go
    dbcc checkdb('fake') -- to check for errors
    go

    use master
    go
    sp_helpdb 'fake'
    go
    /* Make a note of the names of the files , you will need them
    in the next bit of the script to replace datafilename and
    logfilename - it might be that they have the right names  */
    sp_renamedb 'fake','your'
    go
    alter database your
        MODIFY FILE(NAME='datafilename', NEWNAME = 'your_data')
    go
    alter database PowerDVD301
        MODIFY FILE(NAME='logfilename', NEWNAME = 'your_Log')
    go
    dbcc checkdb('your')
    go
    sp_dboption 'your','dbo use only','false'
    go
    use your
    go
    sp_updatestats
    go

    sp_detach_db your
    --now rename the files then reattach
    sp_attach_db 'your','your.mdf','your.ldf'