f



SQL 2005 Developers Diagram question

I detached a SLQ 2000 database and reattached it in 2005 Developers.
When I try to access the Diagrams, the below message is received.  My
domain account is owner.  I'm local Admin on my machine.  Shouldn't be
a problem right?  How do I add the Database Diagram Support Objects?



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

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
------------------------------

0
11/15/2005 5:45:34 PM
comp.databases.ms-sqlserver 14567 articles. 0 followers. janinepelletier (108) is leader. Post Follow

1 Replies
315 Views

Similar Articles

[PageSpeed] 20

I found this SQL Community / As a Question.  Hope it helps someone out.

************************************************************


In SQL Server Management Studio do the following:

1. Right Click on your database, choose properties
2. Goto the Options Page
3. In the Dropdown at right labeled "Compatibility Level" choose "SQL
Server 2005(90)"
4. Goto the Files Page
5. Enter "sa" in the owner textbox.
6. Hit OK

0
11/15/2005 6:20:40 PM
Reply:

Similar Artilces:

Open SQL 2005 database question
Shoud a SQL 2005 database remain open in a Visual Basic program, or should it be opened and closed in every subroutine? Thanks for any info. Charlie wrote: > Shoud a SQL 2005 database remain open in a Visual Basic program, or should > it be opened and closed in every subroutine? How often will the VB program access the database? Charlie (jadkins4@yahoo.com) writes: > Shoud a SQL 2005 database remain open in a Visual Basic program, or should > it be opened and closed in every subroutine? You don't really open or close the database, but you connect and disconnect from the server. It's common to do as you say open and disconnect. It's not really cheap to open a connection to SQL Server. However, the client API maintains a connection pool, so behind the scenes the connection is open, and is reused when you connect anew. (If there is no connection for a certain amount of time, typically 60 seconds, the connection is closed for real.) Then again, in a two-tier application it's not really any major flaw to have a global connection that you keep open. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx Very frequently. "Ed Murphy" <emurphy42@socal.rr.com> wrote in message news:4726a8c5$0$11450$4c368fa...

ms sql 2005 developer edition
is it possible to install ms sql 2005 developer edition databse server on window XP professional version 2002 with SP2 or just allows install client version? On Oct 3, 10:39 am, HandersonVA <handerso...@hotmail.com> wrote: > is it possible to install ms sql 2005 developer edition databse server > on window XP professional version 2002 with SP2 or just allows install > client version? Of course you can - the only version you can't install on a client machine is the SQL Server Enterprise Edition! JC xSQL Software http://www.xsqlsoftware.com On Oct 3, 12:23 pm, xman <x...@xsqlsoftware.com> wrote: > On Oct 3, 10:39 am, HandersonVA <handerso...@hotmail.com> wrote: > > > is it possible to install ms sql 2005 developer edition databse server > > on window XP professional version 2002 with SP2 or just allows install > > client version? > > Of course you can - the only version you can't install on a client > machine is the SQL Server Enterprise Edition! > > JC > xSQL Softwarehttp://www.xsqlsoftware.com thank you for your comments! I just tried to install ms sql 2005 developer edition on my home computer which has win XP professional, but it says I can only install the client version to connect the database server. It does not allow me to install whole database server. HandersonVA (handersonva@hotmail.com) writes: > I just tried to install ms sql 2005 developer edition on my home > computer which...

Using MS SQL Server 2005 Enterprise Manager with MS SQL Server 2000
Hi Everyone, Most of our MS SQL Servers are still running on SQL 2000, but being I will soon be upgrading my workstation to Vista Business I'd like to install MS SQL 2005 Enterprise Manager to manage them all. When I tried to install MS SQL 2000 Enterprise Manager on Vista, it gave me a message saying it's not compatible, so I'll have to use 2005 I guess. We have LOTS of DTS scripts on our SQL 2000 server, and will 2005 EM work with these okay? Also I want to make sure SQL 2005 Enterprise Manager won't be adding to, changing, or 'upgrading' the DTS scripts or anything on the SQL 2000 servers as we still have folks using SQL 2000 Enterprise Manager. Thanks for any suggestions. I'm always leery when using cross-versions of Microsoft applications because they are often incompatible or they do squirly things that often break stuff. Thanks -- Alex Alex (samalex@gmail.com) writes: > We have LOTS of DTS scripts on our SQL 2000 server, and will 2005 EM > work with these okay? Also I want to make sure SQL 2005 Enterprise > Manager won't be adding to, changing, or 'upgrading' the DTS scripts or > anything on the SQL 2000 servers as we still have folks using SQL 2000 > Enterprise Manager. > > Thanks for any suggestions. I'm always leery when using cross-versions > of Microsoft applications because they are often incompatible or they > do squirly things that often break stuff. There isn't any Enterpr...

export sqlserver database to ms-access by sql script
Hi Is there anyway to export a sqlserver database to ms-access through a sql scipt only without using the sql enterprise manager. -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200601/1 ...

MS SQL 2005 Express Edition
Hello... I'm new to MS SQL, so please be nice... LOLOL I decided to go from Access 2003 with the MS SQL Express Edition (I really don't need all the features of the full version, if so, I can buy it in the future). MS Access as the Frond End and SQL as the Back End. Right now is installed on a Windows 2003 Server and ready to go. So my question is, It's possible to also install SQL Express on my laptop, create and/or test the databases, when ready transfer the Databases to the server? Something like replication? I would love to do all my programing at home, when I'm more relax, then go to work the next day and "replicate" the changes. If this is possible, can you guys point me in the right direction? Any suggestions? I'll really appreciate any help.. Thanks! On Wed, 19 Dec 2007 18:19:40 -0500, Fenix Bird wrote: What I do is to turn on "generate script" (there is a toolbar button for it) and with each change I save the change script. I give them a name starting with a sequential number. Then at work I run the scripts one at a time to update the work database. -Tom. >Hello... > >I'm new to MS SQL, so please be nice... LOLOL > >I decided to go from Access 2003 with the MS SQL Express Edition (I >really don't need all the features of the full version, if so, I can >buy it in the future). MS Access as the Frond End and SQL as the Back >End. > >Right now is installed on a Windows 2003 Serve...

Script, Save, Export SQL 2005 Database Diagrams
I've used the code from the post [Script, Save, Export SQL Database Diagrams] for a while now... but recently upgraded to SQL Server 2005. I've written a new script for SQL Server 2005, which can be found at http://www.codeproject.com/useritems/ScriptDiagram2005.asp if anyone is looking to script out database diagrams... Thanks to the original poster - Clay Beatty - for his effort. URL: [Script, Save, Export SQL Database Diagrams] http://groups.google.com.au/group/comp.databases.ms-sqlserver/browse_frm/thread/ca9a9229d06a56f9/37802441d6466ca2?tvc=1&q=Script%2C+Save%2C+Export+SQL+Database+Diagrams#37802441d6466ca2 ...

US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45337857704)
US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45337857704) =================================================================================== Position: Developer Reference: SMC01919 Location: Detroit MI Duration: 4M Skills: Required Skills MS SQL, MS Reporting Services SQL 2000 Scope: Project Title * FIS data reporting Project Description * We are looking for a strong developer with solid experience with Microsoft SQL developement. MUST have experience with Microsof...

US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45340257612)
US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45340257612) =================================================================================== Position: Developer Reference: SMC01919 Location: Detroit MI Duration: 4M Skills: Required Skills MS SQL, MS Reporting Services SQL 2000 Scope: Project Title * FIS data reporting Project Description * We are looking for a strong developer with solid experience with Microsoft SQL developement. MUST have experience with Microsof...

US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45337850041)
US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45337850041) =================================================================================== Position: Developer Reference: SMC01919 Location: Detroit MI Duration: 4M Skills: Required Skills MS SQL, MS Reporting Services SQL 2000 Scope: Project Title * FIS data reporting Project Description * We are looking for a strong developer with solid experience with Microsoft SQL developement. MUST have experience with Microsof...

US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45339632450)
US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45339632450) =================================================================================== Position: Developer Reference: SMC01919 Location: Detroit MI Duration: 4M Skills: Required Skills MS SQL, MS Reporting Services SQL 2000 Scope: Project Title * FIS data reporting Project Description * We are looking for a strong developer with solid experience with Microsoft SQL developement. MUST have experience with Microsof...

US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45338757608)
US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45338757608) =================================================================================== Position: Developer Reference: SMC01919 Location: Detroit MI Duration: 4M Skills: Required Skills MS SQL, MS Reporting Services SQL 2000 Scope: Project Title * FIS data reporting Project Description * We are looking for a strong developer with solid experience with Microsoft SQL developement. MUST have experience with Microsof...

US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45338414403)
US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45338414403) =================================================================================== Position: Developer Reference: SMC01919 Location: Detroit MI Duration: 4M Skills: Required Skills MS SQL, MS Reporting Services SQL 2000 Scope: Project Title * FIS data reporting Project Description * We are looking for a strong developer with solid experience with Microsoft SQL developement. MUST have experience with Microsof...

US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45340232408)
US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45340232408) =================================================================================== Position: Developer Reference: SMC01919 Location: Detroit MI Duration: 4M Skills: Required Skills MS SQL, MS Reporting Services SQL 2000 Scope: Project Title * FIS data reporting Project Description * We are looking for a strong developer with solid experience with Microsoft SQL developement. MUST have experience with Microsof...

US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45339057601)
US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45339057601) =================================================================================== Position: Developer Reference: SMC01919 Location: Detroit MI Duration: 4M Skills: Required Skills MS SQL, MS Reporting Services SQL 2000 Scope: Project Title * FIS data reporting Project Description * We are looking for a strong developer with solid experience with Microsoft SQL developement. MUST have experience with Microsof...

US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45339614408)
US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45339614408) =================================================================================== Position: Developer Reference: SMC01919 Location: Detroit MI Duration: 4M Skills: Required Skills MS SQL, MS Reporting Services SQL 2000 Scope: Project Title * FIS data reporting Project Description * We are looking for a strong developer with solid experience with Microsoft SQL developement. MUST have experience with Microsof...

US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45339957604)
US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45339957604) =================================================================================== Position: Developer Reference: SMC01919 Location: Detroit MI Duration: 4M Skills: Required Skills MS SQL, MS Reporting Services SQL 2000 Scope: Project Title * FIS data reporting Project Description * We are looking for a strong developer with solid experience with Microsoft SQL developement. MUST have experience with Microsof...

US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45338457610)
US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45338457610) =================================================================================== Position: Developer Reference: SMC01919 Location: Detroit MI Duration: 4M Skills: Required Skills MS SQL, MS Reporting Services SQL 2000 Scope: Project Title * FIS data reporting Project Description * We are looking for a strong developer with solid experience with Microsoft SQL developement. MUST have experience with Microsoft Reporting Services. This is a add on to MS SQL2000. The selected candidate will be creating reports using this tool. Data will be extracted from Plant floor systems. Familarity with manufacturing/plant floor systems would be a plus. Please send your current resume in confidence to staffing@eurosoft-inc.com ..45338457610. ...

US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45339032408)
US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45339032408) =================================================================================== Position: Developer Reference: SMC01919 Location: Detroit MI Duration: 4M Skills: Required Skills MS SQL, MS Reporting Services SQL 2000 Scope: Project Title * FIS data reporting Project Description * We are looking for a strong developer with solid experience with Microsoft SQL developement. MUST have experience with Microsof...

US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45338732408)
US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45338732408) =================================================================================== Position: Developer Reference: SMC01919 Location: Detroit MI Duration: 4M Skills: Required Skills MS SQL, MS Reporting Services SQL 2000 Scope: Project Title * FIS data reporting Project Description * We are looking for a strong developer with solid experience with Microsoft SQL developement. MUST have experience with Microsof...

US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45340214407)
US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45340214407) =================================================================================== Position: Developer Reference: SMC01919 Location: Detroit MI Duration: 4M Skills: Required Skills MS SQL, MS Reporting Services SQL 2000 Scope: Project Title * FIS data reporting Project Description * We are looking for a strong developer with solid experience with Microsoft SQL developement. MUST have experience with Microsof...

US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45338132411)
US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45338132411) =================================================================================== Position: Developer Reference: SMC01919 Location: Detroit MI Duration: 4M Skills: Required Skills MS SQL, MS Reporting Services SQL 2000 Scope: Project Title * FIS data reporting Project Description * We are looking for a strong developer with solid experience with Microsoft SQL developement. MUST have experience with Microsof...

US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45337850041)
US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45337850041) =================================================================================== Position: Developer Reference: SMC01919 Location: Detroit MI Duration: 4M Skills: Required Skills MS SQL, MS Reporting Services SQL 2000 Scope: Project Title * FIS data reporting Project Description * We are looking for a strong developer with solid experience with Microsoft SQL developement. MUST have experience with Microsoft Reporting Services. This is a add on to MS SQL2000. The selected candidate will be creating reports using this tool. Data will be extracted from Plant floor systems. Familarity with manufacturing/plant floor systems would be a plus. Please send your current resume in confidence to staffing@eurosoft-inc.com ..45337850041. ...

US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45338414403)
US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45338414403) =================================================================================== Position: Developer Reference: SMC01919 Location: Detroit MI Duration: 4M Skills: Required Skills MS SQL, MS Reporting Services SQL 2000 Scope: Project Title * FIS data reporting Project Description * We are looking for a strong developer with solid experience with Microsoft SQL developement. MUST have experience with Microsof...

US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45338432406)
US-MI-Detroit: Developer, MS SQL, MS Reporting Services, SQL 2000; 4M (45338432406) =================================================================================== Position: Developer Reference: SMC01919 Location: Detroit MI Duration: 4M Skills: Required Skills MS SQL, MS Reporting Services SQL 2000 Scope: Project Title * FIS data reporting Project Description * We are looking for a strong developer with solid experience with Microsoft SQL developement. MUST have experience with Microsof...

Web resources about - SQL 2005 Developers Diagram question - comp.databases.ms-sqlserver

Dungeons and developers
Have you ever wanted to learn web development or just refine your webdev skills? Dungeons and Developers gives your quest for knowledge a role ...

Video game developer - Wikipedia, the free encyclopedia
A video game developer is a software developer (a business or an individual) that creates video games . A developer may specialize in a certain ...

South Perth residents win high-rise fight but developer's next plan even bigger
South Perth residents have won a Supreme Court challenge against the approval for a 29-storey high-rise - but the result is the developer proposing ...

More developers now use OS X than Linux, says ‘most comprehensive survey ever conducted’
Stack Overflow reports that more developers now use OS X than Linux as their primary OS, and that if the trend continues, fewer than half of ...

Virtual Reality No Game Yet Amid Developers' Wariness
Virtual reality enthusiasts often say gaming will be the first big use for those odd-looking headsets that project you into imaginary worlds. ...

OS X and Linux threaten Windows' dominance in developer market
... a whole, but the two platforms are actually extremely popular with a certain crowd. According to a StackOverflow survey, 26.2 percent of developers ...

FTC warns app developers away from audio monitoring software
The U.S. Federal Trade Commission has sent warning letters to 12 smartphone app developers for allegedly compromising users' privacy by packaging ...

App Developers Warned: You Need To Tell Consumers First If You’re Going To Eavesdrop
... telling you first, it could be in hot water with the Federal Trade Commission. The FTC today issued warnings to a dozen Android app developers ...

BlackBerry reiterates their strong commitment to the BlackBerry developer community
... they would be ending support for BlackBerry 10 and BlackBerry OS devices at the end of 2016, Lou Gazzola, head of App Ecosystem and the Developer ...

Prospective web developers, it’s time to tame Python
Python’s name isn’t accidental — it’s one of the most flexible and wide-reaching web development languages around. It can seem intimidating to ...

Resources last updated: 3/22/2016 5:01:50 AM