Non-GUI mode in MS-SQL Profiler

[archanabharathi]

Hi,
I was wondering if there is a non-GUI option to invoke the Profiler in MS-SQL. Basically, is it possible to invoke the Profiler and export audit log files to database tables using the command line (without using the Profiler GUI).
Or is there any option to do the same (export audit log file to database tables) without using the Profiler? As I understand, stored procedures cannot be used to write to database tables.
Thank you!

 

[nigelrivett]

>> As I understand, stored procedures cannot be used to write to database tables.

Not sure what you mean by that.

You can load the profiler via profiler.exe - not sure what you would do after that but doesn't seem a good route.

Not sure what yo want to do but you could consider saving the tr logs and using the log explorer from lumigent to interrogate them.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.