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, Aug 02 '11 at 14:10

score 1 · Accepted Answer · edited May 23 '17 at 12:26

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 '17 at 12:26

Community

1
1

answered Aug 02 '11 at 14:13

gbn

422,506
82
585
676

Wow. 2 downvotes now. One removed upvote. Some interesting voting patterns here – gbn Aug 02 '11 at 14:19
I'd added a +1, but -2 seems more like someone acting for motives other than valid scoring. – Andrew Aug 02 '11 at 14:21
This is indubitably one of the errors they're encountering, so I've +1ed. – Damien_The_Unbeliever Aug 02 '11 at 14:44

score 0 · Answer 2 · answered Aug 02 '11 at 14:10

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 02 '11 at 14:10

Kristofer Hoch

246
1
7

score 0 · Answer 3 · answered Aug 02 '11 at 14:10

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 02 '11 at 14:10

PeeWee2201

1,464
2
15
23

Ignore "missing" database while executing SQL

3 Answers3