7 lines
418 B
Batchfile
7 lines
418 B
Batchfile
|
rem sqlcmd -E -S (localdb)\DataPROInstance -Q "ALTER DATABASE [%1] SET SINGLE_USER WITH ROLLBACK IMMEDIATE"
|
||
|
|
rem sqlcmd -E -S (localdb)\DataPROInstance -Q "sp_Detach_db %1"
|
||
|
|
%4 -E -S (localdb)\DataPROInstance -Q "CREATE DATABASE [%1] ON ( FILENAME = '%~2'), ( FILENAME = '%~3' ) FOR ATTACH"
|
||
|
|
%4 -E -S (localdb)\DataPROInstance -Q "sp_configure 'clr enabled', 1"
|
||
|
|
%4 -E -S (localdb)\DataPROInstance -Q "RECONFIGURE"
|
||
|
|
|