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@at-at-(E-Mail Removed)
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


On Thu, 16 Oct 2008 18:10:47 -0600, David Thielen
<(E-Mail Removed)> wrote:

>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@at-at-(E-Mail Removed)
>Windward Reports -- http://www.WindwardReports.com
>me -- http://dave.thielen.com
>
>Cubicle Wars - http://www.windwardreports.com/film.htm


david@at-at-(E-Mail Removed)
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

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