Is there a way to completely suppress TSQL 'print' messages in ADO when running a SQL batch (not stored procedure)?
Settting CursorLocation=adUseClient does not seem to do the trick.
sqlCmd.ActiveConnection = objConn
sqlCmd.CommandText = sqlStr ' sqlStr is a batch read in from a
file
sqlCmd.CommandType = adCmdText
sqlCmd.CursorLocation = adUseClient
sqlCmd.Execute
Re: SQL Server stored prcedures with output parameters ... the stored procedure below appears to consistently ... > moment) how ADO handles that. ... Parameter 1 had direction input...Appending parameter value http://www.holdenweb.com/ ... (comp.lang.python)
Re: Stored Procedure is running slow! ... > I run stored procedure from QA, it takes some 15 seconds to execute. ... > seconds when called from MS Fox Pro, via ADO.... Try this in Query Analyzer:... By default Query Analyzer runs with ARITHABORT ON, ... (microsoft.public.sqlserver.programming)
Re: Very bad response time from stored procedure call via ADO ... We have a stored procedure that returns some statistical information ...SQL Server is version 2000 ... When run in SQL Query Analyser the typical duration is 400ms. ... When run from the VB6 application via ADO the duration increases to ... (microsoft.public.data.ado)
Re: Stored procedure functionality and visibility questions ... I have the impression that most of the time it's best to use DAO or ADO... >>>but I also keep reading about additional stored procedure support that was ... I've looked into using a VBA function or procedure to perform the task ... >> application automate Access.... (microsoft.public.access.modulesdaovba)
Re: How can a recordset returned by a sproc be updated? ... With the resultset metadata is returned to the client that allows ADO and ...SQL Server MVP... > ADO.... I tried making a view and having the stored procedure select ... (microsoft.public.sqlserver.programming)
