Modifying SQL Server Settings with SMO

This video shows you how to modify SQL Server settings using SMO.

Tim Mitchell is a Microsoft SQL Server database developer, business intelligence consultant, writer, and speaker. He has been working professionally with SQL Server for over six years, and holds the MCTS and MCDBA certifications from Microsoft as well as a Bachelor's degree in computer science from Texas A&M University - Commerce.

Mike Dumais on 2/27/2009

pretty cool

Ed Svastits on 2/27/2009

Good examples. It needs a little more introduction.

Jim Phillips on 2/27/2009

Need to show how to run this against multiple db servers using Powershell. Need more PowerShell presentations.

Jeff Walters on 2/27/2009

As a new user i dont know what SMO is. so i had to stop the viedo and google it.

Marrina Chen on 2/27/2009

This is the first time I saw your site for displaying vido. It is very helpful for me who is the a beginner for SQL or coding. I will look into all other videos you had and really appreicate your hard work and thoughful thoghts to set up this wonderful vido site. God blesses all of you! Sincerely, Marrina

Plamen Ratchev on 2/27/2009

Very useful example, thanks!

praveen on 2/28/2009

good

Benjamin Lotter on 3/4/2009

Perhaps it is just a poor example, but managing the settings across multiple servers is much easier in SQL Server 2008 Management Studio either through policy-based management or through a simple T-SQL script. I disagree that is easier to do this in SMO, however, I'm sure there are some useful items for SMO.

Harish Wadhwa on 7/28/2011

Code from this Video link is not working.

Vamsi on 7/28/2011

Good

Leonard Peoples on 7/28/2011

I will definitely use this.

Anil Babu on 7/29/2011

good

Mat on 7/31/2011

great

Ramkumar Murugesan on 8/4/2011

This is damn good useful to me. Thanks a ton for sharing :)

Maurice Ivory on 12/29/2011

I knew the right answers but I changed my mind at the last minute.