+ Reply to Thread
Results 1 to 3 of 3

Cannot create database diagrams

  1. Cannot create database diagrams

    Hi,

    I am new to SQL 2005. I have recently setup SQL Server 2005 and retore a
    database from SQL 2000. The database seem to be working except that It won't
    allow me to chane or create new database diagram.

    The following error:

    TITLE: Microsoft SQL Server Management Studio Express
    ------------------------------

    Database diagram support objects cannot be installed because this database
    does not have a valid owner. To continue, first use the Files page of the
    Database Properties dialog box or the ALTER AUTHORIZATION statement to set
    the database owner to a valid login, then add the database diagram support
    objects.

    ------------------------------
    BUTTONS:

    OK
    ------------------------------


    SF



  2. Re: Cannot create database diagrams

    Customize and run the following command batch:

    EXEC sp_dbcmptlevel 'yourDB', '90';
    go
    ALTER AUTHORIZATION ON DATABASE::yourDB TO "yourLogin"
    go
    use [yourDB]
    go
    EXECUTE AS USER = N'dbo' REVERT
    go

    --
    Ekrem Önsoy



    "SF" wrote in message
    news:u6aQmvlNIHA.5860@TK2MSFTNGP04.phx.gbl...
    > Hi,
    >
    > I am new to SQL 2005. I have recently setup SQL Server 2005 and retore a
    > database from SQL 2000. The database seem to be working except that It
    > won't allow me to chane or create new database diagram.
    >
    > The following error:
    >
    > TITLE: Microsoft SQL Server Management Studio Express
    > ------------------------------
    >
    > Database diagram support objects cannot be installed because this database
    > does not have a valid owner. To continue, first use the Files page of the
    > Database Properties dialog box or the ALTER AUTHORIZATION statement to set
    > the database owner to a valid login, then add the database diagram support
    > objects.
    >
    > ------------------------------
    > BUTTONS:
    >
    > OK
    > ------------------------------
    >
    >
    > SF
    >



  3. Re: Cannot create database diagrams

    Thank you Ekrem Önsoy

    It work very well.

    Sf

    "Ekrem Önsoy" wrote in message
    news:B940FE13-BD19-4BB8-834B-C04DE070A397@microsoft.com...
    > Customize and run the following command batch:
    >
    > EXEC sp_dbcmptlevel 'yourDB', '90';
    > go
    > ALTER AUTHORIZATION ON DATABASE::yourDB TO "yourLogin"
    > go
    > use [yourDB]
    > go
    > EXECUTE AS USER = N'dbo' REVERT
    > go
    >
    > --
    > Ekrem Önsoy
    >
    >
    >
    > "SF" wrote in message
    > news:u6aQmvlNIHA.5860@TK2MSFTNGP04.phx.gbl...
    >> Hi,
    >>
    >> I am new to SQL 2005. I have recently setup SQL Server 2005 and retore a
    >> database from SQL 2000. The database seem to be working except that It
    >> won't allow me to chane or create new database diagram.
    >>
    >> The following error:
    >>
    >> TITLE: Microsoft SQL Server Management Studio Express
    >> ------------------------------
    >>
    >> Database diagram support objects cannot be installed because this
    >> database does not have a valid owner. To continue, first use the Files
    >> page of the Database Properties dialog box or the ALTER AUTHORIZATION
    >> statement to set the database owner to a valid login, then add the
    >> database diagram support objects.
    >>
    >> ------------------------------
    >> BUTTONS:
    >>
    >> OK
    >> ------------------------------
    >>
    >>
    >> SF
    >>

    >




+ Reply to Thread