SQL Server 2005 introduces the concept of schemas as opposed to object owners found in previous versions. This article will explain the differences between the two and, hopefully, clear up some of the confusion that still exists about schemas.Object ownersTo understand the difference between owners and schema, let’s spend some time reviewing object ownership. When an object is created in SQL Server 2000 or earlier, the object must have an owner....
Understanding the Difference between Owners and Schemas in SQL Server
- 11:17 PM
- 0 comments
- Labels: No labels
Read more »
