Rajeev

Like I said before you can stripe your backup across multiple smaller files. If this helps with your backup to tape then thats great but you really should have your...

you can strip your backups across multiple files but this won't do it in chunks like you want. The best way to stop network failures affecting your backups is to...

I would love to contribute more but seldom find the time. I prefer those forums where you can respond via email like lazydba and sswug. I'm 1 DBA...

interesting indeed. puts our 300 million message/day project to shame..... but thats on SQL Server

Hi David

As a test you can generate RPC events like this:

OSQL -E

1> {call sp_who()}

2> GO

Hope this helps

I've used your script to capture a trace file. When I open the trace file in Profiler I see loads of RPC:Completed events with all the fields displaying EXCEPT...

provided the app doesn't need any user intervention and message boxes etc can be suppressed then you can call an executable from SQL stored proc by using xp_cmdshell to...

thanks for the reply.

Please note that the last part of my script, to stop the Trace, should only be run once you have issued some RPC:Completed events that have been...

that is a GREAT tip. I will work on it.

thanks.

-- cranfield

thanks for that. Adding the BatchCompleted event is certainly an option and will work but we're only interested in RPC:Completed event.

I see the Textdata just fine when I run...

No, the textdata field is not there in the properties.

This is my trace code. Try it for yourself. You will see that the .trc file that gets generated does not...

hi Greg

Thanks for the pointers. This works for me:

select j.name, jh.message, jh.run_status , jh.run_date , jh.run_time , jh.run_duration

from msdb..sysjobhistory jh

join msdb..sysjobs j on jh.job_id =...

Hi

The properties box does not list the TextData column nor does it list the filter I specify in my script.

The textdata field is there in the .trc file as I...

me too... lots of errors.

-- cranfield, DBA