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.

Alfredo Severo on 6/16/2011

Yes, have any way to set the authentication mode with SMO? :D thanks in advance!

Justin Bennett on 8/5/2011

A great pointer on SMO, something I've needed to look at more, highlights how simple & clear & powerful the API is, thanks.

Rohan on 8/5/2011

Great clip and never knew this before. Thanks, Rohan Joackhim

Paul on 8/7/2011

Nice and simple. Thanks

Mat on 8/7/2011

It would be good to be able to copy the code from the webpage.

46896E188B on 8/9/2011

good one

Jim on 8/9/2011

need to briefly describe what happens if SQL is running on another port.

Maurice Ivory on 12/29/2011

I'm getting better, but this had good content in it.

Maurice Ivory on 1/9/2012

This will save alot of time.