This works for me : Select * from dbo.SysObjects for XML auto

check this out :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=179518

Just make sure you get the minimum rowcount from the remote server. This will help a lot because it'll be less work for sql server.

Also test a few versions...

This is something that is easier done at the client.

Just do : Select fruit from dbo.Fruits order by Fruit

Then when you read the recordset, just use the bookmark number or...

http://www.microsoft.com/sql/msde/downloads/default.asp

There's also an express version of sql server 2005 that's gonna come out in november without the 5 users limit.

The 5 users is actually 5 simultaneous process. But...

I would have to go with Kathy on this one. The fact is that if a 1 first user modifies a record while the 2nd user in using it,...

Can't provide one without seeing the whole code, sorry.

I don't think you can do this. Go is the batch terminator.

Can you post the code so we can provide suggestions?

I've never done anything like this, but I still don't see that code hapenning without dynamic sql. You just can do select ? from @TableNameVar.

Sorry if I can't provide...

Sounds like you have two problems. First you cannot use @TableVar.column. You must assign an alias to the table variable to be able to do something like TV.Col=...

SSN and CCODE are the primary key, and are therefore always included as a refference in the index.

Also if autonumber and ModifiedDate are not used in the same where condition...

Yes, sp_oa are notoriously slow. They cause a lot of overhead (in memory/cpu mostly). If you could batch import the files, then in 1 select statement, validate/split, then...

Oops... at least he got the idea .

I haven't experienced with it yet... But I guess it can help if you've written class in .net that you need to use on the server. But I don't...

Make sure you call the proc in this manner:

Declare @OutParam datetime

--not mandatory

--set @OutParam = 'somedate'

exec dbo.twrsp_ModifyLastDownloadTimestamp @OutParam output, 'UserName'

Select @OutParam