Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
T-SQL Trigger/SQL Server 7.0
Message
De
01/08/2002 16:48:59
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00672424
Message ID:
00685218
Vues:
17
Cool, George ... sounds like you've built a handy little tool. SQLDMO can sure come in pretty handy, eh?

~~Bonnie



>Bonnie,
>>
>>>>>Right now, it looks like I'm going use VFP to generate the scripts I'll need and then insert them via SQL-DMO.<
>
>Just to close up this thread, I first created three tables (for the servers, databases and tables) and set up a relationship between the three. The tables were populated using an SQL-DMO series of calls. This allows me to display the databases and the related tables in to grids. I can then select what tables in what databases I want the triggers generated and inserted. I've got a bit of work left to do on the form, but when its done, I can insert the triggers in a large number of tables very, very quickly. I'm sure that it will come in use in the future.
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform