Thanks for your reply.
I debug step by step and then i found as below.
1. use DM_SCNYLDMS03_docbase ==> pass
2. IF OBJECT_ID ('auditrec', 'view') IS NOT NULL DROP VIEW auditrec ==> pass
3. create view dbo.auditrec as
select u.scnyl_pol_no,u.scnyl_box_id,u.object_name,u.event_name,u.user_name,
u.event_description,u.time_stamp from
(select dbo.scnyl_supertype_sp.scnyl_pol_no, dbo.scnyl_supertype_sp.scnyl_box_id, dbo.scnyl_supertype_sp.object_name,
dbo.dm_audittrail_sp.event_name, dbo.dm_audittrail_sp.user_name, dbo.dm_audittrail_sp.event_description, dbo.dm_audittrail_sp.time_stamp
FROM dbo.dm_audittrail_sp INNER JOIN dbo.scnyl_supertype_sp ON
dbo.dm_audittrail_sp.chronicle_id = dbo.scnyl_supertype_sp.r_object_id)u
==> pass
4. exec master..xp_cmdshell 'IF EXIST D:\AuditExport\Report\policies_log-%date:~10%%date:~4,2%%date:~7,2%.txt DEL D:\AuditExport\Report\policies_log-%date:~10%%date:~4,2%%date:~7,2%.txt'
==> pass
5. exec master..xp_cmdshell 'bcp "select * from dbo.auditrec order by scnyl_pol_no desc" queryout "D:\AuditExport\Report\temp_policies_log-%date:~10%%date:~4,2%%date:~7,2%.txt" -U scnyl\Administrator -P Passwords1 -S DISERVE-DB-01 -c -T -t ";"'
==> found the error
Error = [Microsoft][SQL Native Client][SQL Server]Invalid object name 'dbo.auditrec'.
SQLState = 37000, NativeError = 8180
Error = [Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared.
I already config at DISERVE-DB-01 (it's database server and the same instance name) as
1. open DB Engine remote connections to be "using TCP/IP and name pipes"
How can i do anymore????? Many thanks!!!