MDP - please do not cross post. I've posted a reply to your other post under Administration, we can finish the discussion there.

Thanks!

Andy

No idea! Never ran into that problem. I'll do some looking and maybe try to duplicate.

Andy

Wouldnt that be a function of your app rather than the cluster? Not uncommon to drop/lose a connection to the server, normally you just trap that error and try to...

I havent seen any general specs - most are pretty specialized. I'd recommend that he think of a fairly common scenario - banking/checking account is a great one, then begin...

We've had this on our list for a while - I'll have to check the status, but I believe it's something that will get rolled out for testing in the...

Not that I can think of. Typically you use output when you are working a singleton situtation. With a recordset by default you're saying Im not sure how many records...

That sounds right. Have you tried creating a test proc with ONLY the code that accesses the remote server, see what that does?

Andy

Hey Chris,

Looks interesting. I used linked servers pretty often, but mostly for just direct table access and not using procs. Possibly you're hitting a limitation of the data provider.

One work...

Hi Trisha,

I've got a couple questions a little off topic. The first is - are they your actual field names? I ask because you seem to be using Hungarian notation,...

Not sure why it would make a difference. Are you going to back up directly to tape, or to disk first and from there to tape? Just out of curiousity,...

You're definitely taking a risk defining a table where there is the possibility that the data length could exceed the row capacity. Splitting the table and using triggers to maintain...

Hey Simon (& Mindy)

My only concern about NOT using refresh is that you're trading "scalability" for design flexibility. It's easy enough to generate code that creates the parameters collection for...

I will have to drag out the book to make sure - seems like the checkpoint just marks the log at a position where the log can be reused, but...

If it runs fine in QA then I'd say you can rule out syntax. Are you the person running the proc will have rights on the other server to do...

Its basically the same as generating xml manually (not using the ADO option to persist as XML). Another option would be to apply a transform to the XML to generate...