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 - 2004-04-20 : 09:53:37
|
| Sasikumar writes "Hi we are developing custom application software using visual basic 6 as front end, and sqlserver 2000(msde)as back end.We allow our customer to create muliple company(data base) themselfs.So whenever they create company,we need to create database,tables,stored proc... from our vb project.Sometimes we need to change existing database structure (means : Add new 'table' or add new 'field' or rename existing 'field' or 'table' or change datatype ...and so on.)if Customer install my package and create new company,All it should be create automaticalyHow can i make this from vb6..?" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-20 : 12:32:58
|
| Script out your objects using the Generate SQL Script wizard in Enterprise Manager. From your application, run the .sql file that was generated from the wizard. Keep track of your schema updates in a .sql file too.Tara |
 |
|
|
|
|
|
create database,table,stored proc,trigger