We have two W2K servers in Workgroup mode running SQL 2K. We use xp_cmdshell
with /E switch to run DTS packages locally on each server.
I have a new DTS package that deletes table rows on the other server, then
copies local rows to remote table.

The DTS package will execute directly & delete/add rows. But it gets error
running xp_cmdshell from a stored procedure:

'Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

I have tried:
exec master..xp_cmdshell 'dtsrun /Sncid03 /Ncopy_control /E'
and
exec master..xp_cmdshell 'dtsrun /Sncid03 /Ncopy_control /Usa /Ppassword'

Thanks -