Solved

Executing SP through DMO

Posted on 1998-12-31
1
296 Views
Last Modified: 2012-05-04
How would I execute a stored procedure using VB-DMO?
What syntax would I use?

Regards
0
Comment
Question by:ossentoo
1 Comment
 

Accepted Solution

by:
alvaroB earned 50 total points
ID: 1092437
SQL-DMO is aimed at providing the user with objects to manage SQL Server from a VB application. In other words, you could do administrative tasks(backups, configurations,...) or look at the internal structure of a database(Tables,views,...) , using DMO. If you want to process data through a SP, the way to go could be ADO, RDO, or other technologies.

If you still want to execute a SP using SQL-DMO, you could try using the following methods of the SQLServer object:

ExecuteImmediate
ExecuteWithResults
(Check SQL documentation for details)

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question