Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Chopsmum
Starting Member
38 Posts |
 Posted - 2006-06-04 : 08:01:54
|
| Hi friends,when trying to save diagrams I get an error:Cannot insert NULL into column diagram_id .The sp_creatediagram procedure attempted to return a status of NULL, which is not allowed.Whats with this????Also - you can modify field names from object browser but it saves the field properties as part of the fieldname.eg. "Columnname" becomes "[Columnname NULL varchar(40)]"Please helpCm |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-06-05 : 21:03:20
|
| Are you trying to alter a database that's on a SQL Server 2000 instance? If so, it will not work. You will need to use the old Enterprise Manager. The diagram tool will display I believe. That's it.For 2005, I haven't had any issues. Let me know if this is indeed a 2005 instance with the database compatability not set to backwards compatible.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
Jacob.sebastian
Starting Member
2 Posts |
Posted - 2006-12-21 : 07:36:03
|
| I had the same issue and just fixed it by turning the "diagram_id" field in SysDiagrams table to "identitity". I dropped the table and ran the following script.CREATE TABLE [dbo].[sysdiagrams]([name] [nvarchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,[principal_id] [int] NOT NULL,[diagram_id] [int] identity(1,1),[version] [int] NULL,[definition] [varbinary](max) NULL) ON [PRIMARY]It worked. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
MS SQL SERVER 2005 BUG??