If you use the Security: table in enterprise manager to set the link server using current login ... you can reference the server in your statement.

Then ....

i.e.

From Server1

Select * from...

This is the ActiveX script we use inside a DTS package.

'**********************************************************************

'  Visual Basic ActiveX Script

'************************************************************************

Function Main()

Dim MyFSO, FName, dtMM, dtDD, dtYYYY

dtMM = month(now())

dtDD = day(now())

dtYYYY = year(now())

if len(dtMM) = 1...

I currently run a job monthly to cleanup the backup history with the following. I schedule the job and add a log just for verification.

Runs under MSDB

set nocount on

PRINT 'Record...

If you put the order by asc you will get the bottom 5 ....

Deborah Talley