Re: sql server

This question has already been replied in another NG. Please do not post your questions to different NGs seperately.

--
Ekrem Önsoy



"jassie" <jassie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:E8E70708-810D-4352-B88E-DE7177C164D0@xxxxxxxxxxxxxxxx
I am new to using sql server 2005 management studio. The sql server 2005
managment studio is connected to a sql server 2000 standard edition database.
Problem: the default schema name for me on sql server 2005 management studio
desktop version is xx/user. This tool will not allow me to create a View
and/or table with the ‘schema name’ as dbo.

How do you recommend that I solve this problem?
(**Note: I work for a small company. I do not have access to the sql
server 2000 enterprise manager and query analyzer tools.)
If what I listed below a good solution and/or is there a better solutuion?

If you refer to the link at:
http://blogs.msdn.com/mssqlisv/archive/2007/03/23/upgrading-to-sql-server-2005-and-default-schema-setting.aspx,
You will see the following:

How do you change the DEFAULT_SCHEMA?
Assuming your database is using objects only in the dbo schema here is what
you would run for each user:
ALTER USER <Username/> WITH DEFAULT_SCHEMA=dbo.

Thanks for letting me know how I can create tables and views with 'dbo' as
the schema name!

.

Relevant Pages

  • Re: Change schema owner
    ... management studio and there it was simple to change ... ALTER AUTHORIZATION ON SCHEMA::SomeSchema TO dbo; ... First I want to list all schemas for that user which he own but I havn't found how because when you are to change schema owner you must name the schema!? ... I have changed DBO to another user. ...
    (microsoft.public.sqlserver.security)
  • RE: Please help with deleting a user.
    ... MCITP: Database Administrator ... it says that it can not alter "dbo" schema. ... I am new to SQL Server. ...
    (microsoft.public.sqlserver.security)
  • Please help with deleting a user.
    ... I created a in sql server 2005. ... ALTER AUTHORIZATION ON SCHEMA::dbo TO guest; ... it says that it can not alter "dbo" schema. ...
    (microsoft.public.sqlserver.security)
  • sql server
    ... I am new to using sql server 2005 management studio. ... managment studio is connected to a sql server 2000 standard edition database. ... Assuming your database is using objects only in the dbo schema here is what ...
    (microsoft.public.sqlserver.setup)
  • Re: default schema (SQL Server 2005)
    ... SQL Server will prevent that with: ... Cannot alter the user 'dbo'. ... schema for this role "dbo" and our application has been writtem not to ...
    (microsoft.public.sqlserver.security)