Click here to Skip to main content
       

Database

 
AnswerRe: Need your opinion on querying data for presentation on winforms / web page and for reports PinprofessionalMycroft Holmes12-May-13 15:05 
GeneralRe: Need your opinion on querying data for presentation on winforms / web page and for reports PinmemberNayan Ambaliya12-May-13 15:10 
QuestionCannot insert the value NULL into column PinmemberMember 991209112-May-13 12:33 
AnswerRe: Cannot insert the value NULL into column PinprofessionalMycroft Holmes12-May-13 15:02 
AnswerRe: Cannot insert the value NULL into column PinmemberBikash Prakash Dash13-May-13 19:27 
GeneralRe: Cannot insert the value NULL into column PinprofessionalMycroft Holmes13-May-13 20:55 
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 
GeneralRe: rule of DataAdapter PinprofessionalPIEBALDconsult9-May-13 4:35 
GeneralRe: rule of DataAdapter Pinmembermessages9-May-13 5:16 
Questiondifference between with and temp table in my two query Pingroupmehdi.sabet7-May-13 9:02 
AnswerRe: difference between with and temp table in my two query PinmvpEddy Vluggen7-May-13 9:40 
AnswerRe: difference between with and temp table in my two query PinprofessionalJörgen Andersson8-May-13 11:52 
AnswerRe: difference between with and temp table in my two query PinmemberFabricio Dos Santos Antunes10-May-13 14:55 
QuestionExport Image from SQL to png Format Pinmembermrfalk7-May-13 8:09 
AnswerRe: Export Image from SQL to png Format PinmvpEddy Vluggen7-May-13 9:52 
QuestionBulk insert not recognizing end of file Pinmembersearching for solution.....5-May-13 23:18 
AnswerRe: Bulk insert not recognizing end of file PinmvpEddy Vluggen6-May-13 7:56 
QuestionHow to get data from Gridview (gridview(checkbox)) using asp.net and c#...... Pingroupnukalarajesh1-May-13 21:19 
AnswerRe: How to get data from Gridview (gridview(checkbox)) using asp.net and c#...... PinmvpRichard MacCutchan1-May-13 21:27 
AnswerRe: How to get data from Gridview (gridview(checkbox)) using asp.net and c#...... PinmemberAANIL DHAKAD8-May-13 3:17 
Questionhow to upload a iamge file on web server in mvc4 asp.net c# Pingroupnukalarajesh1-May-13 21:06 
QuestionSQL Server null date 01/01/1900 possible issue - a question PinmemberGuyThiebaut1-May-13 5:51 
AnswerRe: SQL Server null date 01/01/1900 possible issue - a question PinprofessionalRichard Deeming1-May-13 6:04 
GeneralRe: SQL Server null date 01/01/1900 possible issue - a question PinmemberAner Bautista3-May-13 8:25 
GeneralRe: SQL Server null date 01/01/1900 possible issue - a question Pinmemberjschell3-May-13 11:24 
AnswerRe: SQL Server null date 01/01/1900 possible issue - a question PinmvpEddy Vluggen1-May-13 6:37 

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
Web04 | 2.8.140827.1 | Last Updated 30 Aug 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid