Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
T-SQL Trigger/SQL Server 7.0
Message
From
01/08/2002 16:48:59
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00672424
Message ID:
00685218
Views:
18
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform