Here's how I would probably do it:

CREATE PROC pr_OrganicDissapearance AS

BEGIN TRY

;WITH yourQuery As

...

Jeff:

Do you have a test-set that I can use to test against?

jim.l (5/16/2012)

---

ok, so with your clarification on code lookup, i made some changes. below you'll find some code for the CLR project which should work. It's not the...

It's OK, I'm a VB forum... 😀

Which one doesn't work, or is it both?

And what error if any do you get?

And how are you executing this? (what facility are...

That's really a different question. Best to post it separately in its own thread.

Matt Miller (#4) (5/16/2012)

---

RBarryYoung (5/16/2012)

---

I'm still trying to figure out what it means to "Organically Cancel" a resultset. Does that mean that it comes with a sprig of broccoli...

It's usually something blocking port 1433 (or whichever one you are using). It let's the authorization finish, but SQL Server cannot finish the TDS hand-shake (or something like that,...

Check the Firewall (or router, etc.) filter settings (protocol, port, ...). This includes the software firewalls built into MS Windows OS.

Whoa! Did anyone else feel that?!? I felt a great .. disturbance in the Force ...

I'm still trying to figure out what it means to "Organically Cancel" a resultset. Does that mean that it comes with a sprig of broccoli or something? 😀

Tell us what the user is doing (including what program/tool they are using) and what the result is, including the error message.

Just to affirm what Howard and Grant have been saying: In 12 years...

Yep, that would do it.

Ouch!

😀

Grouch