Browse by Tags

All Tags » SMO (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 | 1 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: , ,
How to fix slow SMO performance
By default, when SMO queries the database for the properties of an object, it only loads the basic properties. This reduces the number of tables it needs to join in the query, so dramatically improves performance, as long as you don't need the other properties...
Posted 09 February 2008 12:16 PM by jonsayce | with no comments
Filed under: ,