Browse by Tags

All Tags » SMO » .NET (RSS)
Programmatically Listing SQL Servers
Using the .NET Framework there are a variety of ways you can search for available SQL Servers, but no single technique does the whole job. The best approach is to use a combination of methods to ensure you get the most complete list possible. Most methods...
Posted 10 February 2008 10:37 PM by jonsayce | 3 comment(s)
Filed under: ,
Extending SMO Classes with Extension Methods and IEnumerable(T)
One of the simplest ways to audit changes to a table is to have a trigger that stores a copy of any row that's inserted/updated/deleted, together with some meta data such as who made the change and when they made it. There are limitations (such as several...
Posted 09 February 2008 02:50 PM by jonsayce | with no comments
Filed under: , ,