Capture CREATE, DROP, ALTER from the default SQL trace file
Tracks and stores changes to database objects by reading from the default SQL server trace file using ::fn_trace_gettable()
2015-02-02
5,022 reads
trace files
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.
2012-10-18 (first published: 2012-09-20)
529 reads
Working with SQL Server Profiler Trace Files
In a previous tip we looked at the steps to Create a Trace Template in Profiler. In this tip we will look at a few more tips such as creating a trace template from an existing trace file and saving a trace file to a SQL Server table.
2011-02-16
4,352 reads
RE: Creating a PDF from a Stored Procedure
WOW! A++++++ this is a super procedure! Kudos to you for all your hard work! I am using this on a production DB that logs all firewall / web traffic event logs. I then setup this up as a job that runs daily and creates pdf reports based upon various criteria. Again, great job on […]
2004-02-23
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 […]
2004-01-06
2003-08-27
RE: Enterprise Manager Security
Hi Brian, verified your statement. The user in question is local admin to his box, no access under his account to Server a, but as member of an NT User Group with local admin rights to Server A.... Thanks again for pointing me in the right direction Cheers, Frank
2003-05-16
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers