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.


  2. says:

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


Comments are closed.

Skip to main content