>>>>USE [master] >>>>GO >>>>/****** Object: Database [DLI_Testing] Script Date: 02/26/2013 06:41:26 ******/ >>>>CREATE DATABASE [DLI_Testing] ON PRIMARY >>>>( NAME = N'DLI_Testing', FILENAME = N'D:\DLI_Testing.mdf' , SIZE = 78080KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) >>>> LOG ON >>>>( NAME = N'DLI_Testing_log', FILENAME = N'D:\DLI_Testing_log.LDF' , SIZE = 470144KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) >>>>GO >>>>ALTER DATABASE [DLI_Testing] SET COMPATIBILITY_LEVEL = 100 >>>>GO >>>>IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) >>>>begin >>>>EXEC [DLI_Testing].[dbo].[sp_fulltext_database] @action = 'enable' >>>>end >>>>GO >>>>>>>
>>Msg 5170, Level 16, State 1, Line 2 >>Cannot create file 'D:\DLI_Testing.mdf' because it already exists. Change the file path or the file name, and retry the operation. >>Msg 1802, Level 16, State 4, Line 2 >>CREATE DATABASE failed. Some file names listed could not be created. Check related errors. >>Msg 5011, Level 14, State 5, Line 1 >>User does not have permission to alter database 'DLI_Testing', the database does not exist, or the database is not in a state that allows access checks. >>Msg 5069, Level 16, State 1, Line 1 >>ALTER DATABASE statement failed. >>>
>SELECT Name, FileName FROM sysdatabases WHERE FileName LIKE '%DLI_Testing%' >>