You should absolutely not run profiler on a production system as was mentioned. In addition, you should output your trace to file, not a database and especially not a database on the same server. You can use fn_trace_gettable to read the files and input them into a table.

Here is an excellent book on Profiler. Brad's the man.