Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

executing SQL scripts from outside enterprise manager

Status
Not open for further replies.

YL5956

MIS
Jul 11, 2001
73
US
I'm interested in running triggers to perform SQL scripts or stored procedures. How would I set this up? For example I want to add a column to a table in a user database but I want another vendor application to execute this command. Has anyone used a set up like this? Thanks.
 
1. You may use SQLDMO to acomplish that. SQLDMO is a library who expose all Sql Server internal objects.

2. You may use Ado or AdoX
3. you may call osql from external program.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top