Here is what I hear from the OP:

I have a stored procedure written where after each DML statement the value of @@ERROR is evaluated to determine the success or failure...

Missed...

doobya (7/14/2010)

---

in the following code which statements are in a TRY block?

create dbo.spBlah

as

raiserror('is this?', 16, 1)

begin try

raiserror('we all agree this one is', 16, 1)

end try

begin catch

...

Eugene Elutin (7/14/2010)

---

SELECT upvolume,downvolume,TotalTrades

INTO #TodayRecords

FROM DBVaskVbid WITH (NOLOCK) -- are you fully awre of what this hint does?

WHERE BarStamp >= '7/14/2010'

-- do you have huge vlume of...

doobya (7/14/2010)

---

ambiguity = "in a TRY block"

what does...

Geoff A (7/13/2010)

---

i am not sure how you got 2 separate pairs of servers to use the same witness on the same port... that is something i could never do...

I don't agree.

I got the question wrong because I missed the ; in the subquery. I...

Geoff A (7/13/2010)

---

so you are running multiple instances of mirroring using a single witness on different ports....

i never ever had any luck with that setup. I always have separate instances...

Looks like Network Services found the problem. Lesson learned on thier side, don't put servers on DHCP.

(Uh, that's a duh in my book and I'm not a network person....

We have a future production server on FIN1/FIN2. It has the same problem as the production server. On this database, we dropped the witness and re-established it on...

Not currently an option. That would have to wait until our scheduled maintenance period on Thursday night. As long as the mirror is...

Having an interesting issue with our mirroring environment if anyone would like to provide some advice here.

Hard to really help you based solely on the code provided. We could provide much better assistance if you could post the DDL (CREATE TABLE) statements for the tables...

I'm taking it this isn't something you can...

you need a semi-colon like this:

SET NOCOUNT ON;