i have a problem with the ExecuteWithResultsAndMessages command executed in a vbs script.
the following statements becomes the resultset in in the tblResult1 object but the expected message, like 'nn rows affected', is missing.
i tried every syntax (also the ExecuteWithResultsAndMessages2 command) but nothing gives me the message.
does anyone have an idea what i make wrong.
searching aroung the internet or microsoft or anything else doesnt help me.
Set objSQLServer1 = CreateObject("SQLDMO.SQLServer")
objSQLServer1.LoginSecure = True
objSQLServer1.LoginTimeout = 3
Set objDB1 = objSQLServer1.Databases("sqldatabase")
tblQuery1 = "SELECT * from sqltable"
Set tblResult1 = objSQLServer1.ExecuteWithResultsAndMessages(tblQuery1, sMessages, Len(tblQuery1))