Can't Create Database Diagrams
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 Complete Forum Thread with Replies
Related Forum Messages:
Want To Be Able To Create Or View Database Diagrams
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 Replies !
Cannot Create Diagrams In Upgraded SQL Server 2000 Database
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 Replies !
How To Create Database Diagrams In SQL Server Management Studio?
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 Replies !
Not Able To Create New Diagrams
I get a message that says the SQL Server is unable to create a new database diagram that I am saving. The error message says that the operation tried to insert a Null value into the version field of the dtproperties table. I get this message from both Enterprise Manager or from the VS.NET IDE. I would appreciate any information that indicates what is causing this error (I don't think I have had it before), and what I can do to fix it. Thanks for your attention. Al Corwin
View Replies !
Unable To Create Diagrams
Hi, My dba has setup permission such that I can do everything except I am unable to create diagrams in the database. It say I don't have enough permission to do that. Can somebody tell why I am unable to do that? thanks Rozina
View Replies !
Database Diagrams
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 Replies !
Database Diagrams
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 Replies !
Please Help - Database Diagrams
Hi, I have a few users who are in the role 'public' that need to create database diagrams. For some reason, when they try to create one, it gives them the error 'YOU DO NOT HAVE SUFFICENT PERMISSIONS TO CREATE A NEW DATABASE DIAGRAM' I have checked in books online and it says that they are stored in dtproperties table. And you cannot set permissions on database diagrams. Can anyone help please? Thanks, Tag
View Replies !
Database Diagrams
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 Replies !
Database Diagrams !!!!
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 Replies !
Database Diagrams
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 Replies !
DataBase Diagrams
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 Replies !
Protecting EM Database Diagrams
Hidoes anyone know of a way of giving developers read only access to adatabase diagram in Enterprise Manager (SQL Server 2000). The database wassupplied by a third party and we don't want them tinkering with it, butthey do need to be able to create additional tables etc. to extend thefunctionality of the package.TIAChloe Crowder
View Replies !
Database Diagrams Problem....
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 Replies !
Navigate The Database Diagrams
I hope you´d like an opensource I've made called Nautilus. With a web browser you can navigate data and structure. Instead of building diagrams with Enterprise Manager you can make automatic diagrams around a table and then jump to one neighbor table. You can do the same once you locate a record and jump to related records. Nautilus (sqlserver) v1.0.3 Navigate your SQLServer 2000 database http://sourceforge.net/projects/nautilus/ Author: Marcos L. Casamayor WHAT ---- Nautilus is a tool for developers, advanced users and auditors. The main objetive is to navigate information and structure in a SQLServer database.
View Replies !
Database Diagrams - Take Too Long?
I am using Beta 3 and the database diagrams take over an hour to generate for approx 10 tables. The database has been transformed from SQL 6.5. Even opening a saved diagram takes quite long. Is this a feature of the beta or something else? Thanks. Jay Virdee
View Replies !
SQL Database Diagrams Online?
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 Replies !
Database Diagrams Missing
Hi All, I€™ve just installed SQL 2008 Express CTP. Everything seems to be fine except that the folder €œDatabase Diagrams€? is absent in the tree of SQL Server Management Studio. It is the same for newly created databases and databases upgraded from 2005 Express. Any ideas how to get the diagrams back?
View Replies !
Database Diagrams Tool
When I use the sql 2005 "Database Diagrams" tool for the first time I always get the message: "The Database does not have one or more of the support objects required to use database diagramming. Do you wish to create them?" 1. Does anyone know what the " support objects" referred to are? 2. Why SQL doesn't automatically create these support objects for me? (e.g. do they require a lot of hard disk space so they shouldn't routinely be created?) 3. Is there any way to make Sql automatically create them? If you can address any of these points I'd appreciate it. TIA, barkingdog
View Replies !
Error In Database Diagrams
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 Replies !
How To Copy Database Diagrams?
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 Replies !
AdventureWorks Database - Cannot Access Database Diagrams
Hi, When I try to access the database diagrams in AdventureWorks, I get the following message: 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 ------------------------------ Why is this? All advice / help apprecuated. Thanks
View Replies !
Having Trouble Creating Database Diagrams
tried to add a third and fourth table to an exsiting relationship diagram in VS05 server explorer, when i click save i get an error "the operation could not be completed" i am able to create new diagrams but it seems every time i click save, and close the diagram the reopen it and add new tables then click save i get the same error message, i dont even try and create the actual relationship but just add a third table and boom the problem occurs thanks in advance
View Replies !
SQL Server 2005 Database Diagrams
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 Replies !
Creating Self Joins With Database Diagrams ??
Hello I'm new to VWD 2008 Express and MSSQL 2005 Express development (not to programming in genral), and I have this problem with creating a self join using Database Diagram in VWD2008 Express. In SQL 2005 Express (through VWD) it's not possible to add the table to the diagram twice and its not possible to give the table an alias either. Is it a limitation in the SQL Express or am I doing something wrong ? Regards
View Replies !
Diagrams Do Not Work On XP In The Database Imported From Vista
I have SQL Server 2005 Developer edition. I have restored the database from Vista on my XP. Now when I try to access diagrams I am getiing this error: "Table(s) were removed from the diagram sql 2005 because privilages were removed to these table(s) or tables were dropped ..." I login as RAF001RAFAL user and I have esured that thi user has full rights tp the database. I setup this user as database user in properties/files window.... However thsi user is not visible under users in the database. I have a feeling something is wrong with the security.
View Replies !
Can't Open Northwind's Database Diagrams Node In SQL MSE
Hi.I'm very new to this so I apologise in advance for asking the blindibly obvious. I have installed SQL Express and SQL Server Management Studio Express and I have downloaded and attached the Northwind sample database. I can see and edit the data in the tables but when I try to open the Database Diagram node I get the following message: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.I have no idea what a valid logon would be. Can somebody help? Thanks
View Replies !
Script, Save, Export SQL Database Diagrams
When you create database diagrams in Enterprise Manager, the detailsfor constructing those diagrams is saved into the dtproperties table.This table includes an image field which contains most of the relevantinfomation, in a binary format.SQL Enterprise manager offers no way to script out those diagrams, soI have created two Transact SQL components, one User Function and oneUser Procedure, which together provide a means to script out thecontents of the dtproperties table, including all of the binary basedimage data, into a self documenting, easy to read script. This scriptcan be stowed away safely, perhaps within your versioning software,and it can subsequently be recalled and executed to reconstruct allthe original diagrams.The script is intelligent enough not to overwrite existing diagrams,although it does allow the user to purge any existing diagrams, ifthey so choose.Once these two objects have been added to any database, you may thenbackup (script out) the current database diagrams by executing thestored procedure, like this:Exec usp_ScriptDatabaseDiagramsBy default, all database diagrams will be scripted, however, if youwant to script the diagrams individually, you can execute the sameprocedure, passing in the name of a specific diagram. For example:Exec usp_ScriptDatabaseDiagrams 'Users Alerts'The Transact SQL code for the two objects is too long to paste here,but if you are interested, I will email it to you. Just drop me a noteat: Join Bytes! (Remove bothinstances of TAKE_THIS_OUT from my email address first!!)-Clay
View Replies !
Creating Database Diagrams With SQL Compact 3.5 And VS2008 RTM
I'm using VS2008 RTM with a new SQL Compact 3.5 database and I read in VS2008 and SQL Compact 3.5 BOL that Database Diagrams are supported as well as Foreign Key creation from Server Explorer. However, there doesn't seem to be support for this. Database Diagram commands are not displayed for this new database (but it is for my SQL Express database) as instructed by BOL. Can anyone tell me if VS2008 fully supports SQL Compact 3.5 with database diagrams and visual tools to create relationships? If so, how can you create a database diagram in VS2008 for SQL Compact 3.5?
View Replies !
Changing Database Owner To Access Diagrams
hello, i recently changed the machine name of my development computer and am now no longer able to create or view any diagrams for the sql database that was created by the old machine name user. i receive an error where I cannot make myself "the dbo of this database." i can see the old name in the "owner" properties field of the mdf database, but the box is grayed out and i am unable to change it to the new machine/user name. is there a way to change the owner of the database to my new machine/user name? the new name has admin rights and the computer is a standalone workstation not connected to a network. i am using sql server 2005 express edition with visual web developer. thanks!
View Replies !
Extract & Copy 2005 Database Diagrams
I have database diagrams in my original db which was built with Management Studio. I now have scripts to build the database from scratch, but my diagrams are left behind, back in the original db. Is there any way to copy the original diagrams into the new db? I know in SS2000 the diagrams were in the dtproperties table; any idea where they are in SS2005?
View Replies !
Retrieving The Tables Relationship From SQL Server Database Diagrams
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 Replies !
Script, Save, Export SQL 2005 Database Diagrams
I've used the code from the post [Script, Save, Export SQL DatabaseDiagrams] 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 athttp://www.codeproject.com/useritem...Diagram2005.asp if anyone islooking 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/c...7802441d6466ca2
View Replies !
Problem With Showing Diagrams When Attaching A Sql Server 2000 Database In Sql Server 2005
I have a database created in MS SQL Server 2000 with some tables and diagrams.I have attached that database in SQL Server 2005 but when i want to access and showthe diagrams i face the following error message :Database diagram support object can not be installed because this database does not havevalid owner,to continue first use the files page of database dialog box or alter the authorizationstatement to set the database owner to valid login then add the database diagram support object.I have created a role with required permissions but i still have the problem(I still can't show the diagrams withthe new user(role) )Has anyone faced this problem too?Can anyone help ?
View Replies !
Database Diagrams: FOREIGN KEY Constraint &&"fell Off&&"; Can't Drop/recreate It...
Hello, I have two tables Person & Location where Location has a primary key LocationId and Person has a foreign key LocationId. Sometime ago I used the Database Diagrams visual tool of SQL Server Management Studio Express to create the foreign key relationship between the two tables - i.e. "visually" (drawing a line between the PK & FK LocationId elements of both tables). Time has passed and I recently noticed that, upon retrieving my saved diagram, the foreign key relationship had "fallen off" (i.e. the many-to-one line was no longer showing in the diagram). After recreating the relationship (redrawing the line) I find that I get an error message when I try to save the diagram: Post-Save Notifications [!] Errors were encountered during the save process. Some database objects were not saved. 'Location' table saved successfully 'Person' table - Unable to create relationship 'FK_Person_Location'. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Person_Location". The conflict occurred in database "mydb", table "dbo.Location", column 'LocationId'. When I go back to the object explorer and view the dependencies for the two tables, there is no dependency (between these two tables) revealed. When I try to create the foreign key constraint manually (T-SQL) it again says can't add the constraint. It comes up with an error as follows: ALTER TABLE Person ADD FOREIGN KEY (LocationId) REFERENCES Location (LocationId) Msg 547, Level 16, State 0, Line 2 The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK__Person__LocationId__793DFFAF". The conflict occurred in database "mydb", table "dbo.Location", column 'LocationId'. (Note: Each time I do this, the 8 hexadecimal character suffix changes.) When I try to drop the foreign key: alter table Person drop constraint FK__Person__LocationId it comes back with the error: Msg 3728, Level 16, State 1, Line 2 'FK__Person__LocationId' is not a constraint. Msg 3727, Level 16, State 0, Line 2 Could not drop constraint. See previous errors. So it seems that there's some kind of goof up here. Can anybody shed light on this / tell me how to fix it?
View Replies !
Database Diagrams : Showing Relations Column To Column
Hi to all, As I am going to deal with a huge number of database tables, I thought that drawing their diagrams will be the most professional way of keeping track of what I am doing. So In Enterprise Manager using the Wizard I made it to be drawn nicely. But I have a problem now. I see that the relations defined among the tables are represented correctly but the line connecting the two table is drawn randomly. I mean the starting point of the line doesnt start from the column having the primary key and doesnt end near to the column having the foreign key. Viewing my diagram I want to see the lines to start and end showing the 2 related key columns. Is there a way to accomplish this like setting an option, clicking somewhere or should I try to drag the lines to manually? Thanks in advance
View Replies !
Create Script To Create/Refresh Identical Database
I'm new to using SSIS and have been reading and learning slowly how to use it. I'm trying to create an identical copy of our database for reporting. I've used the Import/Export wizard, but have had some issues with foreign keys and with sql_variant columns. I've tried searching for anything but haven't had any luck as of yet. I guess I don't even know where to start or what to look for. Any help would be appreciated. Thanks!
View Replies !
Create Database And Create Table
Hi Hope someone can help. I am writing a stored procedure that searchs for a database and if it doesn't exist in Master will create the database and within the same stored procedure will create the necessary tables. Currently I am finding that because it is processing both from within the same transaction it will create the database and not the tables. Can someone please advise on whether this is possible and if so how. Thanks
View Replies !
How To Create A New Database From An Existing Database Saved To An External Hard Disk?
Hi, My server went dead(problems with the hard disk), but I have a copy of the whole sql server directory including the database in a external hard disk. I have a new server now and I would like to copy this database (with the reports from reporting services too) from the external hard disk to my new server. can anybody help me please? Thanks. Note : I have a plain copy of all the sql server directory with all the files including the database not a SQLServer backup done with the wizards.
View Replies !
|
TRACKER
