ALTER DATABASE smso SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO restore database smso from disk=@disk with replace ,move 'smso' to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\smso.mdf', move 'smso_log' to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\smso_log.ldf' GO ALTER DATABASE smso SET MULTI_USER
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)