كسف انشيء قاعدة بيانات sql

هذا كود لانشاء sql database عن طريق ال Sql Server Management Studio

مع ملاحظة أن اسم الداتابيز فى الكود هو DataBase

SET NOCOUNT ON
GO

USE master
GO
if exists (select * from sysdatabases where name='DataBase')
		drop database DataBase
go

DECLARE @device_directory NVARCHAR(520)
SELECT @device_directory = SUBSTRING(filename, 1, CHARINDEX(N'master.mdf', LOWER(filename)) - 1)
FROM master.dbo.sysaltfiles WHERE dbid = 1 AND fileid = 1

EXECUTE (N'CREATE DATABASE DataBase
  ON PRIMARY (NAME = N''DataBase'', FILENAME = N''' + @device_directory + N'DataBase.mdf'')
  LOG ON (NAME = N''DataBase_log'',  FILENAME = N''' + @device_directory + N'DataBase.ldf'')')
go

exec sp_dboption 'DataBase','trunc. log on chkpt.','true'
exec sp_dboption 'DataBase','select into/bulkcopy','true'
GO

set quoted_identifier on
GO

/* Set DATEFORMAT so that the date strings are interpreted correctly regardless of
   the default DATEFORMAT on the server.
*/
SET DATEFORMAT mdy
GO
use [DataBase]
GO