hi

Team

It is completed .

in the connection we have to new connection-- Select SSH2 -->then we have to give host name etc ..

Tx guys

Hi Gail,

As per your suggestion only i have created

RAISERROR (N'xp_cmdshell call in [dbo].[xxxx_Trace] failed. Purge not complete.',

...

Hi Gail,

we can add error right

what kind of error we have to write there

and we add these errors in sys.sysmessages, using sp_addmessges

what i can add. please suggest me.

Tx

fdsfdsf

Hi team,

I have checked this command

select *from sys.messages

where id = 500001

but i m not getting any result, any suggestions on this.

Hi Team,

that is different one.

Tx

Hi Team,

I m planning to put these stored procedures in a job

in the job STEP 1: 1st sp

STEP 2 : 2nd SP

Then i will schedule this jobs certaine time

When...

Hi Team,

I got this o/p:-

Volume in drive C is Local Disk

Volume Serial Number is C0DC-EBB4

NULL

Directory of C:NULL

File Not Found

NULL

Volume in drive C is Local Disk

Volume Serial Number is...

Hi Team,

i have SA permissions

the above code O/P is :

Role: sysadmin

GRANT CONNECT SQL

Thank your reply..

Hi

Thank you for your help

the specified folder is there. yes i m looking same server only. Everything was in same folder only

I think that Sp_trace_create is prob can any...

Hi Team,

As per your suggestion i have checked every thing but i m getting below Errors please suggest me

1. Trace is not creating

Windows error occurred while running SP_TRACE_CREATE....

Hi Butt,

Thank your reply..

But i have changed the path as per my location the main prob is i m not good developer ok

But i know the systax where i...

Hi Team,

As per your suggestion i m working but i m not getting my Desired output please Guide me on good Direction.

Hi Lowell,

Thank you for your reply...

Windows error occurred while running SP_TRACE_CREATE. Error = 0x80070003(The system cannot find the path specified.).

Msg 19062, Level 16, State 1, Procedure sp_trace_create, Line 1

Could not...

Hi Lowelly,

as per your suggestion also i have worked but no use

i m getting below Errors

Msg 19065, Level 16, State 1, Procedure sp_trace_create, Line 1

The parameter is not...