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.

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.

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.