Evil Kraig F (1/12/2012)
Successful completion of a failure, but that's primarily because the proc doesn't actually fail, which is just... wierd. Try/Catch is also useless, as it's not an actual failure. Blasted strange. The workaround will not function. Hmmmmm.
That's kind of what I expected to happen, so I'm not surprised.
By chance, are you also connecting from a 2k8 machine running the agent and the local DB with the connection attached to a 2k5 machine like I am? I've reviewed some errors for this and it appears others have gotten an actual error to occur from this.
2k8 to 2k8. One is an app server, the other is my db server. SP1.