The Error message pops up when i try to send a test message for any Operator.

my SQL mail is working perfect. all queries / jobs using xp_sendmail are going...

Running a DTS is nothing but an OS command called dtsrun (with paramaters for DTS). You can change the command to be

start /LOW dtsrun.exe

followed by usual parameters for...

do you have a fixed search condition ? or even a fixed field name to be searching for ?

can you give the contents of row that you are looking for...

Can this error logs be cycled like SQL Server Logs ? like sp_cycle_errorlog for SQL Error Logs.

Hi,

The one of the basic advantages of a stored procedure is to have the execution plan pre-compiled, stored and available for execution on server. so that same set of commands...

Hi All,

thanks for all replies. as i have previously worked on Sybase and Oracle RDBMS, this question came to my mind. Personally, i prefer the error to be thrown at...

i went into exact details of code, and found that error is not caused by .Parameters.Refresh command.

In my next code statement, i am refering to first parameter and assigning the...

i have checked. the error is on line .Parameters.Refresh

MDAC 2.6 is the version of ADO in VB Project reference.

also the procedure gets executed from SQL Query Analyzer perfectly by...