Michiel Wories' WebLog

In a previous article I have showed how a SMO object can be serialized into a Transact-SQL script, which allows you to recreate the object. What if you want to have the script that is emitted when you changed one or more properties of an object? In that Read More...

Let's first clarify what I mean by "scripting". It often happens during talks or when I explain SMO fundamentals that eyes gloss over, shortly after which the "what * do you mean by scripting" question pops up (replace the * with your favorite combination Read More...

There are several ways of controlling connections in SMO -- you can control pretty much any aspect of a SMO connection. Pooled connections Let's take a look at a typical way how you would obtain a connection using a simple C# sample: Server svr = new Read More...

In the previous post I provided you with a fundamental tool to minimize the amount of SQL statements emitted and therefore limit expensive network round-trips (and SQL statements) using the Server.SetDefaultInitFields() method. In this post I will provide Read More...