Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-14 : 11:48:33
|
Paul writes "How would you execute a series of T-SQL statements -- currently stored in about 3 flat files: a.sql, b.sql and c.sql -- using ASP as a web interface ?
The purpose is to create a database (pass in database name and sizes for 4 filegroups for the database), then set database options and users, then set up the tables, views and stored procedures. Each step is stored in a separate file (not necessary, but helpful to re-create scripts when the database structure script changes)
I initially coded this as a VB app and then included it on the web site as an Active-X document, but this does not meet the needs for common theme across the website.
Need to be able to:
1) Input database name and sizes (simple ASP page)
2) Take in the parameters and substitute them into a Database Create statement (build and execute inside an ASP page)
3) Execute the SQL script files to build the structure of the empty database (this is the area I have not been able to determine how to do it)
SQL Server 7.0 (SP2) and Windows NT(SP6)/2000(SP1)
Good Luck and Thanks In Advance,
Paul" |
|
|
|
|
|
How to execute a file of T-SQL from within ASP