USE master
GO

/* Metti il db in single user mode */
ALTER DATABASE MIODB
SET SINGLE_USER 
WITH ROLLBACK IMMEDIATE
GO

/* Lo scolleghi dall'istanza */
EXEC sp_detach_db 'MIODB';
GO

/* Rinomini i files fisici */
!!ren "c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\OLD.mdf" "MIODB.mdf";
!!ren "c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\OLD_log.ldf" "MIODB_log.ldf";

/* Lo ricolleghi all'istanza */
EXEC sp_attach_db 'MIODB',
'C:\Programmi\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\MIODB.mdf',
'C:\Programmi\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\MIODB_log.ldf';
GO

/* Se vuoi modificare anche il nome logico dei files... */
ALTER DATABASE MIODB
MODIFY FILE (NAME = OLD, NEWNAME = MIODB);
GO

ALTER DATABASE MIODB
MODIFY FILE (NAME = OLD_log, NEWNAME = MIODB_log);
GO

/* Reimposti l'accesso multiutente */
ALTER DATABASE MIODB 
SET MULTI_USER 
GO

/* Verifica */
EXEC sp_helpdb 'Pippo2'
GO