>sqlh = SQLSTRINGCONNECT([Driver={SQL Server};Server=Boris;Trusted_Connection=yes;]) > >*** Detach Database >TEXT TO lcSql2 NOSHOW > USE [master] > EXEC master.dbo.sp_detach_db @dbname = N'Test', @keepfulltextindexfile=N'true' >ENDTEXT > >? SQLEXEC(sqlh, lcSql2) > >*** Wait here just to check with Enterprise manager that the DB is detached >WAIT WINDOW "Stop" > > >*** Attach DB again >TEXT TO lcSql NOSHOW > USE [master] > CREATE DATABASE [Test] ON > ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Test.mdf' ), > ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Test_log.ldf' ) > FOR ATTACH > if not exists (select name from master.sys.databases sd where name = N'Test' and > SUSER_SNAME(sd.owner_sid) = SUSER_SNAME() ) EXEC [Test].dbo.sp_changedbowner @loginame=N'BORIS\Boris1', @map=false >ENDTEXT >? SQLEXEC(sqlh, lcSql) >