How to Change SQL Server Authentication Mode with a Discussion on Differences in SQL Server Service Pack Levels - Video Series Video Category: SQL Server Security Skill Level: 300 (Intermediate) Versions/Editions Covered: SQL Server 2000 This series shows you how to change the authentication mode (from Mixed Mode to Windows Authentication and vice-versa). It also discusses pros and cons of both modes while showing you the differences between a SQL Server 2000 RTM installation and an SP3/4 one

Videos in this Series:

Title Skill Length Download Part 1 - How to Change SQL Server Authentication Modes with a Discussion on Diff...   300 7 mins. Download Part 2 - How to Change SQL Server Authentication Modes with a Discussion on Diff...   300 2 mins. Download

< Return to list of all videos

Related Links:

Umachandar's SQL Server 2000 Scripts - Thank the world for this man's efforts because he sure has many interesting scripts Microsoft SQL Server 2000 Bible - Paul Nielsen is a SQL guru - there's no question. This book is a huge tome of great SQL info and comes highly recommended for newbies and intermediate-level DBAs and developers An Introduction to Database Systems - This is the seminal work - the collegiate textbox from which much of today's books refer back to. Be aware that this book is about SQL, not a particular implementation of SQL

Miscellaneous Bits & Pieces:

Did you know that the database role "ddladmin" can TRUNCATE the table (delete all rows) but not SELECT? Book You Should Probably Own: Christopher Date's "An Introduction to Database Systems" There is a version of the "Adventure Works" sample database available for SQL Server 2000. Go to any search engine and search for "AdventureWorks2000" and locate the download file. AdventureWorks2000 is a more robust sample database than Northwind and pubs