Re: SQL 2005 dbo user issue

From: Lazer (Lazer_at_discussions.microsoft.com)
Date: 11/09/05

  • Next message: Lazer: "Re: VS 2005 - Server Explorer - Diagrams - Invalid DBO User" 
    Date: Wed, 9 Nov 2005 08:35:36 -0800

    So there is no way for me to create a Database diagram on a SQL 2000 database
    using SQL Server management studio 2005 even though that database diagrams is
    not a new feature?

    Thanks

    "Dan Guzman" wrote:

    > Although you can attach or restore a SQL 2000 database to SQL 2005, you
    > can't go the other way regardless of the database compatibility level. To
    > promote your SQL 2005 schema to SQL 2000, you'll need to generate and
    > execute scripts (assuming you haven't used new SQL 2005 features).
    >
    > --
    > Hope this helps.
    >
    > Dan Guzman
    > SQL Server MVP
    >
    > "Lazer" <Lazer@discussions.microsoft.com> wrote in message
    > news:A3335E6F-4868-436A-98DF-480D43C06F2D@microsoft.com...
    > >I got the same error and this issue really helped me
    > >
    > > But my question is still if I will change the compatibility level and then
    > > I
    > > need to distribute this database to the production server using SQL 2000
    > > server will it work?
    > >
    > > Thanks
    > >
    > > "TomT" wrote:
    > >
    > >> Sophie,
    > >>
    > >> Thanks. that did it the trick. I guess the error message I originally got
    > >> needs to be changed to indicate the problem was with compatibility level,
    > >> not
    > >> db owner.
    > >>
    > >> thanks for your help.
    > >>
    > >> "Sophie Guo [MSFT]" wrote:
    > >>
    > >> > Hello Tom,
    > >> >
    > >> > Based on my further research, we can resolve the issue by setting the
    > >> > compatibility level to "SQL Server 2005 (90)". You can perform the
    > >> > following steps to change the compatibility level:
    > >> >
    > >> > 1. Right-click the database in the Management Studio.
    > >> > 2. Select Properties > Options > Compatibility level to "SQL Server
    > >> > 2005
    > >> > (90)".
    > >> >
    > >> > I tested it on my side and it works fine. The cause is we can only add
    > >> > diagrams to a SQL Server 2005 database. I hope the information is
    > >> > helpful.
    > >> >
    > >> > Sophie Guo
    > >> > Microsoft Online Partner Support
    > >> >
    > >> > Get Secure! - www.microsoft.com/security
    > >> >
    > >> > =====================================================
    > >> > When responding to posts, please "Reply to Group" via your newsreader
    > >> > so
    > >> > that others may learn and benefit from your issue.
    > >> > =====================================================
    > >> > This posting is provided "AS IS" with no warranties, and confers no
    > >> > rights.
    > >> >
    > >> >
    >
    >
    >

  • Next message: Lazer: "Re: VS 2005 - Server Explorer - Diagrams - Invalid DBO User"

    Relevant Pages

    • Re: A question about views in sql server
      ... and the foreign key set in the other table. ... >>> I just want to find out if it is possible to create views in SQL server ... >>> relationship between two tables in SQL server using database diagram, ... >>> Shafiee. ...
      (microsoft.public.access.adp.sqlserver)
    • Re: How to add a database diagram by means of a script
      ... There's no scripting option available for a database diagram, ... Tibor Karaszi, SQL Server MVP ... "Abhishek Srivastava" wrote in message ... > I am having a script which creates the entire db schema. ...
      (microsoft.public.sqlserver.programming)
    • Re: SQL 2005 - Disappearing Relationships in DB Diagram
      ... database diagram using SQL Server 2005. ... are the foreign key constraints really disappearing ... David Portas, SQL Server MVP ... of any error messages. ...
      (comp.databases.ms-sqlserver)
    • RE: VS2005 - cannot view or add Database Diagrams
      ... the VS2005 Server Explorer can only show the the database ... While VS2003 shows the database diagram for ... SQL Server 2000. ... Prev by Date: ...
      (microsoft.public.vsnet.general)
    • Re: SQL 2005 Express Table Relationships
      ... if you are using SQL Server Management Studio Express then you can create a Database Diagram. ... If you don't already have a diagram then you can create one by right clicking on Database Diagram and selecting "New Database Diagram". ... Also keep in mind that you can build the relationship as part of a query in Access with the Query builder almost exactley like with a MDB, though I'm not too sure if that comes with a slight performance hit or not. ...
      (microsoft.public.access.adp.sqlserver)