ASP pages & Database creation.

• gazzer

  SSC Eights!

  Points: 885

  More actions

  October 18, 2004 at 4:51 am

  #162399

  Hi all,

  just a quick question, is it possible to create a database from input on an asp page.

  I.E I have a web page with a single text field on it, this would contain the name of the database to be created, on submit I want to be able to create a new database from this input, by running an SP or something similar.

  Is it possible, and if so could you point me in the correct direction please.

  I have already tried running a stored procedure, but I need to be able to change the code to incorporate the new database name in all the correct places.

  Cheers

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  October 18, 2004 at 5:18 am

  #527011

  You could do this by calling a sp that dynamically builds CREATE DATABASE @DBName and then is EXEC via sp_executesql.

   

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net