July 13th, 2011 
When working with meta data tables it can be very useful to track when people make changes to the data. How do you track any change against any number of columns for any table? I have implemented a fairly simple solution that uses triggers and stores all changes as XML into one change log table. [...]
Posted in 
Tags: 
Recent Posts
Archives
Categories
- .NET (4)
- ASP.NET (0)
- Atlanta (3)
- Business Intelligence (5)
- C# (0)
- Cloud (0)
- Cloud Storage (1)
- Consulting (2)
- Consulting Services (3)
- Data Dude (0)
- Database Development (6)
- Datachix1 (1)
- Development (1)
- General (16)
- Integration Services (4)
- OneNote (1)
- Performance (1)
- Server Management (2)
- SharePoint (0)
- SharePoint Administration (1)
- SQL (20)
- SQL Meme Monday (3)
- SQL PASS Summit 2012 (3)
- SQL Saturday 89 (4)
- SQL Server (9)
- SQLServerPedia Syndication (6)
- SSAS (1)
- SSIS (0)
- T-SQL (0)
- T-SQL Tuesday (3)
- Uncategorized (0)
- Visual Studio (9)
Tags
.NET ASP.NET Atlanta Business Intelligence C# Development Disk Usage EzAPI logging Microsoft PASS Power Pivot SQL SQL 2008 SQL Server SQLServer SQLServerPedia Syndication SSIS T-SQL TelerikRecent Comments
- Chris: Hi, Matt. I was not at the presentation, but I do... »
- Mladen Prajdic: you might want to look into async triggers with Se... »
- tier 1 visa: Create an FTP Connection manager. I named mine co... »
- Jason E Bacani MBA (@JEBacaniSQLDude): I actually keep Visine handy... For the blood shot... »
- Seema: Hello Matt, I am having problem while setting C... »
- Audrey Hammonds
(10) - Brian Thomas
- Gary Giles (3)
- Jason E Bacani MBA (@JEBacaniSQLDude) (18)
- Jeff King
- Jeff Price
- Josh Robinson (20)
- Julie Smith (2)
- Mason Prewett (7)
- Matt Wollner (16)
- Nilesh Gala (1)
- Test User
- Tiffany Heffner (2)
Meta
Powered by WordPress | Free WordPress Templates by Free WordPress Themes | Thanks to WordPress News Themes and WordPress 3 Themes