Managing the Default DB and Language for a SQL Server Login

In this video for beginners Brian shows you how and why to use the default database and language for a login. He also covers some of the caveats that go along with specifying a default database.

Brian is a SQL Server author, columnist, and MVP focusing primarily on SQL Server security. He currently serves as database administrator / architect at AgFirst Farm Credit Bank where he can focus on his passion: SQL Server. He formerly served as a systems and security architect for AgFirst Farm Credit Bank where he worked on Active Directory, Windows security, VMware, and Citrix. In the technical...

Dipak Saha on 7/10/2009

Great topic.

Ram on 7/10/2009

its super the guy who created this video rocks I learned so much.so send me another video you got that mister!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Jamshid Nouri on 7/10/2009

excellent

Sankar Reddy on 7/12/2009

Brian, Good info! /Sankar

Caleb Bell on 7/16/2009

Thanks for explaining the up-sides and down-sides to this technique and showing what happens in error scenarios. Very helpful!

Dinesh Pendlimarri on 7/17/2009

Short and sweet as always!