Seems that this http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=19410&FORUM_ID=23&CAT_ID=2&Topic_Title=Gurus%2C+please+help&Forum_Title=General

is the same question, right?

If so, we should continue there.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

quote:

---

Well, $125 isn't that much.

Just thinking, we have some budget open for education. Now I only need to build the bridge...

Nice to see you're back, Len!

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Some people might argue that using the identity property is bad, but I like it.

I think it makes somehow easier.

Btw,

CREATE TABLE [dbo].[TEST] (

[ID1] [int] IDENTITY...

Both utilities are explained in Books Online.

I would first take a look at the CREATE TABLE statements in ths *.sql file.

There are some (minor) differences between MySQL and SQL...

Just for fun I ran

set nocount on

CREATE TABLE [dbo].[RobTable] (

[RecordID] [int] IDENTITY (1, 1) NOT NULL ,

[RobNote] [varchar] (12) NULL,

[DateTimeInserted] datetime DEFAULT getdate()

) ON [PRIMARY]

go



insert RobTable...

quote:

---

The USE instruction has to be in the same statement as the CREATE TABLE.

 

set @stmt =...

Sorry!!!

Brain dead at 10:30 PM. Need to go home to get some...

Actually it compiles, but it doesn't change to the new database. Please don't use it right now!

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Does this help?

CREATE PROCEDURE usp_blahbla @dbname nvarchar(10)



as



declare @stmt nvarchar(1000)

set @stmt = 'CREATE DATABASE ' + @dbname

EXEC sp_executesql @stmt



set @stmt = 'USE '+ @dbname

EXEC sp_executesql @stmt

set @stmt...

You should be able to place the whole stuff into a sproc with the dbname as input parameter.

Forgot that to mention in the previous post.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Ah, those powerusers with their whole bunch of specialities...

Well then, I don't know if you can reference a db with osql that doesn't already exist.

I...

Well, $125 isn't that much.

Just thinking, we have some budget open for education. Now I only need to build the bridge how this might improve my knowledge in my...

Are you creating every month the same db with another name?

If so, any reason for this?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

You should go mainstream, and use IE. FWIW.

It's the same with Opera. I guess you can't change this.

Frank

http://www.insidesql.de

http://www.familienzirkus.de