Thanks Markus,

I found microsoft says 64 bit(bit not specified whether it IA64 or X64) about migrations and features availavle,

is all features available in x64 sql server 2005  as compared to...

I have changed startup parameters some time back, I looked at it but the path is fine,

I will recheck about the space

thanks

Hi,

you cane make use of bleow to suit your need

I have done below for login auditing and writing to table

declare @rc int

declare @TraceID int

declare @maxfilesize bigint

declare @filename_prefix nvarchar(128)

declare...

Mohammed

Its reporting as step1 successfull and when I look at SQLAgent error log,

found

1.[162] Internal request (from SetJobNextRunDate [reason: schedule will not run again]) to deactivate schedule 2171

2.[180] Job...

even with SA also its endinga t step1

Job '{FE60D42E-C71E-4E32-8C5C-A44640E09B82}' :

Step 1, 'run sp' : Began Executing 2006-12-06 08:09:16

 [SQLSTATE 01000]

Job '{FE60D42E-C71E-4E32-8C5C-A44640E09B82}' :

Step 2, 'Delete job' : Began Executing 2006-12-06 08:11:25

Msg 0, Sev 0: Operation canceled [SQLSTATE...

No errors,found

step1 is faling or succeding and quiting