Help has anyone come across a way to automatic db creation.

Hi I've been given a project that requires me to produce a users friendly web base administarion menu that creates a new customer for one of our systems.

The problem is this Project it needs to create a database for each user, in SQL server 2000. This has me stumpted, has anybody ever done this before and could they point me in the correct direction! The majority of our administration menu are written in ASP but any help automating this procedure would be useful.

Thanks a lot, EdYou can create a database simply using the T-SQL command

CREATE DATABASE

that can be invoked as any other command from your client.

You can also use it in a Stored Procedure.|||Originally posted by manowar
You can create a database simply using the T-SQL command

CREATE DATABASE

that can be invoked as any other command from your client.

You can also use it in a Stored Procedure.

Excellent, thanks

Help desk systems..

I was wondering if anyone could suggest a web-based help desk system
that uses MS SQL server that also has a knowledge base and also allows
support employees to log how much time they have spent on each
particular ticket. I'm after an 'affordable' system that would be used
by about 35 people.

Otherwise, if you can think of a better place to ask around, let me
know!

Regards,
BelindaBelinda,

I'm not sure what you consider affordable. Are the 35 users concurrent
users or named users? I'd be happy to give you a quote.

Regards,
John

"Belinda R. Kelly" <bkelly@.ebetonline.com> wrote in message
news:a4d4a8d5.0311262231.50c86e1@.posting.google.co m...
> I was wondering if anyone could suggest a web-based help desk system
> that uses MS SQL server that also has a knowledge base and also allows
> support employees to log how much time they have spent on each
> particular ticket. I'm after an 'affordable' system that would be used
> by about 35 people.
> Otherwise, if you can think of a better place to ask around, let me
> know!
> Regards,
> Belinda