Creating a database using IDbCommand

  • Thread starter Thread starter David Thielen
  • Start date Start date
D

David Thielen

Hi;

If I want to run a script that creates a databse using
IDbCommand.ExecuteNonQuery - 2 questions:

1) What database do I connect to? I assume master.

2) How do I start the script? I think it's:

CREATE DATABASE [xxxAutoTag]
GO

USE [xxxAutoTag]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Schedule](
....

thanks - dave

david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm
 
The answer is yes & yes.

thanks - dave


Hi;

If I want to run a script that creates a databse using
IDbCommand.ExecuteNonQuery - 2 questions:

1) What database do I connect to? I assume master.

2) How do I start the script? I think it's:

CREATE DATABASE [xxxAutoTag]
GO

USE [xxxAutoTag]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Schedule](
...

thanks - dave

david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm
Click to expand...


david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm
 
Back
Top