Steve,

We asked, you said we would receive.  Did you forget?  Sorting by title or date would be a very useful feature for the briefcase.

Thanks

Don:

I'll second this suggestion.  I was about to post it myself when I found it.  The sort by title would be very helpful.

Thanks

Thanks for all of the great feedback.  It sounds like I'm not alone in my search for standards.

I should have explained that although I am writing specs from code now,...

If you need to send multiple rows, here's one way.  This procedure sends up to 3000 characters at a time.  If the query returns more than 3000 characters, it breaks...

Thanks Gary

I will look into ordering that book.  I am going to keep it simple with each transaction stored separately.  What I think I am looking for is a way...

Sorry, you just went beyond my knowledge of linked servers. 

This may sound dumb but as one last suggestion, is there any possibility that the sql that you are running...

If you are not getting an error message could it be a network problem that is causing the select statement to be very slow returning the data?  I would expect...

Can you post the error message and the part of the query that involves the reference to the linked server.

Also to be clear, you have server A and server B. ...

SUCCESS!!!!

I followed the instructions from mmortensen and it worked! It was even a little simpler than the instructions. All I had to put in was the server name,...

Thanks for the new suggestion. I'll try it from home tonight and post the results.

It sounds like there is no workaround. I'm surprised that with all of the Microsoft publicity about being able to do anything from anywhere with .Net that they can't...

I am running Windows XP Professional from home. The error message is Server: Msg 18452, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][Sql Server] Login failed for user '(null)'....

One correction. We use Cisco VPN not Shiva VPN if that makes any difference.

Hi,

I posted this from work so I'll have to capture the error message from home tonight. Basically it's saying that it doesn't recognize me as a known NT user...

This is something of a kluge but I think if you call the stored procedure from osql at the command line it will continue after at least some errors. ...