And does it still work if you remote into the prod server and run SSMS there?

Farrell Keough (1/5/2009)

---

Thanks. Let's see - where would the button be to attach a file?

Got it. "Edit Attachments" Unusual...

Well, I've never seen it for OPENROWSET, but it sounds like you are being bitten by the "Two-Hop Rule". This thread has a good explanation of it for Linked...

Farrell Keough (1/5/2009)

---

I have the two approaches with about 13,000 records for testing. But(!), I do not know how to post them without blowing through a huge page. ...

Gmail handles these really nicely for me.

I have a label defined for them, so they are all off in their own "folder". And gmail automatically collects multiple notifications for...

ROTFLMAO! :w00t:

OMG, that is funny! I am going to have send that to my...

GilaMonster (1/5/2009)

---

Wasn't that for the...

You certainly do not need a cursor for this. The same technique that I used above will work here also.

Already answered in the other htread.

(You are cross-posting you questions now which is confusing/annoying for us. Just ask them once and keep the threads straight.)

Actually, I heard from someone at PASS that WITH RECOMPILE does not work reliably for this problem in SQL2005, but "is fixed" in SQL 2008.

use:

select * from sys.symmetric_keys

That depends on whether you will be using SB point-to-point or...

Actually, no. I really do not know much about it, particularly how to fix it. I just have seen this one posted so many times here that it's...

Then try these command yourself for each database one at a time, and see if any of them fail.

Yeah Grant, it's easily one of the Top 5 questions on the boards here.

If I could find a good article on it here at SqlServerCentral.com then I could...