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.

SQL Server Mixed Mode in SMO

SQL SMO is an object library that lets you control almost everything in SQL Server via .net code. This video by SMO expert Tim Mitchell shows you how to get a list of databases that are in mixed mode using SMO - very useful if you're trying to migrate to one hundred percent Windows only authentication.

Video Information
Publish Date:	September 09, 2008
Length:	1:52
Skill Level:	200
Rating:	4.09 out of 5

After watching you should be able to answer these questions:

What SQL SMO property would you check to see if mixed mode (Windows and SQL logins) was allowed?

What method of SQL SMO would you use to enable you to loop through all discoverable servers?

You must be logged in to view this video.

Rate This Video:	12345
	1=Poor, 3=Good, 5=Excellent

Comments:

WChaster on 3/11/2009

As I looked at the screen it appear that some on the coding was above teh viewing area. How does one get the full transcript to do this in their own environment?

Steve M on 3/11/2009

I seem to have missed the getting started with SMO video. I'll watch the rest of them. This looks to be very useful.

Tim Mitchell on 3/12/2009

WChaster, you can download the code at the top right of the screen. Enjoy!

Glen Anderson on 3/12/2009

Not much detail. Perhaps if we new in the title that this was a follow-on to other SMO topics.

Tonci on 10/9/2009

Really good to know about how to traverse available sql servers.


Must Be Logged In

References

Code from video

Download the code from this video