The problem may be with the select count(...) statement - you may actually be getting two recordsets back when the query is run outside Query Analyzer. Try the following:

ALTER Procedure...

Guarddata is correct. Your code will look like this:

set cmd = server.CreateObject("ADODB.Command")

with cmd

.ActiveConnection = gObjConn

.CommandType = adCmdStoredProc

.CommandText =...

I used it in a phone sales script maintenance application. Each call has to have a disposition assigned to it, and we always try to recycle existing dispositions. So if...

Also check if any non-logged operations (select into, truncate table, etc.) occurred. This always broke log shipping at my office and sometimes the only way to get it going again...

Headers are essential. They not only indicate who made a change (provided the author still works with you) but also tie a change to a work order here, allowing you...