diff options
| -rw-r--r-- | projecttemplates/RelyingPartyLogic/CreateDatabase.sql | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/projecttemplates/RelyingPartyLogic/CreateDatabase.sql b/projecttemplates/RelyingPartyLogic/CreateDatabase.sql index adc1e91..c229473 100644 --- a/projecttemplates/RelyingPartyLogic/CreateDatabase.sql +++ b/projecttemplates/RelyingPartyLogic/CreateDatabase.sql @@ -10,8 +10,8 @@ GO /* :setvar Path1 "WEBROOT\App_Data\" :setvar DatabaseName "RelyingPartyDatabase" -:setvar DefaultDataPath "c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\" -:setvar DefaultLogPath "c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\" +:setvar DefaultDataPath "" +:setvar DefaultLogPath "" */ GO @@ -709,3 +709,9 @@ ALTER TABLE [dbo].[UserRole] WITH CHECK CHECK CONSTRAINT [FK_UserRole_User]; GO +ALTER DATABASE [$(DatabaseName)] + SET MULTI_USER + WITH ROLLBACK IMMEDIATE; + + +GO |