in

SQL Server Community Blogs

Voices of the SQL Server Community
All Tags » .NET » SMO (RSS)

Browse by Tags

  • 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 rely on a UDP broadcast to locate servers - this...
    Posted to Jon Sayce (Weblog) by jonsayce on 02-10-2008
  • 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 types which can't be used in the inserted and...
    Posted to Jon Sayce (Weblog) by jonsayce on 02-09-2008
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems