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

• Anonymous
  December 12, 2006
  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.

• Anonymous
  May 04, 2007
  Nice http://myurl.com.tw/h7ht <a href="http://myurl.com.tw/h7ht">laptop</a>  [url=http://myurl.com.tw/h7ht]computer[/url]

• Anonymous
  August 19, 2007
  I'd be stoked if you could post a howto on creating assemblies using the SqlAssembly class! Thanks!