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 - 2001-05-22 : 09:15:02
|
Josh writes "I am currently writing a program to generate executable database updates. The update generator is being written in VB with ADO, so far. The database updates are stored on our system as .sql files. The generator will read in the .sql files and create a exe file for our clients to run on their system. The generator is currently splitting up the commands and passing them one at a time.
Everything was working fine until the database updates started to include Drop and Create Procedure commands. What is the best way to run Create Procedures on a database through ADO or some type of database connection COM object?
ADO is also having problems with comments in the .sql files. Should I write a Parser to remove these comments first?
Visual Basic 6.0 with ADO 2.6
Windows 2000 Professional and Server Service Pack 1
SQL Server 7.0 Service Pack 3 (upgrading soon to 2000)" |
|
|
|
|
|
Creating Stored Procedures through ADO