Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    100

    Unanswered: 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, Ed

  2. #2
    Join Date
    Feb 2003
    Location
    Milano, Italy
    Posts
    80
    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.
    Davide Mauri
    http://www.davidemauri.it

  3. #3
    Join Date
    Jul 2003
    Posts
    100
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •