New Microsoft SQL Server Video Tutorial: Schemas, Objects, and Ownership in SQL Server 2000

Schemas, Objects, and Ownership in SQL Server 2000 - view details

Schemas in SQL Server 2000 are completely different from schemas in XML, Oracle and even SQL Server 2005. You could argue that the word schema is the most re-defined word in all of the SQL world but you'd probably find that the SET keyword is at least as re-defined if not more. Anyway, this video is all about security and you need to know what schemas and users are in SQL Server 2000 (especially if you plan on moving forward to SQL Server 2005 at some point). The main concept to take away from this video is object ownership and how to change it. It's sort of hidden in the tools/language but is a very important task for all SQL DBAs

• Category: Security for SQL Server: Logins, Users, Roles and More
• Skill Level: 100 (Beginner)
• Length: 6:04 (3.30MB)
• Applies to Versions: SQL Server 2000
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

Note: You must have the TSCC codec installed to view this video