daily pastebin goal
10%
SHARE
TWEET

Untitled

a guest Mar 20th, 2019 70 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. USE [master]
  2. GO
  3.  
  4. /****** Object:  Database [Videojuegos]    Script Date: 20/03/2019 20:18:01 ******/
  5. CREATE DATABASE [Videojuegos]
  6.  CONTAINMENT = NONE
  7.  ON  PRIMARY
  8. ( NAME = N'Videojuegos', FILENAME = N'E:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\Videojuegos.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
  9.  LOG ON
  10. ( NAME = N'Videojuegos_log', FILENAME = N'E:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\Videojuegos_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
  11. GO
  12.  
  13. ALTER DATABASE [Videojuegos] SET COMPATIBILITY_LEVEL = 140
  14. GO
  15.  
  16. IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
  17. begin
  18. EXEC [Videojuegos].[dbo].[sp_fulltext_database] @action = 'enable'
  19. end
  20. GO
  21.  
  22. ALTER DATABASE [Videojuegos] SET ANSI_NULL_DEFAULT OFF
  23. GO
  24.  
  25. ALTER DATABASE [Videojuegos] SET ANSI_NULLS OFF
  26. GO
  27.  
  28. ALTER DATABASE [Videojuegos] SET ANSI_PADDING OFF
  29. GO
  30.  
  31. ALTER DATABASE [Videojuegos] SET ANSI_WARNINGS OFF
  32. GO
  33.  
  34. ALTER DATABASE [Videojuegos] SET ARITHABORT OFF
  35. GO
  36.  
  37. ALTER DATABASE [Videojuegos] SET AUTO_CLOSE OFF
  38. GO
  39.  
  40. ALTER DATABASE [Videojuegos] SET AUTO_SHRINK OFF
  41. GO
  42.  
  43. ALTER DATABASE [Videojuegos] SET AUTO_UPDATE_STATISTICS ON
  44. GO
  45.  
  46. ALTER DATABASE [Videojuegos] SET CURSOR_CLOSE_ON_COMMIT OFF
  47. GO
  48.  
  49. ALTER DATABASE [Videojuegos] SET CURSOR_DEFAULT  GLOBAL
  50. GO
  51.  
  52. ALTER DATABASE [Videojuegos] SET CONCAT_NULL_YIELDS_NULL OFF
  53. GO
  54.  
  55. ALTER DATABASE [Videojuegos] SET NUMERIC_ROUNDABORT OFF
  56. GO
  57.  
  58. ALTER DATABASE [Videojuegos] SET QUOTED_IDENTIFIER OFF
  59. GO
  60.  
  61. ALTER DATABASE [Videojuegos] SET RECURSIVE_TRIGGERS OFF
  62. GO
  63.  
  64. ALTER DATABASE [Videojuegos] SET  DISABLE_BROKER
  65. GO
  66.  
  67. ALTER DATABASE [Videojuegos] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
  68. GO
  69.  
  70. ALTER DATABASE [Videojuegos] SET DATE_CORRELATION_OPTIMIZATION OFF
  71. GO
  72.  
  73. ALTER DATABASE [Videojuegos] SET TRUSTWORTHY OFF
  74. GO
  75.  
  76. ALTER DATABASE [Videojuegos] SET ALLOW_SNAPSHOT_ISOLATION OFF
  77. GO
  78.  
  79. ALTER DATABASE [Videojuegos] SET PARAMETERIZATION SIMPLE
  80. GO
  81.  
  82. ALTER DATABASE [Videojuegos] SET READ_COMMITTED_SNAPSHOT OFF
  83. GO
  84.  
  85. ALTER DATABASE [Videojuegos] SET HONOR_BROKER_PRIORITY OFF
  86. GO
  87.  
  88. ALTER DATABASE [Videojuegos] SET RECOVERY SIMPLE
  89. GO
  90.  
  91. ALTER DATABASE [Videojuegos] SET  MULTI_USER
  92. GO
  93.  
  94. ALTER DATABASE [Videojuegos] SET PAGE_VERIFY CHECKSUM  
  95. GO
  96.  
  97. ALTER DATABASE [Videojuegos] SET DB_CHAINING OFF
  98. GO
  99.  
  100. ALTER DATABASE [Videojuegos] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
  101. GO
  102.  
  103. ALTER DATABASE [Videojuegos] SET TARGET_RECOVERY_TIME = 60 SECONDS
  104. GO
  105.  
  106. ALTER DATABASE [Videojuegos] SET DELAYED_DURABILITY = DISABLED
  107. GO
  108.  
  109. ALTER DATABASE [Videojuegos] SET QUERY_STORE = OFF
  110. GO
  111.  
  112. ALTER DATABASE [Videojuegos] SET  READ_WRITE
  113. GO
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top