I have the following command
EXECUTE XXXXXXX.master.dbo.sp_executesql N'TRUNCATE table TEST_RECOVERY.dbo.table1'
that works fine in QA but when added to a DTS package to clear down a table on a linked server I get the following:
Could not connect to server 'xxxxxx' because 'sa' is not defined as a remote login at the server.
The source and target sa pwords match up any idea's?? (Yup I know its bad practice to use sa but give me a break until I get it working 8))