Advertisement
Guest User

Untitled

a guest
Jul 30th, 2016
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.39 KB | None | 0 0
  1. USE [master]
  2. GO
  3.  
  4. /****** Object: Database [Arena] Script Date: 7/30/16 11:52:37 AM ******/
  5. CREATE DATABASE [Arena]
  6. CONTAINMENT = NONE
  7. ON PRIMARY
  8. ( NAME = N'Arena', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\Arena.mdf' , SIZE = 7168KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
  9. LOG ON
  10. ( NAME = N'Arena_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\Arena_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
  11. GO
  12.  
  13. ALTER DATABASE [Arena] SET COMPATIBILITY_LEVEL = 120
  14. GO
  15.  
  16. IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
  17. begin
  18. EXEC [Arena].[dbo].[sp_fulltext_database] @action = 'enable'
  19. end
  20. GO
  21.  
  22. ALTER DATABASE [Arena] SET ANSI_NULL_DEFAULT OFF
  23. GO
  24.  
  25. ALTER DATABASE [Arena] SET ANSI_NULLS OFF
  26. GO
  27.  
  28. ALTER DATABASE [Arena] SET ANSI_PADDING OFF
  29. GO
  30.  
  31. ALTER DATABASE [Arena] SET ANSI_WARNINGS OFF
  32. GO
  33.  
  34. ALTER DATABASE [Arena] SET ARITHABORT OFF
  35. GO
  36.  
  37. ALTER DATABASE [Arena] SET AUTO_CLOSE OFF
  38. GO
  39.  
  40. ALTER DATABASE [Arena] SET AUTO_SHRINK OFF
  41. GO
  42.  
  43. ALTER DATABASE [Arena] SET AUTO_UPDATE_STATISTICS ON
  44. GO
  45.  
  46. ALTER DATABASE [Arena] SET CURSOR_CLOSE_ON_COMMIT OFF
  47. GO
  48.  
  49. ALTER DATABASE [Arena] SET CURSOR_DEFAULT GLOBAL
  50. GO
  51.  
  52. ALTER DATABASE [Arena] SET CONCAT_NULL_YIELDS_NULL OFF
  53. GO
  54.  
  55. ALTER DATABASE [Arena] SET NUMERIC_ROUNDABORT OFF
  56. GO
  57.  
  58. ALTER DATABASE [Arena] SET QUOTED_IDENTIFIER OFF
  59. GO
  60.  
  61. ALTER DATABASE [Arena] SET RECURSIVE_TRIGGERS OFF
  62. GO
  63.  
  64. ALTER DATABASE [Arena] SET DISABLE_BROKER
  65. GO
  66.  
  67. ALTER DATABASE [Arena] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
  68. GO
  69.  
  70. ALTER DATABASE [Arena] SET DATE_CORRELATION_OPTIMIZATION OFF
  71. GO
  72.  
  73. ALTER DATABASE [Arena] SET TRUSTWORTHY OFF
  74. GO
  75.  
  76. ALTER DATABASE [Arena] SET ALLOW_SNAPSHOT_ISOLATION OFF
  77. GO
  78.  
  79. ALTER DATABASE [Arena] SET PARAMETERIZATION SIMPLE
  80. GO
  81.  
  82. ALTER DATABASE [Arena] SET READ_COMMITTED_SNAPSHOT OFF
  83. GO
  84.  
  85. ALTER DATABASE [Arena] SET HONOR_BROKER_PRIORITY OFF
  86. GO
  87.  
  88. ALTER DATABASE [Arena] SET RECOVERY FULL
  89. GO
  90.  
  91. ALTER DATABASE [Arena] SET MULTI_USER
  92. GO
  93.  
  94. ALTER DATABASE [Arena] SET PAGE_VERIFY CHECKSUM
  95. GO
  96.  
  97. ALTER DATABASE [Arena] SET DB_CHAINING OFF
  98. GO
  99.  
  100. ALTER DATABASE [Arena] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
  101. GO
  102.  
  103. ALTER DATABASE [Arena] SET TARGET_RECOVERY_TIME = 0 SECONDS
  104. GO
  105.  
  106. ALTER DATABASE [Arena] SET DELAYED_DURABILITY = DISABLED
  107. GO
  108.  
  109. ALTER DATABASE [Arena] SET READ_WRITE
  110. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement