What code did you use with sp_addlinkedserver?

Can you do a simple select from the remote server?

Like so : Select * FROM RemoteServer.Master.dbo.SysObjects

How long is the job for?

Only for US citizen or canadians can apply?

Genergous sounds like a lot of money.  Close to 1.5 - 2k$/day.  How generous are you really??

Check out sp_addlinkedserver in the books online.  I can't give  you the exact syntax without asking much more info !

Message back if you have...

Never seen that anywhere.  Can you post some sample data and the required output from that sample data?

That should do it (untested!?!?)

SELECT DATEADD(D,0, DATEDIFF(D, 0, GETDATE()))

Have you thaught about archiving this data on another server... I doubt that this type of infromation is to be deleted... ever!

That question was already corectly answered.  I have no idea what problem you are encountering.  Can you tell us more about the process and the problems you are encountering?

I think you need to read articles on performance tuning.  The size of the table may have absolutely nothing to do with slow running queries.

Do you have an exemple of...

Or maybe this could eliminated a costly join :

create table ttemp

(

id primary key clustered

)

insert into ttemp (id) select id from tmain

set rowcount 10000

while @@rowcount > 0

begin

update tmain set col =...

That doesn't need to be dynamic sql at all.  This works perfectly :

SET ROWCOUNT 10000

WHILE 1=1 --Be careful with this you don't want an infinte loop!

BEGIN

    UPDATE myTab

       ...

Sorry for the lack of comments... but this is better than nothing :

Public Sub test(ByVal sFolder As String)

On Error GoTo Gestion

    Dim MyApp As Access.Application

    Set MyApp = New...

I wouldn't try to reinvent the wheel ifI were you.

You can use this :

ORDER BY DIFFERENCE(T1.col, T2.Col) DESC

You can also set on filter on matches that are 3 and 4...

Ninja raises his hand and shakes frantically waiting for the teacher to let him answer the question .

That should work.  But keep in mind that if @d2 = '2006/11/15' and that reservations are made for '2006/11/15 15:00:00.000'.  Then the latter date will not be found by the...

Well in the graph you can do some minute modifications.  Relations being one of them.  But my favorite is scripting it out in QA and running it.  Another alternative would...