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 14578 articles. 3 followers. janinepelletier (108) is leader. Post Follow

1 Replies
163 Views

Similar Articles

[PageSpeed] 23
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:

Top 10 subjects comp.unix.questions #95
Top 10 subjects for the 7 day period ending Monday May 16, 2005. posts kbytes subject 13 30.5 Old Unix Install Problem 8 15.0 can't open display : (on Linux rlogin to SGI) 7 11.6 Script question 4 8.7 Pass-thru printing on DG/UX 4 6.0 /etc/crontab vs /var/spool/cron/root 4 5.9 Duplicate lines with vi macros (or sed/awk ?) How ? 4 5.7 password encription for a data file 3 5.1 How can you insert [CTRL-v] in sed script 3 3.6 symbolic link (ln -s) removal 2 6.4 Can't Use "rsh ... ps ..." To W...

Question: If Microsoft is so good and Apple so bad...
....why is Windows market share shrinking while Mac OS X's is growing. :-) -- "The iPhone doesn't have... ....well, since Edwin seems to have finally crawled away for good, I guess I'll let him off the hook On Thursday, February 21, 2013 9:16:42 PM UTC-5, Alan Baker wrote: > ...why is Windows market share shrinking while Mac OS X's is growing. :-) -- "The iPhone doesn't have... ...well, since Edwin seems to have finally crawled away for good, I guess I'll let him off the hook Because Windows 8 sucks. Even worse than Mac. And PCs don'...

Sourcesafe and Dream Weaver Question
I'm hoping there is someone out there in CM land that is using these two products together. If so, I would appreciate some insight into how well they work together, problems and pitfalls, etc. TIA jon ...

US-TX-Austin: SQL Database Dev., SQL,SQL Analyzer and Profiler; (45349657602)
US-TX-Austin: SQL Database Dev., SQL,SQL Analyzer and Profiler; (45349657602) ============================================================================= Position: SQL Database Dev. Reference: ZYD00030 Location: Austin TX Duration: Skills: 3+ years experience as a Database Developer with significant SQL 2000 experience Must have the ability to develop, debug, test and troubleshoot queries,macros, and modules Experience and understanding of database design Proficient with SQL Query Analyzer, ...

US-VA: Blacksburg-MySQL Developer/DBA
************************************************************** JobCircle.com is the largest regional job board in the Mid-Atlantic region, with tens of thousands of job offerings in PA, NJ, DE, MD, NY, and Washington D.C. To learn more, visit http://www.jobcircle.com?source=ng ************************************************************** Job Title: MySQL Developer/DBA Job Location: VA: Blacksburg Pay Rate: Open Job Length: full time Start Date: 2009-02-21 Company Name: Allegis Group Contact: Recruiter Phone: email only please Fax: ...

US-TX-Austin: Oracle/ SQL DBA Developer, SQL DBA, Oracle DBA, Oracle Developer; (45302757603)
US-TX-Austin: Oracle/ SQL DBA Developer, SQL DBA, Oracle DBA, Oracle Developer; (45302757603) ============================================================================================= A strong data base developer / database admin needed for contract to hire opportunity in Austin Texas. Significant Oracle experience would be a must as well as strong MS SQL Server Submit responses to gcameron@eurosoft-inc.com ..45302757603. ...

enumeration question
Hi How can I get back to the first element after finishing the while loop with enum.hasMoreElements()? Thanks -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 a schreef: | Hi | | How can I get back to the first element after finishing the while loop with | enum.hasMoreElements()? You can’t. You can, however, ask for a new Enumerator. However, note that Enumerator is obsolete, and has been replaced by Iterator. Please use that in your own code, as far as possible. H. - -- Hendrik Maryns http://tcl.sfs.uni-tuebingen.de/~hendrik/ ================== http://aouw.org Ask smart questions, get...

US-TX-Austin: Oracle/ SQL DBA Developer, SQL DBA, Oracle DBA, Oracle Developer; (45301758079)
US-TX-Austin: Oracle/ SQL DBA Developer, SQL DBA, Oracle DBA, Oracle Developer; (45301758079) ============================================================================================= A strong data base developer / database admin needed for contract to hire opportunity in Austin Texas. Significant Oracle experience would be a must as well as strong MS SQL Server Submit responses to jgoolsby@eurosoft-inc.com ..45301758079. ...

Question: Consistency of backlight in LCD monitor
Greetings, all: I just bought a Hyundai L90D+. I'm pleased with it overall (no bad pixels, good refresh, vibrant color), but have one question: The backlighting is not 100% uniform. I've read the blurb about this display on Tom's Hardware, and recognize that I can't expect perfect uniformity, especially around the edges. In games, it's completely un-noticeable. The only situation I can see any difference is when I have a white Windows screen, and even then the difference is so subtle I have to really stare at it to make sure I'm not fooling myself. But the truth is, t...

Re: SQL Delete with OLE DB
Lionel: Do the tables have any referential integrity constraints? S -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Teed, Lionel Sent: Wednesday, September 23, 2009 11:46 AM To: SAS-L@LISTSERV.UGA.EDU Subject: SQL Delete with OLE DB Fellow SAS-Listers. I have just upgraded to 9.2 and decided to use that occasion as an opportunity to update some of my regular monthly programs. One of the main programs reads some data from month end data files, massages the data a bit, and then exports it out to an MS Access database for report generation. In 9...

US-PA: Philadelphia-Application Developer #3
************************************************************** JobCircle.com is a regional job board serving all industries and occupations in the PA, NJ, DE, NY, MD, and DC areas. We offer a regional job board, online learning, and regional job fair events for jobseekers who live in our areas of focus. To Learn More: Job Board: http://www.JobCircle.com?source=ng eLearning: http://www.JobCircle.com/courseware?source=ng Job Fairs: http://JobCircleJobFairs.com?source=ng ************************************************************** Job Title: Applicat...

sql server 2005 express problem wtih {7twud62389sdksdk} the like
I'm installing sql server 2005 express distribution version on an Asus EEE PC with XP home OS, and doing installing and uninstalling several times, and each time, it generated some abitrariy directory like the subject one, which clustered my hard drive, but they not removable, the finish.rtf is undeletable, how come? Any way to remove them all? The odd thing is, installing it to a laptop with the same OS does not create such unremovable directory and files. Thanks. DL (tatata9999@gmail.com) writes: > I'm installing sql server 2005 express distribution version on an Asus > EE...

US-PA: Pittsburgh-JAVA Application Developer
************************************************************** JobCircle.com is the largest regional job board in the Mid-Atlantic region, with tens of thousands of job offerings in PA, NJ, DE, MD, NY, and Washington D.C. To learn more, visit http://www.jobcircle.com?source=ng ************************************************************** Job Title: JAVA Application Developer Job Location: PA: Pittsburgh Pay Rate: market rate Job Length: 7-12 months (contract) Start Date: 0000-00-00 Company Name: RMS Computer Corporation Contact: Nicole Zazzara Phone: 212.8...

sql integrity in ms-sql
(I've also posted this message in TURF: http://www.webinacan.com/turf/viewtopic.php?t=68) Hello, I'm kinda new to MS-SQL, maybe you could give me some directions. Environmet: Uniface 7.2.06, MS-SQL 2000 When generating sql inegrity scripts for MSS I've noticed Uniface does not use the integrity names you have defined in Application Model (when generating to ORA, it does). It uses names like ATABLE_TR_U for the update integrity trigger and ATABLE_TR_D for delete. Problem is: those names duplicate when you have an inter-model relationship. For example: tables A...

question about reading in a loop
Hi, I have a folder which contains 100 Excel files with names profile1-profile100, I wanna use a variable to read in each file at a time and plot it. I tried to do this in a loop like: for j = 1:100 eval(sprintf('A = xlsread(''profile%i.xls'')',j)); figure; plot(A); end But there are always some error with this. Could anyone help me fixing this problem? Many thanks. Jane jane wrote: > > > Hi, > I have a folder which contains 100 Excel files with names > profile1-profile100, I wanna use a variable to read in each file at > a > time and pl...

scalapack (pdgemr2d) question
Hi, This is not a direct Fortran question, but I know a number of people on this newsgroup have experience with scalapack. If there is a better newsgroup to post this to, please let me know. I'm trying to distribute a matrix using the routine PDGEMR2D and am having trouble getting it to work. I have found very little information regarding this routine on the web. The sample program below hangs at the call PDGEMR2D. In the sample program, I am just sending one sub-matrix as an initial test. Does anyone have an idea what the problem is? Is there a better way to do this than us...

SQL Server DBI insert silently fails
Hi all I am having problems when trying to insert records using dbi-0.1.0 on Windows XP. I am using the ADO driver to connect to SQL Server, like so: connectString = "DBI:ADO:provider=SQLOLEDB.1;Data Source=10.0.0.1;User id=xxxx; password=xxxx;Initial Catalog=DevDB" I get rows == nil when I run this: qry = "insert into G2.dbo.Device (IPadress, SerialNumber, VehicleID, " + "SerialNumberB, Tag1, Tag2, FwVersion, HwVersion) values (?, ?, ?, ?, ?, ?, ?, ?)" rows = @database.do(qry, device[:ip], device[:serial], device[:serial], device[:serial], 0, 0, 0...

US-NY: NEW YORK-Oracle e-Business Suite Developer #2
************************************************************** JobCircle.com is the largest regional job board in the Mid-Atlantic region, with tens of thousands of job offerings in PA, NJ, DE, MD, NY, and Washington D.C. To learn more, visit http://www.jobcircle.com?source=ng ************************************************************** Job Title: Oracle e-Business Suite Developer Job Location: NY: NEW YORK Pay Rate: Open Job Length: full time Start Date: 2009-02-21 Company Name: Robert Half International Contact: HR Phone: email only pleas...

a question about my sas output?
Hi, I have a regression output showed as below,Base on the info collected from this disscussion group, there are multicollinearity among the X variables(correct ?) Could you let me know what would you think my output about the TOL and VIF value, is there any unaccepatble value within TOL values or VIF values? any suggestions or interperation would be really appreciate, should I use the proc pls to do the model fitting and prediction ?Would you please help me with more explaination of how could I use Proc PLS procedure? Do I need train my data first ? Is it really complicated? Please ...

Restoring SQL Views
Hi *ALL, Over the weekend our shop admin restored our training libraries from a tape backup of our production libraries. However, SQL views that had been created are still referencing the production physical files. The restore is done with a RSTOBJ OBJ(*ALL) SAVLIB(PRODLIB) DEV(TAPE) ENDOPT(*REWIND) MBROPT(*ALL) RSTLIB(TRAINLIB). DDS logical files are fine. It appears the job description it was run under only contained the training libraries, not the production libraries. Can anyone out there shed some light on how SQL views are restored? Thanks in advance for any help...... It's easy t...

US-DE: Wilmington-Web Developer #11
************************************************************** JobCircle.com is a regional job board serving all industries and occupations in the PA, NJ, DE, NY, MD, and DC areas. We offer a regional job board, online learning, and regional job fair events for jobseekers who live in our areas of focus. To Learn More: Job Board: http://www.JobCircle.com?source=ng eLearning: http://www.JobCircle.com/courseware?source=ng Job Fairs: http://JobCircleJobFairs.com?source=ng ************************************************************** Job Title: Web Developer Job Locat...

iTechArt Group
iTechArt Group - Custom Software Development and Offshore outsourcing Company http://www.itechart.com/ Offshore custom software development company iTechArt - Web site and Content Management Solutions development, CMS consulting: Ektron, Drupal and DotNetNuke iTechArt Group provides high quality custom software development services and offshore software development. On December 2006, iTechArt Group became an authorized Microsoft Certified Partner. This means that our company has been recognized by Microsoft for our vast expertise and authorized to custom software development; p...

MS SQL Server 2000 and MS JDBC SQL Server driver problems. (Connection timed out, followed by Error establishing socket)
I have downloaded the MS SQL Server 2000 Enterprise Evaluation edition, and the MS SQL 2000 Server JDBC driver. I have installed and configured the MS SQL Server 2000 onto two computers, which reside on the same network. (In fact, these two computers comprise the entire network). The network server (computer name=SUNCDS1), and the lone node (SUNCDS2), each have their own SQL Server 2000 instance. The SQL Server 2000 Enterprise Manager console on SUNCDS1 shows both SQL Server instances, the (local) instance, which is SUNCDS1, and also SUNCDS2. It may be worthwhile to mention t...

US-TX-Austin: SW Applications Eng., C programming,code development,GUI (45351732410)
US-TX-Austin: SW Applications Eng., C programming,code development,GUI (45351732410) ==================================================================================== Position: SW Applications Eng. Reference: ZYD00018 Location: Austin TX Duration: Skills: 5+ years of C programming experience. 3+ years of low-level code development Ability to debug software and hardware issues. GUI development experience. Experience with hardware design is a plus. Scope: Work with design team to capture applica...

Question about frameset & repeat-authentication at "KeepAlive On" .
I have the following setup on my server (Server version: Apache/2.0.52): docroot | | ---dir1 |index.html (frameset that uses up.html & down.html) |up.html |down.html | --- dir2 |index.html the "httpd.conf" file has these restrictions: KeepAlive On ; <Directory "/docroot/dir1"> AllowOverride all Order allow,deny Allow from all AuthType Basic AuthName "dir2-->" ...