Click here to Skip to main content
       

Database

 
QuestionComparing 2 values in same column SQL (C#) PinmemberMember 991209111-May-13 5:56 
AnswerRe: Comparing 2 values in same column SQL (C#) PinmvpEddy Vluggen11-May-13 6:08 
GeneralRe: Comparing 2 values in same column SQL (C#) PinmemberMember 991209112-May-13 6:22 
AnswerRe: Comparing 2 values in same column SQL (C#) [modified] PinprofessionalPIEBALDconsult11-May-13 7:22 
AnswerRe: Comparing 2 values in same column SQL (C#) PinprofessionalMycroft Holmes11-May-13 12:50 
QuestionQuestion Related Database transfer Pingroupshubham Dev10-May-13 21:09 
AnswerRe: Question Related Database transfer PinmvpSandeep Mewara10-May-13 23:31 
QuestionNo new tables in database after executed query PinmemberMember 991209110-May-13 12:50 
Hi all. I am using Microsoft SQL Server 2008 Management Studio. I have been trying to create a database (containing tables etc) from a query file (Delivery.sql).
 
In the Object explorer I right-clicked Database folder and created the "Delivery database". I then clicked New Query and pasted the contents of Delivery.sql (from notepad) into the new query.
 
Now when I execute this code, it says it has completed successfully, but in the Object Explorer the "Delivery database" does not contain any tables Sigh | :sigh: . I am confused and am in need of help . Thanks.

Here is the image of the object explorer: http://imageshack.us/a/img694/7558/sqlobjectexplorerp.png[^]
 
Here is the code of the query file (Delivery.sql):
 
USE [Delivery database]
GO
 
/****** Object:  Database [Delivery]    Script Date: 05/09/2013 19:23:43 ******/
CREATE DATABASE [Delivery] ON  PRIMARY 
( NAME = N'Delivery', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\Delivery.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'Delivery_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\Delivery_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
 
ALTER DATABASE [Delivery] SET COMPATIBILITY_LEVEL = 100
GO
 
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Delivery database].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
 
ALTER DATABASE [Delivery] SET ANSI_NULL_DEFAULT OFF 
GO
 
ALTER DATABASE [Delivery] SET ANSI_NULLS OFF 
GO
 
ALTER DATABASE [Delivery] SET ANSI_PADDING OFF 
GO
 
ALTER DATABASE [Delivery] SET ANSI_WARNINGS OFF 
GO
 
ALTER DATABASE [Delivery] SET ARITHABORT OFF 
GO
 
ALTER DATABASE [Delivery] SET AUTO_CLOSE OFF 
GO
 
ALTER DATABASE [Delivery] SET AUTO_CREATE_STATISTICS ON 
GO
 
ALTER DATABASE [Delivery] SET AUTO_SHRINK OFF 
GO
 
ALTER DATABASE [Delivery] SET AUTO_UPDATE_STATISTICS ON 
GO
 
ALTER DATABASE [Delivery] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
 
ALTER DATABASE [Delivery] SET CURSOR_DEFAULT  GLOBAL 
GO
 
ALTER DATABASE [Delivery] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
 
ALTER DATABASE [Delivery] SET NUMERIC_ROUNDABORT OFF 
GO
 
ALTER DATABASE [Delivery] SET QUOTED_IDENTIFIER OFF 
GO
 
ALTER DATABASE [Delivery] SET RECURSIVE_TRIGGERS OFF 
GO
 
ALTER DATABASE [Delivery] SET  DISABLE_BROKER 
GO
 
ALTER DATABASE [Delivery] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
 
ALTER DATABASE [Delivery] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
 
ALTER DATABASE [Delivery] SET TRUSTWORTHY OFF 
GO
 
ALTER DATABASE [Delivery] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
 
ALTER DATABASE [Delivery] SET PARAMETERIZATION SIMPLE 
GO
 
ALTER DATABASE [Delivery] SET READ_COMMITTED_SNAPSHOT OFF 
GO
 
ALTER DATABASE [Delivery] SET HONOR_BROKER_PRIORITY OFF 
GO
 
ALTER DATABASE [Delivery] SET  READ_WRITE 
GO
 
ALTER DATABASE [Delivery] SET RECOVERY SIMPLE 
GO
 
ALTER DATABASE [Delivery] SET  MULTI_USER 
GO
 
ALTER DATABASE [Delivery] SET PAGE_VERIFY CHECKSUM  
GO
 
ALTER DATABASE [Delivery] SET DB_CHAINING OFF 
GO
 

AnswerRe: No new tables in database after executed query PinmemberJammoD8710-May-13 21:36 
GeneralRe: No new tables in database after executed query PinmemberMember 991209111-May-13 3:51 
QuestionER Diagramming Tools - which one to use Pinmemberole.Grossklaus@gmx.de10-May-13 2:37 
AnswerRe: ER Diagramming Tools - which one to use PinprofessionalJörgen Andersson12-May-13 8:01 
NewsNew Built-In functions in 2012 PinmemberKarthik_J, Coimbatore10-May-13 2:24 
GeneralRe: New Built-In functions in 2012 PinmvpRichard MacCutchan10-May-13 4:05 
GeneralRe: New Built-In functions in 2012 Pinmemberjschell10-May-13 8:00 
QuestionCannot Find Rows With % character in Text Fields with Access SQL PinmemberJohnBlocker8-May-13 10:01 
AnswerRe: Cannot Find Rows With % character in Text Fields with Access SQL [modified] PinprofessionalJörgen Andersson9-May-13 9:34 
GeneralRe: Cannot Find Rows With % character in Text Fields with Access SQL PinmemberJohnBlocker9-May-13 22:15 
GeneralRe: Cannot Find Rows With % character in Text Fields with Access SQL PinprofessionalJörgen Andersson10-May-13 4:51 
AnswerRe: Cannot Find Rows With % character in Text Fields with Access SQL PinprofessionalRichard Deeming10-May-13 1:39 
AnswerRe: Cannot Find Rows With % character in Text Fields with Access SQL Pinmemberjschell10-May-13 8:02 
AnswerRe: Cannot Find Rows With % character in Text Fields with Access SQL PinmemberFabricio Dos Santos Antunes10-May-13 15:22 
Questionrule of DataAdapter Pinmembermessages7-May-13 21:10 
AnswerRe: rule of DataAdapter PinprofessionalPIEBALDconsult8-May-13 4:59 
GeneralRe: rule of DataAdapter Pinmembermessages8-May-13 8:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web01 | 2.8.140921.1 | Last Updated 18 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid