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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 building a database by executing a separate .sql file through ASP

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-22 : 10:56:26
MiracleMan writes "Hi there,

In the Enterprise Manager, I right-click "all tasks", select "Generate SQL script" and in this window, I click "Show all".

After this, a .sql file is being generated and I'm very happy with that. But, I do this because I want to rebuild my sql server database remotely on the account of my webhost. Manually I tested one table and it worked, but it took ages to code the sql myself. How can I execute this separate .sql file and build my database this way?


Thanks in advance,

Lennert Luik (The Netherlands, Europe)"
   

- Advertisement -