Difference b/w schema of 2000 and 2005

Question

I want to know the difference b/w schema of 2000 and 2005

---

"SQLSERVER DBA" "INDIA"

Answer 1

Schema concept in SQL server was only introduced from SQL 2005. In SQL 2000 all the object ownership were held by users and from 2005 its with schema.

To read more about SQL schemas and user-schema separation

http://technet.microsoft.com/en-us/library/ms190387.aspx

http://www.sql-server-performance.com/articles/dba/authorization_2005_p1.aspx

---

Thanks, Leks

Answer 2

In SQL Server objects were owned by the user, even dbo user. In SQL Server 2005 MS has introduced SCHEMA  means a container for objects. Now user may granted on few schemas to operate with...

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/