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?
Did you encounter the same issue in all of the databases in the local SQL server? Or just particular database(s)? I guess the issue is caused by a database attached from previous SQL server (2000 or 7.0), if it does, please let me know.
No comments:
Post a Comment