Create Schema in Sql Server 2000

Hi everybody, I like to asked anyone who is very good at T-Sql to help me with Sql Server 2000. Thanks in advance. In Sql Server 2000 I have the statement use DBTEST CREATE SCHEMA AUTHORIZATION Ross CREATE VIEW v1(c1) AS SELECT c1 from t1 CREATE TABLE t1(c1 int) GO It work correctly, but Ross don't belong to DBTEST; also use DBTEST CREATE SCHEMA AUTHORIZATION atrandom CREATE VIEW v1(c1) AS SELECT c1 from t1 CREATE TABLE t1(c1 int) GO work with correctness. Why ? The owner can be every words ?

SQL Server 2000 does not have schema concept like SQL Server 2005 so the authorization syntax doesn't really do anything. User-schema separation is available completely in SQL Server 2005 where the authorization clause makes sense.