Click here to Skip to main content
12,406,342 members (30,561 online)
   

Database

 
QuestionComparing 2 values in same column SQL (C#) Pin
Member 991209111-May-13 5:56
memberMember 991209111-May-13 5:56 
AnswerRe: Comparing 2 values in same column SQL (C#) Pin
Eddy Vluggen11-May-13 6:08
mvpEddy Vluggen11-May-13 6:08 
GeneralRe: Comparing 2 values in same column SQL (C#) Pin
Member 991209112-May-13 6:22
memberMember 991209112-May-13 6:22 
AnswerRe: Comparing 2 values in same column SQL (C#) Pin
PIEBALDconsult11-May-13 7:22
professionalPIEBALDconsult11-May-13 7:22 
AnswerRe: Comparing 2 values in same column SQL (C#) Pin
Mycroft Holmes11-May-13 12:50
professionalMycroft Holmes11-May-13 12:50 
QuestionQuestion Related Database transfer Pin
shubham Dev10-May-13 21:09
groupshubham Dev10-May-13 21:09 
AnswerRe: Question Related Database transfer Pin
Sandeep Mewara10-May-13 23:31
mvpSandeep Mewara10-May-13 23:31 
QuestionNo new tables in database after executed query Pin
Member 991209110-May-13 12:50
memberMember 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 Pin
JammoD8710-May-13 21:36
memberJammoD8710-May-13 21:36 
GeneralRe: No new tables in database after executed query Pin
Member 991209111-May-13 3:51
memberMember 991209111-May-13 3:51 
QuestionER Diagramming Tools - which one to use Pin
ole.Grossklaus@gmx.de10-May-13 2:37
memberole.Grossklaus@gmx.de10-May-13 2:37 
AnswerRe: ER Diagramming Tools - which one to use Pin
Jörgen Andersson12-May-13 8:01
professionalJörgen Andersson12-May-13 8:01 
NewsNew Built-In functions in 2012 Pin
Karthik_J, Coimbatore10-May-13 2:24
memberKarthik_J, Coimbatore10-May-13 2:24 
GeneralRe: New Built-In functions in 2012 Pin
Richard MacCutchan10-May-13 4:05
mvpRichard MacCutchan10-May-13 4:05 
GeneralRe: New Built-In functions in 2012 Pin
jschell10-May-13 8:00
memberjschell10-May-13 8:00 
QuestionCannot Find Rows With % character in Text Fields with Access SQL Pin
JohnBlocker8-May-13 10:01
memberJohnBlocker8-May-13 10:01 
AnswerRe: Cannot Find Rows With % character in Text Fields with Access SQL Pin
Jörgen Andersson9-May-13 9:34
professionalJörgen Andersson9-May-13 9:34 
GeneralRe: Cannot Find Rows With % character in Text Fields with Access SQL Pin
JohnBlocker9-May-13 22:15
memberJohnBlocker9-May-13 22:15 
GeneralRe: Cannot Find Rows With % character in Text Fields with Access SQL Pin
Jörgen Andersson10-May-13 4:51
professionalJörgen Andersson10-May-13 4:51 
AnswerRe: Cannot Find Rows With % character in Text Fields with Access SQL Pin
Richard Deeming10-May-13 1:39
professionalRichard Deeming10-May-13 1:39 
AnswerRe: Cannot Find Rows With % character in Text Fields with Access SQL Pin
jschell10-May-13 8:02
memberjschell10-May-13 8:02 
AnswerRe: Cannot Find Rows With % character in Text Fields with Access SQL Pin
Fabricio Dos Santos Antunes10-May-13 15:22
memberFabricio Dos Santos Antunes10-May-13 15:22 
Questionrule of DataAdapter Pin
messages7-May-13 21:10
membermessages7-May-13 21:10 
AnswerRe: rule of DataAdapter Pin
PIEBALDconsult8-May-13 4:59
professionalPIEBALDconsult8-May-13 4:59 
GeneralRe: rule of DataAdapter Pin
messages8-May-13 8:47
membermessages8-May-13 8:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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
Web02 | 2.8.160730.1 | Last Updated 28 Jul 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid