Data Diagrams in SQL Server Management Studio

I can create a data diagram and all is well and good. Life cannot be better

If I attempt to create a second diagram in the same database I can lay out my tables (or even just a single comment) and I can print and all appears good but!

When I go to save I get this message. How can I create two diagrams for one database?

TITLE: Microsoft SQL Server Management Studio

Cannot insert the value NULL into column 'diagram_id', table 'ReportData.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)

BUTTONS:

OK

You might want to try the SQL Tools General forum for this, as it doesn't seem to relate to SSIS.

|||

Moving thread...

|||

Which service pack is installed on the machine ? Where did you try to create the second diagram ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

check whether this helps u

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=357447&SiteID=1

Madhu

Data Diagrams

I hav restored sql server7 DB in sql server 2005 exp.....but the data diag. donot open...what 2 do

Database Diagrams are different between 7 and 2005. You will need to change the "compatibility level" of the database (use the Properties tab of the database in Management Studio) and set it to 9.0 instead of 7.0, then recreate the database diagrams.

Buck Woody

Data Diagrams

I hav restored sql server7 DB in sql server 2005 exp.....but the data diag. donot open...what 2 do

Database Diagrams are different between 7 and 2005. You will need to change the "compatibility level" of the database (use the Properties tab of the database in Management Studio) and set it to 9.0 instead of 7.0, then recreate the database diagrams.

Buck Woody

Data Diagrams

Is it possible to copy and paste a diagram from one DB to another. If so,
what are the steps?
Thanks!
The following applies to SQL Server 7 and 2000:
How To Move a Database Diagram
http://www.support.microsoft.com/?id=320125
-Sue
On Mon, 9 Oct 2006 20:41:25 -0400, "Chris Marsh"
<cmarsh@.synergy-intl.com> wrote:

>Is it possible to copy and paste a diagram from one DB to another. If so,
>what are the steps?
>Thanks!
>
|||Thank You!
Now for the next part of this question. Is there a manual way to migrate
them to SQL2005 as well. About 1/2 our clients are in 2000 and the other
half in 2005 yet we use it in version 8 (sql2000) compatability mode.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:bt1mi2t9frgh2oh5tki41leesnsnma9usp@.4ax.com...
> The following applies to SQL Server 7 and 2000:
> How To Move a Database Diagram
> http://www.support.microsoft.com/?id=320125
> -Sue
> On Mon, 9 Oct 2006 20:41:25 -0400, "Chris Marsh"
> <cmarsh@.synergy-intl.com> wrote:
>
|||I don't think you will get that scenario to work. On SQL
Server 2005, you can't even create diagrams unless the
database is in 90 compatibility mode.
-Sue
On Tue, 10 Oct 2006 09:41:49 -0400, "Chris Marsh"
<cmarsh@.synergy-intl.com> wrote:

>Thank You!
>Now for the next part of this question. Is there a manual way to migrate
>them to SQL2005 as well. About 1/2 our clients are in 2000 and the other
>half in 2005 yet we use it in version 8 (sql2000) compatability mode.
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:bt1mi2t9frgh2oh5tki41leesnsnma9usp@.4ax.com.. .
>
|||Oh...well then I guess we should consider doing this. Do you know of any
obvious reason that we should not have our SQL 2005 clients in V9 mode?
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:4ecni2lcpn54eqmor49hbbn3dunfo6pqlv@.4ax.com...
>I don't think you will get that scenario to work. On SQL
> Server 2005, you can't even create diagrams unless the
> database is in 90 compatibility mode.
> -Sue
> On Tue, 10 Oct 2006 09:41:49 -0400, "Chris Marsh"
> <cmarsh@.synergy-intl.com> wrote:
>
|||I assume you mean "why we should not have out client databases in 90 compatibility mode"?
The reason is if you haven't tested and ported your application to support SQL Server 1005 yet.
Compat mode is there to give you a little extra time. You test the app in 2005 under 80 mode and do
the small amount of fixes you need to support that. You can now run the app on 2005, and you can
take your time to do the rest of the fixes needed to run in 90 mode.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:OGUMm0H7GHA.3760@.TK2MSFTNGP02.phx.gbl...
> Oh...well then I guess we should consider doing this. Do you know of any obvious reason that we
> should not have our SQL 2005 clients in V9 mode?
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:4ecni2lcpn54eqmor49hbbn3dunfo6pqlv@.4ax.com...
>
|||You are correct - we will get testing very soon and hopefully won't find too
many tweaks.
Thank You!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uFFGq3H7GHA.4604@.TK2MSFTNGP03.phx.gbl...
>I assume you mean "why we should not have out client databases in 90
>compatibility mode"?
> The reason is if you haven't tested and ported your application to support
> SQL Server 1005 yet. Compat mode is there to give you a little extra time.
> You test the app in 2005 under 80 mode and do the small amount of fixes
> you need to support that. You can now run the app on 2005, and you can
> take your time to do the rest of the fixes needed to run in 90 mode.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
> news:OGUMm0H7GHA.3760@.TK2MSFTNGP02.phx.gbl...
>

Data Diagrams

Is it possible to copy and paste a diagram from one DB to another. If so,
what are the steps?
Thanks!The following applies to SQL Server 7 and 2000:
How To Move a Database Diagram
http://www.support.microsoft.com/?id=320125
-Sue
On Mon, 9 Oct 2006 20:41:25 -0400, "Chris Marsh"
<cmarsh@.synergy-intl.com> wrote:
>Is it possible to copy and paste a diagram from one DB to another. If so,
>what are the steps?
>Thanks!
>|||Thank You!
Now for the next part of this question. Is there a manual way to migrate
them to SQL2005 as well. About 1/2 our clients are in 2000 and the other
half in 2005 yet we use it in version 8 (sql2000) compatability mode.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:bt1mi2t9frgh2oh5tki41leesnsnma9usp@.4ax.com...
> The following applies to SQL Server 7 and 2000:
> How To Move a Database Diagram
> http://www.support.microsoft.com/?id=320125
> -Sue
> On Mon, 9 Oct 2006 20:41:25 -0400, "Chris Marsh"
> <cmarsh@.synergy-intl.com> wrote:
>>Is it possible to copy and paste a diagram from one DB to another. If so,
>>what are the steps?
>>Thanks!
>|||I don't think you will get that scenario to work. On SQL
Server 2005, you can't even create diagrams unless the
database is in 90 compatibility mode.
-Sue
On Tue, 10 Oct 2006 09:41:49 -0400, "Chris Marsh"
<cmarsh@.synergy-intl.com> wrote:
>Thank You!
>Now for the next part of this question. Is there a manual way to migrate
>them to SQL2005 as well. About 1/2 our clients are in 2000 and the other
>half in 2005 yet we use it in version 8 (sql2000) compatability mode.
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:bt1mi2t9frgh2oh5tki41leesnsnma9usp@.4ax.com...
>> The following applies to SQL Server 7 and 2000:
>> How To Move a Database Diagram
>> http://www.support.microsoft.com/?id=320125
>> -Sue
>> On Mon, 9 Oct 2006 20:41:25 -0400, "Chris Marsh"
>> <cmarsh@.synergy-intl.com> wrote:
>>Is it possible to copy and paste a diagram from one DB to another. If so,
>>what are the steps?
>>Thanks!
>>
>|||Oh...well then I guess we should consider doing this. Do you know of any
obvious reason that we should not have our SQL 2005 clients in V9 mode?
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:4ecni2lcpn54eqmor49hbbn3dunfo6pqlv@.4ax.com...
>I don't think you will get that scenario to work. On SQL
> Server 2005, you can't even create diagrams unless the
> database is in 90 compatibility mode.
> -Sue
> On Tue, 10 Oct 2006 09:41:49 -0400, "Chris Marsh"
> <cmarsh@.synergy-intl.com> wrote:
>>Thank You!
>>Now for the next part of this question. Is there a manual way to migrate
>>them to SQL2005 as well. About 1/2 our clients are in 2000 and the other
>>half in 2005 yet we use it in version 8 (sql2000) compatability mode.
>>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>>news:bt1mi2t9frgh2oh5tki41leesnsnma9usp@.4ax.com...
>> The following applies to SQL Server 7 and 2000:
>> How To Move a Database Diagram
>> http://www.support.microsoft.com/?id=320125
>> -Sue
>> On Mon, 9 Oct 2006 20:41:25 -0400, "Chris Marsh"
>> <cmarsh@.synergy-intl.com> wrote:
>>Is it possible to copy and paste a diagram from one DB to another. If
>>so,
>>what are the steps?
>>Thanks!
>>
>|||I assume you mean "why we should not have out client databases in 90 compatibility mode"?
The reason is if you haven't tested and ported your application to support SQL Server 1005 yet.
Compat mode is there to give you a little extra time. You test the app in 2005 under 80 mode and do
the small amount of fixes you need to support that. You can now run the app on 2005, and you can
take your time to do the rest of the fixes needed to run in 90 mode.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:OGUMm0H7GHA.3760@.TK2MSFTNGP02.phx.gbl...
> Oh...well then I guess we should consider doing this. Do you know of any obvious reason that we
> should not have our SQL 2005 clients in V9 mode?
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:4ecni2lcpn54eqmor49hbbn3dunfo6pqlv@.4ax.com...
>>I don't think you will get that scenario to work. On SQL
>> Server 2005, you can't even create diagrams unless the
>> database is in 90 compatibility mode.
>> -Sue
>> On Tue, 10 Oct 2006 09:41:49 -0400, "Chris Marsh"
>> <cmarsh@.synergy-intl.com> wrote:
>>Thank You!
>>Now for the next part of this question. Is there a manual way to migrate
>>them to SQL2005 as well. About 1/2 our clients are in 2000 and the other
>>half in 2005 yet we use it in version 8 (sql2000) compatability mode.
>>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>>news:bt1mi2t9frgh2oh5tki41leesnsnma9usp@.4ax.com...
>> The following applies to SQL Server 7 and 2000:
>> How To Move a Database Diagram
>> http://www.support.microsoft.com/?id=320125
>> -Sue
>> On Mon, 9 Oct 2006 20:41:25 -0400, "Chris Marsh"
>> <cmarsh@.synergy-intl.com> wrote:
>>Is it possible to copy and paste a diagram from one DB to another. If so,
>>what are the steps?
>>Thanks!
>>
>>
>|||You are correct - we will get testing very soon and hopefully won't find too
many tweaks.
Thank You!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uFFGq3H7GHA.4604@.TK2MSFTNGP03.phx.gbl...
>I assume you mean "why we should not have out client databases in 90
>compatibility mode"?
> The reason is if you haven't tested and ported your application to support
> SQL Server 1005 yet. Compat mode is there to give you a little extra time.
> You test the app in 2005 under 80 mode and do the small amount of fixes
> you need to support that. You can now run the app on 2005, and you can
> take your time to do the rest of the fixes needed to run in 90 mode.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
> news:OGUMm0H7GHA.3760@.TK2MSFTNGP02.phx.gbl...
>> Oh...well then I guess we should consider doing this. Do you know of any
>> obvious reason that we should not have our SQL 2005 clients in V9 mode?
>> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>> news:4ecni2lcpn54eqmor49hbbn3dunfo6pqlv@.4ax.com...
>>I don't think you will get that scenario to work. On SQL
>> Server 2005, you can't even create diagrams unless the
>> database is in 90 compatibility mode.
>> -Sue
>> On Tue, 10 Oct 2006 09:41:49 -0400, "Chris Marsh"
>> <cmarsh@.synergy-intl.com> wrote:
>>Thank You!
>>Now for the next part of this question. Is there a manual way to migrate
>>them to SQL2005 as well. About 1/2 our clients are in 2000 and the other
>>half in 2005 yet we use it in version 8 (sql2000) compatability mode.
>>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>>news:bt1mi2t9frgh2oh5tki41leesnsnma9usp@.4ax.com...
>> The following applies to SQL Server 7 and 2000:
>> How To Move a Database Diagram
>> http://www.support.microsoft.com/?id=320125
>> -Sue
>> On Mon, 9 Oct 2006 20:41:25 -0400, "Chris Marsh"
>> <cmarsh@.synergy-intl.com> wrote:
>>Is it possible to copy and paste a diagram from one DB to another. If
>>so,
>>what are the steps?
>>Thanks!
>>
>>
>>
>sql

Data Diagrams

Is it possible to copy and paste a diagram from one DB to another. If so,
what are the steps?
Thanks!The following applies to SQL Server 7 and 2000:
How To Move a Database Diagram
http://www.support.microsoft.com/?id=320125
-Sue
On Mon, 9 Oct 2006 20:41:25 -0400, "Chris Marsh"
<cmarsh@.synergy-intl.com> wrote:

>Is it possible to copy and paste a diagram from one DB to another. If so,
>what are the steps?
>Thanks!
>|||Thank You!
Now for the next part of this question. Is there a manual way to migrate
them to SQL2005 as well. About 1/2 our clients are in 2000 and the other
half in 2005 yet we use it in version 8 (sql2000) compatability mode.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:bt1mi2t9frgh2oh5tki41leesnsnma9usp@.
4ax.com...
> The following applies to SQL Server 7 and 2000:
> How To Move a Database Diagram
> http://www.support.microsoft.com/?id=320125
> -Sue
> On Mon, 9 Oct 2006 20:41:25 -0400, "Chris Marsh"
> <cmarsh@.synergy-intl.com> wrote:
>
>|||I don't think you will get that scenario to work. On SQL
Server 2005, you can't even create diagrams unless the
database is in 90 compatibility mode.
-Sue
On Tue, 10 Oct 2006 09:41:49 -0400, "Chris Marsh"
<cmarsh@.synergy-intl.com> wrote:

>Thank You!
>Now for the next part of this question. Is there a manual way to migrate
>them to SQL2005 as well. About 1/2 our clients are in 2000 and the other
>half in 2005 yet we use it in version 8 (sql2000) compatability mode.
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:bt1mi2t9frgh2oh5tki41leesnsnma9usp@.
4ax.com...
>|||Oh...well then I guess we should consider doing this. Do you know of any
obvious reason that we should not have our SQL 2005 clients in V9 mode?
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:4ecni2lcpn54eqmor49hbbn3dunfo6pqlv@.
4ax.com...
>I don't think you will get that scenario to work. On SQL
> Server 2005, you can't even create diagrams unless the
> database is in 90 compatibility mode.
> -Sue
> On Tue, 10 Oct 2006 09:41:49 -0400, "Chris Marsh"
> <cmarsh@.synergy-intl.com> wrote:
>
>|||I assume you mean "why we should not have out client databases in 90 compati
bility mode"?
The reason is if you haven't tested and ported your application to support S
QL Server 1005 yet.
Compat mode is there to give you a little extra time. You test the app in 20
05 under 80 mode and do
the small amount of fixes you need to support that. You can now run the app
on 2005, and you can
take your time to do the rest of the fixes needed to run in 90 mode.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:OGUMm0H7GHA.3760@.TK2MSFTNGP02.phx.gbl...
> Oh...well then I guess we should consider doing this. Do you know of any
obvious reason that we
> should not have our SQL 2005 clients in V9 mode?
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:4ecni2lcpn54eqmor49hbbn3dunfo6pqlv@.
4ax.com...
>|||You are correct - we will get testing very soon and hopefully won't find too
many tweaks.
Thank You!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uFFGq3H7GHA.4604@.TK2MSFTNGP03.phx.gbl...
>I assume you mean "why we should not have out client databases in 90
>compatibility mode"?
> The reason is if you haven't tested and ported your application to support
> SQL Server 1005 yet. Compat mode is there to give you a little extra time.
> You test the app in 2005 under 80 mode and do the small amount of fixes
> you need to support that. You can now run the app on 2005, and you can
> take your time to do the rest of the fixes needed to run in 90 mode.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
> news:OGUMm0H7GHA.3760@.TK2MSFTNGP02.phx.gbl...
>

Data Base Diagrams ...

Hi,

I am relatively new to SQL 2005.
How do I create the Data Base diagrams of my existing data base in SQL 2005 ?

Thanks,
Abhijit Sinha

Using Management Studio, in Object Explorer, expand the database in the left pane.

Then right-click on [Database Diagrams] and select [New Database Diagram].

Follow the instructions.

|||Hey Arnie !

I think I should have been more specific. The data base I am talking about was created in SQL 2000. I am using SQL 2005 to view it. I need to create the DB diagrams from SQL 2005. When I right click on DB diagrams, all I get is
1. Working with SQL 2000 data base diagrams
2. Refresh

Clicking on option 1 takes me to the SQL help section which basically tells me that
"SQL Server Management Studio cannot work with SQL Server 2000 diagrams. Use SQL Server 2000 Enterprise Manager instead."

I was wondering if there is any work-around to this issue as I don't have SQL 2000 installed on my system.

Thanks,
Abhijit Sinha
|||OK, lets by a bit more specific.

YOu have a SQL Server SSMS 2005 Gui to manage your server, but you are administering a SQL Server 2000 with it. Then you cannot create a diagram on the SQL Server 2000. You will have to install Enterprise Manager 2000.

Jens K. Suessmeyer.

http://www.sqlserver2005.de