When trying to create a DB diagram on my local SQL Server 2005 db, I get the following error:
cannot insert the value null into column "diagram_id"
I have searched the web and can't seem to find anything on this.
I just simply drag one table from my local db onto the diagram windows and try to Save it and that's what I get. I'm able to save diagrams on a networked SQL Server.
Does anybody know how I can resolve this issue?
Dear Bill
I am a newbie and have also experienced the same problem, on a local machine with SQL Server 2005 DE.
I have placed a similar msg on a few forums and no response to them as yet.
"MS SQL SERVER 2005 BUG? Cannot insert NULL into column diagram_id
Hi friends,
when trying to save a diagram I got an error:
The sp_creatediagram procedure attempted to return a status of NULL, which is not allowed."
Whats with this?
As far as I can work out, it has only started happening since I mucked around with the database properties such as ANSI NULLS true/false. I have put them back to default as a test and it doesnt fix the problem.
Have you got any ideas about it yet?
This comes from the fact that the db was a prior version of sql server (via a conversion to 2005). This will not work.
You have to create the db brand new in sql server 2005, then import data from your sql server 2000 db, etc.
I have the same problem - is there any work around, or fix available?
I have tried to create the diagram from SQL Server Management Studio and Visual Studio 2005.
I have the same issue, and I have NEVER had SQL Server 2000 on any server here.
I am only getting this error on one or two of the 7 databases that I have on the SQL server instance.
--
Is there a way to delete the diagramming "stuff" so that when the create... option is chosen in Database Diagrams, it resets all of the sp's, etc.?
Hi,
I had this problem as well (SQL 2005) - I simply deleted the sysdiagrams table from System Tables and created a new diagram allowing it to automatically create the database objects. This seemed to solve the problem.
Nick
Hello:
This is what I did....
1. Created a Create Query for the System Tables > dbo.sysdiagrams
2. Changed the following statement:
[diagram_id] [int]
DEFAULT ((0)),3. Deleted the table: System Tables > dbo.sysdiagrams
4. Executed the modified query
5. Saved my diagram. It worked fine
6. I was even able to create and open multiple diagrams without any problems!
software786
