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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL DMO Query

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-12-20 : 07:47:52
Aarti writes "Hi,

Question:

I am using VB as client and SQL Server 2000 database.

To submit the batch of script for execution, i am using ExecuteWithResultsAndMessages2 method of SQL DMO.
One of the parameter to this function is the script which is given for execution. But I noticed when the script which is given as parameter to ExecuteWithResultsAndMessages2 function contains GO statement, it donot returns the results properly.

Is it the limitation of the type of SQL statement submitted to ExecuteWithResultsAndMessages2 for execution? And If so what is alternate solution(other than using .NET since we have constraint to do in VB).

Kindly help me.
Thanks in Advance"

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2006-12-20 : 18:15:33
if you can use SMO instead of DMO, then you can use the ServerConnection class to do this. Check out the Execute* methods.

http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.management.common.serverconnection_members.aspx


www.elsasoft.org
Go to Top of Page
   

- Advertisement -