Freigeben über

SMO Samples Galore

  • Artikel

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!