Re: Database Diagram leads to ownership issue.

Use:
sp_changedbowner 'newownername'

RLF

"light_wt" <lightwt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0F9384CF-F28F-4CFA-AB19-74EC7634EF1F@xxxxxxxxxxxxxxxx
Hi,

I am trying to let SQL Server to generate the Database Diagram.

i've got the error "database diagram support objects cannot be installed
because this database does not have a valid owner."

Currently, it is own by a developer id no longer with the company. What
will be the best way to handle/correct this?

Thanks.


.

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 dbo user issue
    ... 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 ... > can't go the other way regardless of the database compatibility level. ...
    (microsoft.public.sqlserver.security)
  • 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: Database Diagrams
    ... SQL Server Documentation Team ... To install database diagram support in SQL Server Management Studio, ...
    (microsoft.public.sqlserver.tools)