Diagrams SQL Server 2005

Hello,
I am working with the 2005er version.
I am missing the diagrams where I can show the tables and there relation
ships (th old daVinci tools).
Can somebody tell me where they are gone?
Thanks
Michael
Michael Zdarsky
www.zac-it.com
ZAC-IT GmbH
09190-9271010
You should be discussing this in the beta groups for SQL Server 2005. But
since SQL 2005 B2 isn't covered under beta I can say that they diagrams are
not in the version of the beta you are working with. New features, such as
this one, may or may not be added to the final release.
Brian
"Michael Zdarsky" <zdarsky@.zac-it.com.(nospamplease)> wrote in message
news:02A8C7FB-11DE-46DF-B592-49A3F1FB6FCE@.microsoft.com...
> Hello,
> I am working with the 2005er version.
> I am missing the diagrams where I can show the tables and there relation
> ships (th old daVinci tools).
> Can somebody tell me where they are gone?
> Thanks
> Michael
> --
> Michael Zdarsky
> www.zac-it.com
> ZAC-IT GmbH
> 09190-9271010
|||http://www.aspfaq.com/sql2005/show.asp?id=6
Please use the SQL Server 2005 newsgroups to discuss SQL Server 2005.
That's what the groups were created for.
http://www.aspfaq.com/sql2005/show.asp?id=1
http://www.aspfaq.com/
(Reverse address to reply.)
"Michael Zdarsky" <zdarsky@.zac-it.com.(nospamplease)> wrote in message
news:02A8C7FB-11DE-46DF-B592-49A3F1FB6FCE@.microsoft.com...
> Hello,
> I am working with the 2005er version.
> I am missing the diagrams where I can show the tables and there relation
> ships (th old daVinci tools).
> Can somebody tell me where they are gone?
> Thanks
> Michael
> --
> Michael Zdarsky
> www.zac-it.com
> ZAC-IT GmbH
> 09190-9271010

Diagrams not showing relationships

I am trying to create a picture of my DB and a few tables
and how they relate. I have picked them, and gone through
the Diagram wizard, but am not able to see the
relationship labels. I am clicking 'Show relationship
labels', but nothing is displaying. Any help would be
appreciated. Thanks!!
Hi,
Does the underlying tables have primary key-foreign key relationships?
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"BMS" <anonymous@.discussions.microsoft.com> wrote in message
news:494f01c42bd7$dba05f60$a101280a@.phx.gbl...
> I am trying to create a picture of my DB and a few tables
> and how they relate. I have picked them, and gone through
> the Diagram wizard, but am not able to see the
> relationship labels. I am clicking 'Show relationship
> labels', but nothing is displaying. Any help would be
> appreciated. Thanks!!
|||They should, I know of 2 tables that relate by
order_number, but they don't show the relationship.
>--Original Message--
>Hi,
>Does the underlying tables have primary key-foreign key
relationships?
>--
>Dinesh
>SQL Server MVP
>--
>--
>SQL Server FAQ at
>http://www.tkdinesh.com
>"BMS" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:494f01c42bd7$dba05f60$a101280a@.phx.gbl...
tables[vbcol=seagreen]
through
>
>.
>

Diagrams not showing relationships

I am trying to create a picture of my DB and a few tables
and how they relate. I have picked them, and gone through
the Diagram wizard, but am not able to see the
relationship labels. I am clicking 'Show relationship
labels', but nothing is displaying. Any help would be
appreciated. Thanks!!Hi,
Does the underlying tables have primary key-foreign key relationships?
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"BMS" <anonymous@.discussions.microsoft.com> wrote in message
news:494f01c42bd7$dba05f60$a101280a@.phx.gbl...
> I am trying to create a picture of my DB and a few tables
> and how they relate. I have picked them, and gone through
> the Diagram wizard, but am not able to see the
> relationship labels. I am clicking 'Show relationship
> labels', but nothing is displaying. Any help would be
> appreciated. Thanks!!|||They should, I know of 2 tables that relate by
order_number, but they don't show the relationship.
>--Original Message--
>Hi,
>Does the underlying tables have primary key-foreign key
relationships?
>--
>Dinesh
>SQL Server MVP
>--
>--
>SQL Server FAQ at
>http://www.tkdinesh.com
>"BMS" <anonymous@.discussions.microsoft.com> wrote in
message
>news:494f01c42bd7$dba05f60$a101280a@.phx.gbl...
tables[vbcol=seagreen]
through[vbcol=seagreen]
>
>.
>

Diagrams not showing relationships

I am trying to create a picture of my DB and a few tables
and how they relate. I have picked them, and gone through
the Diagram wizard, but am not able to see the
relationship labels. I am clicking 'Show relationship
labels', but nothing is displaying. Any help would be
appreciated. Thanks!!Hi,
Does the underlying tables have primary key-foreign key relationships?
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"BMS" <anonymous@.discussions.microsoft.com> wrote in message
news:494f01c42bd7$dba05f60$a101280a@.phx.gbl...
> I am trying to create a picture of my DB and a few tables
> and how they relate. I have picked them, and gone through
> the Diagram wizard, but am not able to see the
> relationship labels. I am clicking 'Show relationship
> labels', but nothing is displaying. Any help would be
> appreciated. Thanks!!|||They should, I know of 2 tables that relate by
order_number, but they don't show the relationship.
>--Original Message--
>Hi,
>Does the underlying tables have primary key-foreign key
relationships?
>--
>Dinesh
>SQL Server MVP
>--
>--
>SQL Server FAQ at
>http://www.tkdinesh.com
>"BMS" <anonymous@.discussions.microsoft.com> wrote in
message
>news:494f01c42bd7$dba05f60$a101280a@.phx.gbl...
>> I am trying to create a picture of my DB and a few
tables
>> and how they relate. I have picked them, and gone
through
>> the Diagram wizard, but am not able to see the
>> relationship labels. I am clicking 'Show relationship
>> labels', but nothing is displaying. Any help would be
>> appreciated. Thanks!!
>
>.
>

Diagrams

What are these diagrams in each database used for?
If I make a link betwwen two tables in a diagram ,,does it affect the
relationships'
Why dosn't it detect the relations between the tables'
ThanksThey are a simple ERD tool for visualising the schema of your database.
Changes to relationships in a diagram will affect your schema (it will
prompt to warn you).If you don't have foreign key relationships setup then
it won't be able to automatically determine the table relations.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in message
news:e$xI1SEPEHA.1388@.TK2MSFTNGP09.phx.gbl...
> What are these diagrams in each database used for?
> If I make a link betwwen two tables in a diagram ,,does it affect the
> relationships'
> Why dosn't it detect the relations between the tables'
> Thanks
>|||How can I setup a foreign key while I'm designing a tabel?
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:O3a59pEPEHA.252@.TK2MSFTNGP10.phx.gbl...
> They are a simple ERD tool for visualising the schema of your database.
> Changes to relationships in a diagram will affect your schema (it will
> prompt to warn you).If you don't have foreign key relationships setup then
> it won't be able to automatically determine the table relations.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in message
> news:e$xI1SEPEHA.1388@.TK2MSFTNGP09.phx.gbl...
> > What are these diagrams in each database used for?
> > If I make a link betwwen two tables in a diagram ,,does it affect the
> > relationships'
> > Why dosn't it detect the relations between the tables'
> >
> > Thanks
> >
> >
>|||Reza,
CREATE TABLE master_table
(
master_id INT NOT NULL PRIMARY KEY,
master_name VARCHAR(200)
)
--One way of creating a Foreign Key
CREATE TABLE child_table
(
child_id INT NOT NULL PRIMARY KEY,
master_id INT NOT NULL REFERENCES master_table(master_id),
child_name VARCHAR(200)
)
--Another way, using Alter table
ALTER TABLE [dbo].[child_tyable] ADD
FOREIGN KEY
(
[master_id]
) REFERENCES [dbo].[master_table] (
[master_id]
)
GO
You can find basic tsql syntax in BooksOnLine.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in message
news:#jDyX8EPEHA.3016@.tk2msftngp13.phx.gbl...
> How can I setup a foreign key while I'm designing a tabel?
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:O3a59pEPEHA.252@.TK2MSFTNGP10.phx.gbl...
> > They are a simple ERD tool for visualising the schema of your database.
> > Changes to relationships in a diagram will affect your schema (it will
> > prompt to warn you).If you don't have foreign key relationships setup
then
> > it won't be able to automatically determine the table relations.
> >
> > --
> > HTH
> >
> > Jasper Smith (SQL Server MVP)
> >
> > I support PASS - the definitive, global
> > community for SQL Server professionals -
> > http://www.sqlpass.org
> >
> >
> > "Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in message
> > news:e$xI1SEPEHA.1388@.TK2MSFTNGP09.phx.gbl...
> > > What are these diagrams in each database used for?
> > > If I make a link betwwen two tables in a diagram ,,does it affect the
> > > relationships'
> > > Why dosn't it detect the relations between the tables'
> > >
> > > Thanks
> > >
> > >
> >
> >
>|||You can also drag and drop in columns in the diagram itself to visually
create your relationships however I would recomend the approcah from Dinesh
i.e. explicitly create them as part of your schema as its too easy to get
things the wrong way round using the diagram tool.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:uaAAHKFPEHA.3052@.TK2MSFTNGP09.phx.gbl...
> Reza,
> CREATE TABLE master_table
> (
> master_id INT NOT NULL PRIMARY KEY,
> master_name VARCHAR(200)
> )
> --One way of creating a Foreign Key
> CREATE TABLE child_table
> (
> child_id INT NOT NULL PRIMARY KEY,
> master_id INT NOT NULL REFERENCES master_table(master_id),
> child_name VARCHAR(200)
> )
> --Another way, using Alter table
> ALTER TABLE [dbo].[child_tyable] ADD
> FOREIGN KEY
> (
> [master_id]
> ) REFERENCES [dbo].[master_table] (
> [master_id]
> )
> GO
> You can find basic tsql syntax in BooksOnLine.
>
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in message
> news:#jDyX8EPEHA.3016@.tk2msftngp13.phx.gbl...
> > How can I setup a foreign key while I'm designing a tabel?
> >
> > "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> > news:O3a59pEPEHA.252@.TK2MSFTNGP10.phx.gbl...
> > > They are a simple ERD tool for visualising the schema of your
database.
> > > Changes to relationships in a diagram will affect your schema (it will
> > > prompt to warn you).If you don't have foreign key relationships setup
> then
> > > it won't be able to automatically determine the table relations.
> > >
> > > --
> > > HTH
> > >
> > > Jasper Smith (SQL Server MVP)
> > >
> > > I support PASS - the definitive, global
> > > community for SQL Server professionals -
> > > http://www.sqlpass.org
> > >
> > >
> > > "Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in
message
> > > news:e$xI1SEPEHA.1388@.TK2MSFTNGP09.phx.gbl...
> > > > What are these diagrams in each database used for?
> > > > If I make a link betwwen two tables in a diagram ,,does it affect
the
> > > > relationships'
> > > > Why dosn't it detect the relations between the tables'
> > > >
> > > > Thanks
> > > >
> > > >
> > >
> > >
> >
> >
>

diagraming databases

Are diagrams passive? What really holds the relationships between the
tables? I have to look at a legacy database in SQL2000 and the diagram does
not seem to match the behavor of the tables.
Diagrams do work if there is a relation established on the tables.
Just check if Primary Key - Foreign Key combination is correctly defined
regards
Chandra
"Rich" wrote:

> Are diagrams passive? What really holds the relationships between the
> tables? I have to look at a legacy database in SQL2000 and the diagram does
> not seem to match the behavor of the tables.
|||> Are diagrams passive?
Sort of. Possibly that EM tries to "synchronize" a diagram when you open it and you have performed
modifications in the database structure.

> What really holds the relationships between the
> tables?
Defined FOREIGN KEY constraints used in commands such as ALTER TABLE tblref ADD CONSTRAINT col
REFERENCES tblreferenced(col).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:6D4302AE-1F21-41A0-9125-AF8D6085F276@.microsoft.com...
> Are diagrams passive? What really holds the relationships between the
> tables? I have to look at a legacy database in SQL2000 and the diagram does
> not seem to match the behavor of the tables.

diagraming databases

Are diagrams passive? What really holds the relationships between the
tables? I have to look at a legacy database in SQL2000 and the diagram does
not seem to match the behavor of the tables.Diagrams do work if there is a relation established on the tables.
Just check if Primary Key - Foreign Key combination is correctly defined
regards
Chandra
"Rich" wrote:

> Are diagrams passive? What really holds the relationships between the
> tables? I have to look at a legacy database in SQL2000 and the diagram do
es
> not seem to match the behavor of the tables.|||> Are diagrams passive?
Sort of. Possibly that EM tries to "synchronize" a diagram when you open it
and you have performed
modifications in the database structure.

> What really holds the relationships between the
> tables?
Defined FOREIGN KEY constraints used in commands such as ALTER TABLE tblref
ADD CONSTRAINT col
REFERENCES tblreferenced(col).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:6D4302AE-1F21-41A0-9125-AF8D6085F276@.microsoft.com...
> Are diagrams passive? What really holds the relationships between the
> tables? I have to look at a legacy database in SQL2000 and the diagram do
es
> not seem to match the behavor of the tables.

diagraming databases

Are diagrams passive? What really holds the relationships between the
tables? I have to look at a legacy database in SQL2000 and the diagram does
not seem to match the behavor of the tables.Diagrams do work if there is a relation established on the tables.
Just check if Primary Key - Foreign Key combination is correctly defined
regards
Chandra
"Rich" wrote:
> Are diagrams passive? What really holds the relationships between the
> tables? I have to look at a legacy database in SQL2000 and the diagram does
> not seem to match the behavor of the tables.|||> Are diagrams passive?
Sort of. Possibly that EM tries to "synchronize" a diagram when you open it and you have performed
modifications in the database structure.
> What really holds the relationships between the
> tables?
Defined FOREIGN KEY constraints used in commands such as ALTER TABLE tblref ADD CONSTRAINT col
REFERENCES tblreferenced(col).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:6D4302AE-1F21-41A0-9125-AF8D6085F276@.microsoft.com...
> Are diagrams passive? What really holds the relationships between the
> tables? I have to look at a legacy database in SQL2000 and the diagram does
> not seem to match the behavor of the tables.

Diagram to Image

Hello

I have created a Database Diagram for the tables I have in the database and set the relationships of the tables with the fields.

Now I want to export this diagram to the Image format (jpeg, gif or any other one), so i can
add this image in my documentation (ms-word-xp doc) of the project..

I have looked into the options, but i did'nt find any way to export it. So i thought something went wrong while installation, but was made sure that was fine.

Please let me know what is the way to export that diagram to image. (its a exigency)

hope to your all valuable response as soon.

thanks, (in advance) and for your time.Right-click in your diagram, and copy it to the clipboard. You can then paste it into your doc.|||before you give any suggestions, please make sure that your words holds true.

copying diagram from SQL EM to office xp is not supported.

Anyway, thanks for investing your precious time in your one line.|||

try copying into MSPaint, and then using that image in your Doc.

BTW, the copy to clipboard method works fine in Office 2003, for anyone wondering.

|||Andrew Badera, thanks for your time again.

Just give a try of copying from SQL EM to MSPaint, IT IS NOT SUPPORTED.
I dont know how you have checked.

and thanks for suggestion on telling me try OFFICE 2003 (which I am not going to do).
For this simple thing, I cant change the office version i am using, which is really a waste of time.

Anyway, my problem solved long before.
|||

Beau Peep wrote:

Andrew Badera, thanks for your time again.

Just give a try of copying from SQL EM to MSPaint, IT IS NOT SUPPORTED.
I dont know how you have checked.

sorry, should have been more specific I guess: get a screen capture. copy that into mspaint.

|||

I realize this may not help the original poster, but for those that run across this thread by chance ...

My work around is to print to the Microsoft Office Document Image Writer. The file can be saved as either .mdi or .tiff.

I work remotely and cannot connect to my remote development environment with my printer (never figured that one out) ... anyway, because of this, I am not able to print my diagrams directly from EM. After printing to the Image Writer, I simply move the file to my local machine, where it will automatically open in Microsoft Office Document Imaging. From there I can print it to my local printer.

Of course, this option depends on whether or not Microsoft Office Document Image Writer is available on your system. I work with Windows XP and Windows Server 2003, and can confirm that the Document Image Writer is available.

Thanks

Jen

Diagram to Image

Hello
I have created a Database Diagram for the tables I have in the database and
set the relationships of the tables with the fields.
Now I want to export this diagram to the Image format (jpeg, gif or any
other one), so i can add this image in my documentation (ms-word-xp doc) of
the project documentation.
I have looked into the options, but i did'nt find any way to export it. So i
thought something went wrong while installation, but was made sure that was
fine.
Please let me know what is the way to export that diagram to image. (its a
exigency)
hope to see your all valuable response as soon.
thanks, (in advance) and for your time.
=========
NuclearWeapon.ExecTimeOut=10;
NuclearWeapon.Launch=True;
OhWhatIHaveDone();
Beau,
If you are using SQL Server 2005, and generated the diagram in
Management Studio:
1. Right-click in the diagram pane
2. Choose "Copy Diagram to Clipboard"
3. Paste in the destination program.
If you are using 2000 and Enterprise Manager, one option
is to print to the Microsoft Office Document Image Writer,
and choose TIFF output at a low resolution. Other options are
to capture the screen with Alt-PrtSc or a utility (like SnagIt) that can
capture a scrolling window's contents.
Steve Kass
Drew University
Beau Peep wrote:

>Hello
>I have created a Database Diagram for the tables I have in the database and
>set the relationships of the tables with the fields.
>Now I want to export this diagram to the Image format (jpeg, gif or any
>other one), so i can add this image in my documentation (ms-word-xp doc) of
>the project documentation.
>I have looked into the options, but i did'nt find any way to export it. So i
>thought something went wrong while installation, but was made sure that was
>fine.
>Please let me know what is the way to export that diagram to image. (its a
>exigency)
>hope to see your all valuable response as soon.
>thanks, (in advance) and for your time.
>
|||Hello Steve Kass,
Thanks for replying.
Actually, I am using MS-SQL 2000 Enterprises Manager on Windows 2000
Advanced Server. I looked in to your points, but I did'nt get any of such
option that you have mentioned ("Microsoft Office Image Writer"). Could you
please
guide me with the proper steps to achive this and How to configure this "TIFF"
stuff. (I have know idea).
Hope to see your response as soon.
=========
NuclearWeapon.ExecTimeOut=10;
NuclearWeapon.Launch=True;
OhWhatIHaveDone();
"Steve Kass" wrote:

> Beau,
> If you are using SQL Server 2005, and generated the diagram in
> Management Studio:
> 1. Right-click in the diagram pane
> 2. Choose "Copy Diagram to Clipboard"
> 3. Paste in the destination program.
> If you are using 2000 and Enterprise Manager, one option
> is to print to the Microsoft Office Document Image Writer,
> and choose TIFF output at a low resolution. Other options are
> to capture the screen with Alt-PrtSc or a utility (like SnagIt) that can
> capture a scrolling window's contents.
> Steve Kass
> Drew University
> Beau Peep wrote:
>
|||The microsoft office document image writer is part of Office, to get
this option
Office needs to be installed on the machine (think Office 2003 is
required).
Alternatively use Adobe PDF writer or the freeware option Cute PDF
(http://www.CutePDF.com)
Regards,
David
|||Hello David,
Thanks for the suggestion.
I downloaded that just checked. Its really great creating things in PDF.
But what I was expecting was to print this Database diagram completly in one
page. That CutePDF will prints all these images in page wise. ITs like
breaking the
complete image to page wise. I tried setting the page size but none of them
helped.
Is there any idea that I can get this diagram in complete one page?
Hope to see your response as soon. Thanks anyway. Its really a great tool.
=========
NuclearWeapon.ExecTimeOut=10;
NuclearWeapon.Launch=True;
OhWhatIHaveDone();
"David" wrote:

> The microsoft office document image writer is part of Office, to get
> this option
> Office needs to be installed on the machine (think Office 2003 is
> required).
> Alternatively use Adobe PDF writer or the freeware option Cute PDF
> (http://www.CutePDF.com)
> Regards,
> David
>
|||Hi, try to change the paper size in the print dialogue to A3 (the
largest available),
then change width and height to the maximum 91 cm. This is the largest
page
Ive found, then print it to the PDF and you get it all on one page
(hopefully).
Cheers,
David
|||Helllo David,
I tried this setting to A3 but i did'nt find any option for setting the
width and height
to 91cm. I just tried the setting A3 and printed to see how it comes. Dont
ASK.
Half of the Diagram was chopped off.
I guess, only microsoft should provide some functionality to export that
diagram to
any image format.
Well, any suggestions left, please let me know. if possible guide me how to
set the
width and height of the page?
Anyway thanks for the help and your ideas, hope to see your response as soon.
=========
NuclearWeapon.ExecTimeOut=10;
NuclearWeapon.Launch=True;
OhWhatIHaveDone();
"David" wrote:

> Hi, try to change the paper size in the print dialogue to A3 (the
> largest available),
> then change width and height to the maximum 91 cm. This is the largest
> page
> Ive found, then print it to the PDF and you get it all on one page
> (hopefully).
> Cheers,
> David
>

Diagram to Image

Hello

I have created a Database Diagram for the tables I have in the database and set the relationships of the tables with the fields.

Now I want to export this diagram to the Image format (jpeg, gif or any other one), so i can
add this image in my documentation (ms-word-xp doc) of the project..

I have looked into the options, but i did'nt find any way to export it. So i thought something went wrong while installation, but was made sure that was fine.

Please let me know what is the way to export that diagram to image. (its a exigency)

hope to your all valuable response as soon.

thanks, (in advance) and for your time.Right-click in your diagram, and copy it to the clipboard. You can then paste it into your doc.|||before you give any suggestions, please make sure that your words holds true.

copying diagram from SQL EM to office xp is not supported.

Anyway, thanks for investing your precious time in your one line.|||

try copying into MSPaint, and then using that image in your Doc.

BTW, the copy to clipboard method works fine in Office 2003, for anyone wondering.

|||Andrew Badera, thanks for your time again.

Just give a try of copying from SQL EM to MSPaint, IT IS NOT SUPPORTED.
I dont know how you have checked.

and thanks for suggestion on telling me try OFFICE 2003 (which I am not going to do).
For this simple thing, I cant change the office version i am using, which is really a waste of time.

Anyway, my problem solved long before.
|||

Beau Peep wrote:

Andrew Badera, thanks for your time again.

Just give a try of copying from SQL EM to MSPaint, IT IS NOT SUPPORTED.
I dont know how you have checked.

sorry, should have been more specific I guess: get a screen capture. copy that into mspaint.

|||

I realize this may not help the original poster, but for those that run across this thread by chance ...

My work around is to print to the Microsoft Office Document Image Writer. The file can be saved as either .mdi or .tiff.

I work remotely and cannot connect to my remote development environment with my printer (never figured that one out) ... anyway, because of this, I am not able to print my diagrams directly from EM. After printing to the Image Writer, I simply move the file to my local machine, where it will automatically open in Microsoft Office Document Imaging. From there I can print it to my local printer.

Of course, this option depends on whether or not Microsoft Office Document Image Writer is available on your system. I work with Windows XP and Windows Server 2003, and can confirm that the Document Image Writer is available.

Thanks

Jen

Diagram one to one in 2005

How do you create a one to one relationship from the diagram in Sql Server
2005?
All the relationships I create between tables from the diagram tool, shows
the tables as one to many.
Thanks,
TomIf by one to one, you mean every row in Table A must have exactly one
corresponding row in Table B and every row in Table B must have exactly one
corresponding row in Table A, the way to do that is to make one table out of
those two tables. If there is some reason they cannot be one table, you
will have to enforce this by triggers and/or by maintaining these tables
with stored procedures.
If by one to one, you mean one to zero or one, that is, every row in Table A
has zero or one corresponding rows in Table B, but can't have more than one,
then create a normal foreign key relationship from Table B to Table A, and
then make the foreign key columns in Table B unique.
If you mean something else, please give us a description of what you want.
Tom
"tshad" <tshad@.dslextreme.com> wrote in message
news:OTuWc1HXIHA.5340@.TK2MSFTNGP06.phx.gbl...
> How do you create a one to one relationship from the diagram in Sql Server
> 2005?
> All the relationships I create between tables from the diagram tool, shows
> the tables as one to many.
> Thanks,
> Tom
>|||"Tom Cooper" <tomcooper@.comcast.no.spam.please.net> wrote in message
news:en3XUPIXIHA.4476@.TK2MSFTNGP06.phx.gbl...
> If by one to one, you mean every row in Table A must have exactly one
> corresponding row in Table B and every row in Table B must have exactly
> one corresponding row in Table A, the way to do that is to make one table
> out of those two tables. If there is some reason they cannot be one
> table, you will have to enforce this by triggers and/or by maintaining
> these tables with stored procedures.
Actually, that was how I had it - 1 table. But the customer wants to split
out the data that is specific to the entity. Another reason is that there
are many large fields that are mainly comments and that could potentially
make a row 10K.
> If by one to one, you mean one to zero or one, that is, every row in Table
> A has zero or one corresponding rows in Table B, but can't have more than
> one, then create a normal foreign key relationship from Table B to Table
> A, and then make the foreign key columns in Table B unique.
No I mean one to one. But I would have the same problem if I was using zero
to one.
How do I do that from the wizards?
The value in the foreign table is not a key just a value. It has another
primary key for the table.
In EM it shows the relationship between the tables using this field. Do I
explicitly need to make this a key in EM?
Thanks,
Tom
> If you mean something else, please give us a description of what you want.
> Tom
> "tshad" <tshad@.dslextreme.com> wrote in message
> news:OTuWc1HXIHA.5340@.TK2MSFTNGP06.phx.gbl...
>> How do you create a one to one relationship from the diagram in Sql
>> Server 2005?
>> All the relationships I create between tables from the diagram tool,
>> shows the tables as one to many.
>> Thanks,
>> Tom
>