SMO Samples Galore


With much of the SQL Server 2005 devcelopment behind us, I am starting to have some more time to post some SMO samples. Most of these are inspired on questions in the beta newsgroups or the SMO/DMO forum.


Additionally, SQL Server 2005 ships with a pretty wide variety of samples. In fact, there are more SMO samples than there are for any other product area, and we have been adding samples up till a a few weeks ago (from here it is pretty much locked down).


Let me know if you have any sample requests!

Comments (3)

  1. PDav says:

    I really would like to know how to create logins, create users, and assign passwords in SMO/C#. I figure that would be something I could put in a CLR stored procedure for security. I can add permissions using TSQL, but passwords are hard to hide. Anything you’ve got would be helpful.

    Thanks.

  2. stuart.meeks@datacom.com.au says:

    I’d be stoked if you could post a howto on creating assemblies using the SqlAssembly class!

    Thanks!