Ignore "missing" database while executing SQL

Question

I'm writing an application that creates a SQL Server database for another program. For this I load a large SQL-script containing the CREATE DATABASE, CREATE TABLE and so on.

The first lines of the script is:

/*CREATE DATABASE*/
USE [master]
GO
CREATE DATABASE [MultiRisk5] COLLATE Latin1_General_CI_AS
GO
USE [MultiRisk5]
GO

And the C# code:

var sqlConn = new SqlConnection("myConnection");
var cmd = new SqlCommand("mySqlScript", sqlConn);
sqlConn.Open();
cmd.ExecuteNonQuery();
sqlConn.Close();

When I run the program I get an exception on the USE statement that tells me that the database MultiRisk5 doesn't exist.

How can this be, when I just created the database? The script runs fine when executed in SQL Server Management Studio.

GO is not a SQL Server command. It is a batch separator for Management Studio. — Joe Stefanelli
– Joe Stefanelli, Commented Aug 2, 2011 at 14:10

Community · Accepted Answer · 2017-05-23 12:26:52Z

1

You can't load a script in c# that has GO in it and run it.

GO is recognised the SQL Server client tools only, and as a batch separator. The database engine won't recognise it. See these questions for more on how to do this

Also, does the SqlConnection try to connect to MultiRisk5? if so, this will error too before USE master is run

edited May 23, 2017 at 12:26

CommunityBot

11 silver badge

answered Aug 2, 2011 at 14:13

gbn

434k84 gold badges602 silver badges690 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

gbn Over a year ago

Wow. 2 downvotes now. One removed upvote. Some interesting voting patterns here

Andrew Over a year ago

I'd added a +1, but -2 seems more like someone acting for motives other than valid scoring.

Damien_The_Unbeliever Over a year ago

This is indubitably one of the errors they're encountering, so I've +1ed.

Kristofer Hoch · Accepted Answer · 2011-08-02 14:10:12Z

0

You may want to try executing your query in a try catch block to see what comes back. That would be a good first step into figuring out the issue.

answered Aug 2, 2011 at 14:10

Kristofer Hoch

2461 silver badge7 bronze badges

Comments

PeeWee2201 · Accepted Answer · 2011-08-02 14:10:19Z

0

Maybe your app does not have the appropriate rights to create the database ? You should check whether the database creation succeeds before going on.

answered Aug 2, 2011 at 14:10

PeeWee2201

1,5442 gold badges17 silver badges25 bronze badges

Collectives™ on Stack Overflow

Ignore "missing" database while executing SQL

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related