If you want to be able to see the data later and have less impact on your server you should run a server-side trace saved to a file. You can define the trace in Profiler and then export the definition to a script file and then do minor mod's on the script to create a server-side trace. You can get the details from BOL - server trace. Then you can either open the file in PRofiler or query it using fn_trace_gettable(Path, no of files)