PW Your solution takes longer - 202 seconds.

Lowel - I did try datediff and it takes 93 seconds -

your example (takes 93 seconds)

select * from C_Tracked_Item_Hist

where datediff(d,ActivityDate,getdate()) > 7

my...

Field alredy has an index. If I do the following it runs fast, but I would like an alternate/better approach...

DECLARE

@sqlstr nvarchar(4000),

 @DT DATETIME,

 @DE char(13)

SET @dt = DATEADD(day, -7,...

? Please direct me to where I can set-up a maintenance plan. Is my problem that I was trying to do via enterpirse manager and not osql?

Thanks,

Sam

Throwing out things to try/check:

Has your firewall changed where it would deny port 1433  connections.  Example Windows firewall can deny connection to the remote database. If it is turned on, check to make sure that...

SELECT DISTINCT name

FROM table1

WHERE NOT EXISTS

(SELECT name FROM table2 WHERE table1.name = table2.name)

Why not use MSDE on the disconnected machines (free lite version of SQL)? You can have them run scripts to update their local schema as it changes....