Read large C2 Audit Mode trace files

Here's a set of scripts that allow you to save pertinent information from SQL Server Profiler trace files.

Auditing

RE: No snapshot wanted, just transactions

Yes it can be done. But be shure you don't have upadtes or deletes from old records, because replication will fail. When you subscribe to the publisher you can choose that you already have the data and that there is no need to syncronize. Or if using stored procedures in the sp_addsubscription sp, choose 'none' in […]

RE: Best Practices for Reboot Schedule

I used to reboot quarterly, apply patches, etc at that time. However with W2K, it's not that much of an issue. We have been getting enough reboots lately with the patches from MS, but a quick glance at uptime for my servers shows: ---------- OUTPUT.TXT System Up Time: 64 Days, 2 Hr, 56 Min, 51 […]