|
Author:
Author Bio:
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.
|
|
|
Modifying SQL Server Settings with SMO
This video shows you how to modify SQL Server settings using SMO.
|
Video Information
|
Publish Date:
|
September 09, 2008
|
Length:
|
2:58
|
Skill Level:
|
200
|
Rating:
|
4.25 out of 5
|
|
|
|
|
After watching you should be able to answer these questions:
- Once we make changes to the SMO server configuration, how are those changes made active?
- What SQL SMO object do we use to modify server settings?
|
You must be logged in to view this video.
|
|
|
|
|
|
Comments:
|
|
pretty cool
|
|
|
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
|
|
|
Very useful example, thanks!
|
|
|
good
|
|
|
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.
|
|
|
|
|
|
|