Re: DBAs:Databases 1:10 (Oracle) 1:31 (SQL Server)

On 6/13/06, Zelli, Brian <bzelli_at_greatbatch.com> wrote:
>
> As a SQL server and oracle DBA, the concept of schema's was introduced
> in SQL Server 2005. I was just at a class where they said that they
> want to make SQL Server more "oracle like"
>
>

Enhanced in SQL SErver 2005, yes.

Introduced, no.

From the SQL Server 2000 books online:

CREATE SCHEMA AUTHORIZATION ross
GRANT SELECT on v1 TO public
CREATE VIEW v1(c1) AS SELECT c1 from t1
CREATE TABLE t1(c1 int)

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l