Cross Database Ownership Chaining - Video Series Video Category: SQL Server Security Skill Level: 300 (Intermediate) Versions/Editions Covered: SQL Server 2000 Cross database ownership chaining was added by Microsoft in Service Pack 3 for SQL Server 2000. There are some major changes to the internals - things are no longer like they used to be. Want to know the difference? Check out this series of videos!

Videos in this Series:

Title Skill Length Download Part 1 - Cross Database Ownership Chaining - What It Is and When to Use It   400 4 mins. Download Part 2 - Cross Database Ownership Chaining - What It Is and When to Use It   400 14 mins. Download

< Return to list of all videos

Related Links:

MSDN's SQL Server Section - Code samples, articles and more DBArtisan - The standard tool suite for those DBAs and developers who work with multiple relational database management systems (such as Oracle, SQL Server, and DB2) SQL for Smarties: Advanced SQL Programming - Joe Celko is the guru's guru and we all just want to be half as smart as him. Be aware that this book is about SQL, not a particular implementation of SQL

Miscellaneous Bits & Pieces:

SQL Server 2000 Service Pack 3 Additions/Changes: A new Transact-SQL function "fn_get_sql" was introduced to help DBAs diagnose problematic processes Disk defragmenters can make your system run faster by reorganizing your files according to usage statistics and by keeping files contiguous. Disk defragmentation programs search out the parts of files that are scattered around the hard drive and attempt to put the files into a contiguous block. 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