Cannot Create Diagrams In Upgraded SQL Server 2000 Database
Jul 3, 2006
Dear all,
I am trying to save a newly created diagram in SQL Server 2005 SP1.
The error message is:
----Beginning of pasted error message---
===================================
Cannot insert the value NULL into column 'diagram_id', table 'adt_db.dbo.sysdiagrams'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The 'sp_creatediagram' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. (.Net SqlClient Data Provider)
------------------------------
Program Location:
at Microsoft.VisualStudio.DataTools.Interop.IDTDocTool.Save(Object dsRef, String path, Boolean okToOverwrite)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.DatabaseDesignerNode.Save(VSSAVEFLAGS dwSave, String strSilentSaveAsName, IVsUIShell pIVsUIShell, IntPtr punkDocDataIntPtr, String& strMkDocumentNew, Int32& pfCanceled)
----End of pasted error message---
The database I use has been upgraded from SQL Server 2000.
I am running in SQL Server 2000 Compatibility Mode (80) but changing the compatibility mode to SQL Server 2050 (90) does not make any difference with regards to this error.
View 5 Replies
ADVERTISEMENT
Dec 28, 2006
Hi:
I installed SQL Server 2005 onto Vista RTM.
When launched SQL Server Mangement Studio -> Databases -> choose a database and expand.
Right click on top of "Database Diagrams" node, only options I've got are:
1. Working with SQL Server 2000 Diagram
2. Refresh.
Wondering did I missing something on my system in order to make database diagrams to work?
Thanks
Tommy
View 5 Replies
View Related
Apr 14, 2006
Hello, I'm using C# express with SQL express.
I can create a database, create tables and I can even delete the database but I cannot create database digrams. I get an error that says I don't have a valid dbo user or permissions to impersonate. It asks me if I would like to impersonate but it just fails. Any Ideas? Thanks
View 1 Replies
View Related
Jan 21, 2006
Our MS SQL (SQL Server 2000) DBA has database privileges locked downpretty tightly. We end users/developers do not have administratorprivileges for most databases. That arrangement has worked out OK forthe most part. However, it's a bit aggravating that we can't evencreate our own database diagrams. When we attempt to do so (inEnterprise Manager), we get a dialog that says "You do not havesufficient privilege to create a new database diagram."Our DBA is so busy that it's difficult to get them to create ones forus. And even when they do, it seems that we can't even view it online-- we rely on the DBA to give us printed copies or screenshots for ourdocumentation. How ridiculous is that? We'd also like to be able tomanipulate the diagrams online so that we can more easily study ourtable structures, indexes, foreign key constraints, etc. In fact,there doesn't even seem to be any other way to easily view currentforeign key constraints.I realize that this might have to do with the diagramming tool havingthe ability to actually manipulate the database in ways we aren'tsupposed to do (e.g., like creating new tables). However, isn't therea "read-only" version of this tool that will give us what I'm lookingfor? Short of that, are there any other free or cheap tools that willprovide this? Thanks!(Please forgive my ignorance if this has been hashed out before.However, I did search news groups and the web before posting, figuringthis had been covered before, but I didn't find anything thatspecifically addressed this issue.)
View 3 Replies
View Related
Dec 5, 2005
Server Error in '/' Application.
Database 'C:INETPUBDEMO.TRUTHSTONE.COMAPP_DATAASPNETDB.MDF' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.Cannot open user default database. Login failed.Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
Hi,
Strange one. I have copied my working web-site to the production server and get this message.
Tried copying new set of database files and reset the server to ensure no applications could be accessing the database files. Still get the same error.
Works fine on my Visual Studio VWD Express version.
Mitch
PS I am not trying to upgrade the database, just use it!
View 1 Replies
View Related
Oct 24, 2006
Hi,I currently (for a hobby project) am unable to use SQL Server 2005, and rather am stuck with 2000. Since the way diagrams are handled changed, the tool for 2005 doesn't allow for the creation of diagrams when using it for 2000 (work sweet for everything else though!).I do not have access to a developer version of SQL Server 2000's tools, and thus no Enterprise Manager, leading me to my question: Are there any free utilities to replace this functionality? I don't have MS Access or Visio or anything like that unfortunately :(
View 3 Replies
View Related
May 9, 2008
Hi all
We recently upgraded from sql 2000 to sql server 2005. Our system was developed using Microsoft visual Basic.
Since we upgraded to sql server 2005 our system has been very slow. I suspect that it was because of the new sql 2005 installation that i made.
Does anyone know how to solve this problem for me to be able to increase the perfomance speeed of our system again.
It has been stressing me for a while now.
Pliz help
Thanks!
View 19 Replies
View Related
Aug 2, 2006
How do SQL 2000 service packs play a role in upgrading? That is, can SQL 2000 Standard with no Service Packs(SP) be upgraded to SQL 2005 Standard, or does SQL 2000 Standard have to have a certain service pack??
View 1 Replies
View Related
Feb 7, 2006
hi
please explain how to create new database in Sql server 2000.what i do for start the starting step?:confused:
View 2 Replies
View Related
Mar 24, 2006
This question has been asked several times on this forum, but none of the answers I've seen have worked for me. I just upgraded from SQL Server 2000.
The error I'm getting is:
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.
This is a new database I created in SQL Server management studio. It's set to 90 compatibility level. I've tried the "alter authorization" command, which works, but it has no effect (the error is still returned).
The odd part is that if I go to Server Properties->Permissions, select the Login that owns this database, and click "Effective Permissions", I get the error:
Could not obtain information about Windows NT group/user '<username>', error code 0x6e. (Microsoft SQL Server, Error: 15404)
But I know for certain that this account is valid and that my machine can reach the domain controller: 1) I received no error when I added this Login to the server and 2) I'm logged into SQL Server Management Studio using the same login.
If I switch to the "sa" user, it works. But I'd really rather find out what I can't use Windows authentication.
View 7 Replies
View Related
Feb 10, 2006
I am having the same problem as above. Are there step-by-step instructions available to correct this problem. I have tried some of the solutions listed above and I still can't access the database diagram.
Help
View 1 Replies
View Related
Dec 7, 2005
I have installed Visual Basic 2005 Express and SQL server 2005 Express.
View 20 Replies
View Related
May 23, 2008
Hi all. I'm mapping FKs in a DataWarehouse and I'm wondering if there is a way to change the schema of a database diagram from dbo.
Thanks,
Charlie
View 2 Replies
View Related
May 26, 2004
Hi All,
Currently i am defining a simple relationship between
Customers->Orders->Order Details through the Database Diagrams feature in
the SQL 2K. Using the Server Explorer, i can see the Database Diagrams, but
when i try to "drop" the Database Diagrams into the page, it gives the error
message.
I would like to know the procedures to retrieve the database relationships
from Database Diagrams and manipulate them through ADO.NET
I prefer to "convert" already defined relationship using SQL Server Database
Diagrams into XSD file or probably there is another method to "read" those
relationship and manipulate them.
Thank you very much for all your help
View 3 Replies
View Related
Jun 23, 2007
I have a database called 'DB1' in SQL Server 2000. I want to create the same database in SQL Server 2005 Express including the original data in tables.
How would I do that? I cannot find any option to do this upgrade in SQL Server Management Studio.
View 4 Replies
View Related
Jan 9, 2008
Hello:
I have an old database created in SQL Server 2000,
now I can open, access it in SQL Server 2005 Management Studio, but I can't create Data Diagrams.
Please advise on how to make it work....
Thank you
View 2 Replies
View Related
Apr 7, 2006
I found that when I install MSDE, then I can create/edit database objects for MSDE database in Visual Studio 2003 Server Explorer, but when I try to create/edit database objects under the default database created by the SQL Server 2000 installation, I cannot do these tasks as no option for these tasks appear when I right-click on the database object in Server Explorer. Anyone knows why this is happening?
View 3 Replies
View Related
Jan 19, 2007
Most of our sql servers ar still sql 2000. Our programmers created many sql 2000 database diagrams using EM. But they can not access them under sql 2005. (They now have only sql 2005 tools installed on their boxes.)
Question: can we reinstall the sql 2000 client tools on their boxes without affecting the current sql 2005 install on their boxes?
Question: is there any workaround negating the need to ihstall the sql 2000 client?
TIA,
barkingdog
View 1 Replies
View Related
Mar 14, 2007
Hi
While a database upgrade schema changes were being made the Mirror became disconnected will this recover itself when it reconnects or will it be the case that we will have to copy the db files to the Mirror and set it up from scratch.
It was set up as a synchronise mirror
View 2 Replies
View Related
Dec 22, 2006
In trying to upgrade my sql express install from express to developer edition, I ended up having to delete all things express from my computer and do a clean install of developer edition (as i installed developer edition initially over sql express but this didnt seem to work; express edition still appeared in add remove programs etc). Anyway so i blew away the install and have a clean install of developer edition. Now when I create a new website in Visual Studio 2005 and try to add a database to the project, it gives me an error stating that i need to have sql server express 2005 installed to function properly... Do i need to have express AND developer edition of sql installed to do this? I would think developer edition of sql would enable me this functionality...http://img277.imageshack.us/img277/4228/sqlerrorie2.jpgThanks!It is also worth noting that I get the dreaded remote connection error when trying to connect to a db that I used to be able to connect to when I was using sql express (the aspnetdb database that is created when you user their membership stuff)"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) "However, I did the following successfully:1. create a database using the sql management studio2. added a table and some data to it3. threw a dataset into the website4. added a gridview to a page in the website, pulling data from the dataset5. and the website runs successfully populating the page with data...fyi: My sql services: http://img158.imageshack.us/img158/2020/sqlserviceshj6.jpg
View 15 Replies
View Related
Mar 9, 1999
Is there a way to use an Oracle linked server to create a database diagram? Or do I have to bring the whole Oracle db into SQL7 and then create the diagram?
Peter Cwik
View 1 Replies
View Related
Oct 11, 2001
Is there a way to allow a non-dbo to look at another's database diagram?
View 3 Replies
View Related
Apr 5, 2004
Do you need to be a member of the dbo role or an sa on a particular sql server to create a database diagram? I just want to confirm this is the case.
Any assistance will be helpful.
Maria
View 7 Replies
View Related
Nov 29, 2007
In our organization, we are using SQL Server 2005 Management studio as the client interface to access all our enterprise Databases.Most of the databases are built on SQL 2005 DB Server.
However, We have one of the Database built on SQL Server 2000, which also has Database diagrams in it. Though We are able to view all the DB objects through SQL 2005 managment studio interface, but unable to view the diagrams.
I understand that, the binary data of the diagrams are stored in "dtproperties" table on SQL 2000 but in SQL 2005, it is stored in "sysobjects"(not sure) table and both are entirely different.
Following are my questions.
1.Since the DB is still on SQL 2000,How can we view the diagram objects thru the SQL 2005 Enterprise manager.
2.For the migration process of SQL 2000 to SQL 2005, How can i migrate the database diagrams.
Appreciate the responses.
View 2 Replies
View Related
Jan 11, 2008
Hi All
I am using SQL server 2000 and I would like to create Database diagrams but It doesn't give me any option to crate one. It only shows "Working with SQL Server 2000 diagrams" and "Refresh" with no "create new diagram" and in other servers it but its only in my desktop that doesn't and I have full access
View 3 Replies
View Related
Apr 26, 2006
Hello all,
I upsized an access backend to sql 2005. In the process, the relationships were lost. When I go to the database in Sql, right click on database diagrams, all I get is refresh and a link to go to learn about database diagrams. How can I recreate the diagrams?
Thanks
View 1 Replies
View Related
Apr 23, 2007
I am trying to follow this walkthrough<br><br>http://msdn2.microsoft.com/en-us/library/ms233763(VS.80).aspx<br>And getting nowhere as it says I need to set up database diagrams which I cannot due to not being in db_owner role, or not being valid db user etc etc.I cannot find out how to set this up for the database I created so far in t his tutorial.I have searched and searched and got nowhere.I then went into SSMSE by chance and found a load of roles but none named db_owner. I then tried to add my database file but SSMSE wont let me drill down into the required folderI weep!!!!Please can anyone help?
View 2 Replies
View Related
Nov 2, 2007
I just did a 2005 "In-Place" upgrade to a 2000 server yesterday, and now we're getting intermittant time-out errors trying to connect via SQL Server Management Studio. Sometimes we connect instantly, then if I try again 10 minutes later, it might time-out. No problems with our other 4 SQL 2005 servers (2 were just upgraded, 2 are native 2005). No timeouts so far when logged on to the server directly, just when logging in from our desks.
It's set to TCPIP only (removed named pipes), but can't think what else might be the problem. Any ideas ?
One little thing I just noticed while comparing to another server: In the console, a "good" server has the little green arrow on the server & SQL Agent icons, while the "problem" server is connected, but there is no green arrow. If I log on the server directly and open SQL, I get the green arrows. Is that trying to tell me something about the connection ??
View 13 Replies
View Related
May 10, 2001
Hi,
I hope i'm in the right forum. Is there a way to create a DB diagram schema via ASP/HTML and publish it on-line - keeping it up-to-date?
I want to at least output a diagram schema to HTML format? Any ideas. TIA!
View 2 Replies
View Related
Oct 17, 2005
Hi all,
I am trying to make DATABASE DIAGRAMs....I have restored a database called Tel from a backup file...n in that i have all the tables and procedures..now whenever i m clicking on its DATABASE DIAGRAMS it gives me the error as:
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.
------------------------------
so,what should i do??any suggestion will be helpful for me...thnks in advance...
regards..
View 1 Replies
View Related
Apr 18, 2008
Hi,
I remember I asked the similar question before.But I have not solve this.
I am working with SQL Server 2005. I just make a copy of the production database.
I use "tasks -> Generate Script" to copy the table structure and use "tasks -> import Data" to copy Data. But I can not copy the database diagrams,I need to keep the primary keys - foreign keys relations.
Please let me know how to copy database diagrams.I try many ways but I can not figure it out.
Thanks for your help
Mark
View 1 Replies
View Related
Apr 17, 2007
When I try to Create a Database Diagram it sends me an Error message like this:
Server Name: TICSQLEXPRESS
Error Number: 207
Severity: 16
State: 1
Procedure: sp_upgraddiagrams
Line Number: 55
Invalid column name 'uvalue'.
Invalid column name 'uvalue'.
Could not find stored procedure 'dbo.sp_upgraddiagrams'.
Object is invalid. Extended properties are not permitted on 'dbo.sysdiagrams', or the object does not exist.
Object is invalid. Extended properties are not permitted on 'dbo.sp_upgraddiagrams', or the object does not exist. (.Net SqlClient Data Provider)
How can I find that Stored Procedure 'dbo.sp_upgraddiagrams'?
Why doesn't it work OK?
Thank you!
View 3 Replies
View Related
