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 a tool anyone can recommend

Hi want to produce a DB diagram on MSQSL 2000.
all I want to do is create links which exist diagrammatically only.
Instead as I UNDERSTAND it the SQL wants to physically create these
constraints on the DB. I DO NOT WANT THIS.
Pls don't answer that I should be using constraints, FK etcs. Not my
call and too late.
Is it possible to simply produce a diagram where I draw links between
fields without effecting underlying DB.
Is there a tool that will do this? Or should I just throw it into word
and make the links myself or use Visio. Preferably would like to
create diagram in MMSQL but which didn't change underlying DB.
Itzik, shalom
I'm afraid you are not able to do that with SQL Server.
Perhaps , there are some third part software to be able to do it for you.
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.co m...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.
|||I generally use Visio for this... But you could use any 3rd party modelling
tool like Erwin, you'd have to set up the PK, FK etc in the logical
model... Just don't push it out to the physical database
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.co m...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.

Diagrams a tool anyone can recommend

Hi want to produce a DB diagram on MSQSL 2000.
all I want to do is create links which exist diagrammatically only.
Instead as I UNDERSTAND it the SQL wants to physically create these
constraints on the DB. I DO NOT WANT THIS.
Pls don't answer that I should be using constraints, FK etcs. Not my
call and too late.
Is it possible to simply produce a diagram where I draw links between
fields without effecting underlying DB.
Is there a tool that will do this? Or should I just throw it into word
and make the links myself or use Visio. Preferably would like to
create diagram in MMSQL but which didn't change underlying DB.Itzik, shalom
I'm afraid you are not able to do that with SQL Server.
Perhaps , there are some third part software to be able to do it for you.
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.com...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.|||I generally use visio for this... But you could use any 3rd party modelling
tool like Erwin, you'd have to set up the PK, FK etc in the logical
model... Just don't push it out to the physical database
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.com...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.

Diagrams a tool anyone can recommend

Hi want to produce a DB diagram on MSQSL 2000.
all I want to do is create links which exist diagrammatically only.
Instead as I UNDERSTAND it the SQL wants to physically create these
constraints on the DB. I DO NOT WANT THIS.
Pls don't answer that I should be using constraints, FK etcs. Not my
call and too late.
Is it possible to simply produce a diagram where I draw links between
fields without effecting underlying DB.
Is there a tool that will do this? Or should I just throw it into word
and make the links myself or use Visio. Preferably would like to
create diagram in MMSQL but which didn't change underlying DB.Itzik, shalom
I'm afraid you are not able to do that with SQL Server.
Perhaps , there are some third part software to be able to do it for you.
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.com...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.|||I generally use Visio for this... But you could use any 3rd party modelling
tool like Erwin, you'd have to set up the PK, FK etc in the logical
model... Just don't push it out to the physical database
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.com...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.|||I have used Erwin for several years. I have created
diagrams of what the database I am working on should look
like when I am done with it. Just reverse engineer it and
make all the connections.
Gary.
>--Original Message--
>Hi want to produce a DB diagram on MSQSL 2000.
>all I want to do is create links which exist
diagrammatically only.
>Instead as I UNDERSTAND it the SQL wants to physically
create these
>constraints on the DB. I DO NOT WANT THIS.
>Pls don't answer that I should be using constraints, FK
etcs. Not my
>call and too late.
>Is it possible to simply produce a diagram where I draw
links between
>fields without effecting underlying DB.
>Is there a tool that will do this? Or should I just throw
it into word
>and make the links myself or use Visio. Preferably would
like to
>create diagram in MMSQL but which didn't change underlying DB.
>.
>

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?
Thanks
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
>
|||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...
>
|||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...[vbcol=seagreen]
> 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...
then
>
|||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...[vbcol=seagreen]
> 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...
database.[vbcol=seagreen]
> then
message[vbcol=seagreen]
the
>

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
> > > >
> > > >
> > >
> > >
> >
> >
>

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...
>|||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...
then[vbcol=seagreen]
>|||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...
database.[vbcol=seagreen]
> then
message[vbcol=seagreen]
the[vbcol=seagreen]
>

Diagramming Error?

I am using the April CTP.

I created a diagram. Via the diagramming tool, I added a new table. Added some columns. Decided I didn't like it. Deleted the table from the database.

Later I decided I did want the table. So I tried to create it again, but the diagram tool said that the table is make for deletion and couldn't be added. I looked at the table list and it was not there.

What can I do so that I can create another table with the same name?Hi Jim,
I could reproduce your results if I deleted the table before saving the diagram. Essentially the table never gets added to the database, but the diagram tool has the name recorded somewhere and that cache isn't getting cleared. I've filed a bug on your behalf for this incorrect behavior.

As a work around, you should be able to reuse the table name if you close SQL Server Management Studio, reopen SSMS and then modify the diagram.|||Thank you!

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/Criteria/SQL panes

Is there any way that I can always show the diagram, criteria and sql panes when I do "open table"?

It's not configurable in SQL Server Management Studio. In Visual Studio, you can go to Tools -> Options -> Database Tools -> Query and View Designer to customize it.

You can also toggle each pane quickly by pression CTRL+1 (diagram), CTRL+2 (criteria), CTRL+3 (SQL) and CTRL+4 (results).

|||That's a real shame. It seems such a waste to have to toggle those on each and every time, especially since it would have been such a small thing to add in the program (alongside remembering the size of each of the panes).

I like the SQLSMS in general, but all these little things make it so much less enjoyable to work with then it should have been.

Diagram, sorting and series groups

Say you have two values for each region: current month and previous month. I
have a column in datase called period_offset (0 for current month and -1 for
previous month).
I want to sort the diagram over current month, where previous month is just
for informational purposes (previous month is also colored gray, btw).
For series group, I have =Fields!period_offset.Value, and under sorting:
=Fields!period_offset.Value.
Currently, the diagram seem to sort by the previous month value (where
=Fields!period_offset.Value = -1). How can I sort by current month
(=Fields!period_offset.Value = 0) ?
Thanks
TiborWhere I say "Diagram", I'm referring to the chart control, btw.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uC169yjmEHA.3396@.tk2msftngp13.phx.gbl...
> Say you have two values for each region: current month and previous month.
I
> have a column in datase called period_offset (0 for current month and -1
for
> previous month).
> I want to sort the diagram over current month, where previous month is
just
> for informational purposes (previous month is also colored gray, btw).
> For series group, I have =Fields!period_offset.Value, and under sorting:
> =Fields!period_offset.Value.
> Currently, the diagram seem to sort by the previous month value (where
> =Fields!period_offset.Value = -1). How can I sort by current month
> (=Fields!period_offset.Value = 0) ?
> Thanks
> Tibor
>|||It seems like the order for the rows are determined from the order returned
in the SQL Query. When I add an ORDER BY to the query so that for each
region, that current month is returned before last month, the diagram is
sorted over the current month column.
I can change ASC/DESC in my SQL ORDER BY and the sort in the diagram changes
accordingly...
Is above assumption correct?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u%23te0gkmEHA.644@.tk2msftngp13.phx.gbl...
> Where I say "Diagram", I'm referring to the chart control, btw.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:uC169yjmEHA.3396@.tk2msftngp13.phx.gbl...
> > Say you have two values for each region: current month and previous
month.
> I
> > have a column in datase called period_offset (0 for current month and -1
> for
> > previous month).
> >
> > I want to sort the diagram over current month, where previous month is
> just
> > for informational purposes (previous month is also colored gray, btw).
> >
> > For series group, I have =Fields!period_offset.Value, and under sorting:
> > =Fields!period_offset.Value.
> >
> > Currently, the diagram seem to sort by the previous month value (where
> > =Fields!period_offset.Value = -1). How can I sort by current month
> > (=Fields!period_offset.Value = 0) ?
> >
> > Thanks
> > Tibor
> >
> >
>|||Unless you define an explicit sort expression on the chart series grouping
or the chart or the dataset, the data will be processed and grouped in RS in
the order they come from the data provider.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uwo5nkkmEHA.1652@.TK2MSFTNGP09.phx.gbl...
> It seems like the order for the rows are determined from the order
returned
> in the SQL Query. When I add an ORDER BY to the query so that for each
> region, that current month is returned before last month, the diagram is
> sorted over the current month column.
> I can change ASC/DESC in my SQL ORDER BY and the sort in the diagram
changes
> accordingly...
> Is above assumption correct?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:u%23te0gkmEHA.644@.tk2msftngp13.phx.gbl...
> > Where I say "Diagram", I'm referring to the chart control, btw.
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
> > message news:uC169yjmEHA.3396@.tk2msftngp13.phx.gbl...
> > > Say you have two values for each region: current month and previous
> month.
> > I
> > > have a column in datase called period_offset (0 for current month
and -1
> > for
> > > previous month).
> > >
> > > I want to sort the diagram over current month, where previous month is
> > just
> > > for informational purposes (previous month is also colored gray, btw).
> > >
> > > For series group, I have =Fields!period_offset.Value, and under
sorting:
> > > =Fields!period_offset.Value.
> > >
> > > Currently, the diagram seem to sort by the previous month value (where
> > > =Fields!period_offset.Value = -1). How can I sort by current month
> > > (=Fields!period_offset.Value = 0) ?
> > >
> > > Thanks
> > > Tibor
> > >
> > >
> >
> >
>|||Thanks Robert. This is in line with what I have experienced.
In this particular situation, I just couldn't get RS to sort the way I wanted...
But I did manage when combining sorting on Group/Series and in the SQL query. I'll probably stick
with what I have until I have the time to learn enough about sorting and the relation between
sorting in grouping vs. series.
I found the documentation lacking information rather severely in this area, I should add. And it
just wasn't intuitive enough for me. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23u3BxyzmEHA.2140@.TK2MSFTNGP11.phx.gbl...
> Unless you define an explicit sort expression on the chart series grouping
> or the chart or the dataset, the data will be processed and grouped in RS in
> the order they come from the data provider.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:uwo5nkkmEHA.1652@.TK2MSFTNGP09.phx.gbl...
>> It seems like the order for the rows are determined from the order
> returned
>> in the SQL Query. When I add an ORDER BY to the query so that for each
>> region, that current month is returned before last month, the diagram is
>> sorted over the current month column.
>> I can change ASC/DESC in my SQL ORDER BY and the sort in the diagram
> changes
>> accordingly...
>> Is above assumption correct?
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
>> message news:u%23te0gkmEHA.644@.tk2msftngp13.phx.gbl...
>> > Where I say "Diagram", I'm referring to the chart control, btw.
>> >
>> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in
>> > message news:uC169yjmEHA.3396@.tk2msftngp13.phx.gbl...
>> > > Say you have two values for each region: current month and previous
>> month.
>> > I
>> > > have a column in datase called period_offset (0 for current month
> and -1
>> > for
>> > > previous month).
>> > >
>> > > I want to sort the diagram over current month, where previous month is
>> > just
>> > > for informational purposes (previous month is also colored gray, btw).
>> > >
>> > > For series group, I have =Fields!period_offset.Value, and under
> sorting:
>> > > =Fields!period_offset.Value.
>> > >
>> > > Currently, the diagram seem to sort by the previous month value (where
>> > > =Fields!period_offset.Value = -1). How can I sort by current month
>> > > (=Fields!period_offset.Value = 0) ?
>> > >
>> > > Thanks
>> > > Tibor
>> > >
>> > >
>> >
>> >
>>
>|||Regarding BOL:
Yes, our UE/documentation team is working on improving the entire charting
documentation. Updates should be available on MSDN in the next few months.
Regarding sorting:
Grouping/sorting specified in the commandtext is done on the data source's
database server. Grouping/sorting/filtering defined in the RDL is done in
the RS processing engine internally.
If you specify a sort expression on group expressions in the report, the
processing engine will apply sorting. I.e. if you don't specify any explicit
collation settings on the RDL dataset, we will - in case of a live execution
against a SQL 2000 data source - determine the collation settings from the
data source. Otherwise, we will do sorting based on the culture settings of
the report.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e3fKkA1mEHA.2140@.TK2MSFTNGP11.phx.gbl...
> Thanks Robert. This is in line with what I have experienced.
> In this particular situation, I just couldn't get RS to sort the way I
wanted...
> But I did manage when combining sorting on Group/Series and in the SQL
query. I'll probably stick
> with what I have until I have the time to learn enough about sorting and
the relation between
> sorting in grouping vs. series.
> I found the documentation lacking information rather severely in this
area, I should add. And it
> just wasn't intuitive enough for me. :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:%23u3BxyzmEHA.2140@.TK2MSFTNGP11.phx.gbl...
> > Unless you define an explicit sort expression on the chart series
grouping
> > or the chart or the dataset, the data will be processed and grouped in
RS in
> > the order they come from the data provider.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> > message news:uwo5nkkmEHA.1652@.TK2MSFTNGP09.phx.gbl...
> >> It seems like the order for the rows are determined from the order
> > returned
> >> in the SQL Query. When I add an ORDER BY to the query so that for each
> >> region, that current month is returned before last month, the diagram
is
> >> sorted over the current month column.
> >>
> >> I can change ASC/DESC in my SQL ORDER BY and the sort in the diagram
> > changes
> >> accordingly...
> >>
> >> Is above assumption correct?
> >>
> >>
> >> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote
> > in
> >> message news:u%23te0gkmEHA.644@.tk2msftngp13.phx.gbl...
> >> > Where I say "Diagram", I'm referring to the chart control, btw.
> >> >
> >> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote
> >> in
> >> > message news:uC169yjmEHA.3396@.tk2msftngp13.phx.gbl...
> >> > > Say you have two values for each region: current month and previous
> >> month.
> >> > I
> >> > > have a column in datase called period_offset (0 for current month
> > and -1
> >> > for
> >> > > previous month).
> >> > >
> >> > > I want to sort the diagram over current month, where previous month
is
> >> > just
> >> > > for informational purposes (previous month is also colored gray,
btw).
> >> > >
> >> > > For series group, I have =Fields!period_offset.Value, and under
> > sorting:
> >> > > =Fields!period_offset.Value.
> >> > >
> >> > > Currently, the diagram seem to sort by the previous month value
(where
> >> > > =Fields!period_offset.Value = -1). How can I sort by current month
> >> > > (=Fields!period_offset.Value = 0) ?
> >> > >
> >> > > Thanks
> >> > > Tibor
> >> > >
> >> > >
> >> >
> >> >
> >>
> >>
> >
> >
>

Diagram, script and security ...

Three things:

1 - I attached a database from another computer in the Microsoft SQL Server Management Studio Express tool. It looks like my database diagrams did not follow.At first, it told me that the owner of the database was not set correctly and, hence, diagrams could not be supported. I ran the following query to fix that -> Alter authorization on database::DB_NAME to [MACHINE_NAME\USER]. Now, I can create new diagrams but I would like to see the ones I had before. How can I transfer my database files (.mdf and .ldf) with the diagrams?

2 – I would like to generate a database script that would not only create the table structure but also generate the insert statements to populate the database. When I use the “generate scripts” wizard, I don’t see an option where I could get the insert statements included in the script.Any help would be appreciated.

3 - I would like to read/find a short tutorial on how to set up security for my database. For now, I use the default user/security everywhere and I am sure it is not a good way of doing things. Basically, I would like to make sure I am not leaving a big security hole without having to read an entire book on SQL Server.Where could I get started?

Thanks a lot,

Dom.

1/ the diagrams should have come across with the database as they are stored in special tables, was this a SQL 2000 db that was upgraded by any chance?

2/ There is no way to generate insert statements in the UI today, there are some samples out in the community that can do it through.

3/ Have you read books on line?

|||

1 - No this is not a database upgrade, a SQL Server 2005 Express Edition to SQL Server 2005 Express Edition

2 - This is sad, there should be something to generate insert statements.

3 - Do you have any good ones to suggest?

thanks.

|||

Check out Securing your SQL Server Express Edition Server, it's from beta, but all the prinicples apply. You can also read the various pages of the BOL linked to from the Security Consideration for SQL Server topic.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

Diagram Tool Causes Strange Write Table Behavior

Using SQL Server 2000...
I'm creating a series of database diagrams for a database that has
~ 200 tables. The tables are segmented by module, so instead of
having one massive diagram I am creating a diagram per module.
All I'm doing is creating a new diagram, selecting all the tables
that belong to a module, and letting the software create the
diagram. I do make some format/layout changes to make the
diagram easier to read, but at no time am I making any structural
changes to the table.
For three of the four modules this approach has worked perfectly.
However, there is one set of tables that the tool thinks has been
altered, and it insists on writing the tables back to the database
before it will save it. The first time this happened I just said "No"
to any writing/saving and started over from scratch (I assumed I
had accidentally made a change to a table). The next time I added
all the module's tables, I simply moved one table two or three
inches to the left, and then tried to save the daigram (having 100%
confidence there were no accidental structural changes). Once
again, it wanted to write a few of the tables back to the database
before saving.
I have no idea why it thinks any structural changes occured to the
referenced tables. I certainly didn't make any, and on the rare
occasion I have accidentally made a change, I was able to
successfully start over by not writing/saving the change and
closing/opening the diagram.
Can anyone let me know what possible changes could have been
applied to a table(s) outside the diagram tool, that could affect the
diagram tool and make it think it needs to write the tables to the
database before saving?
ThanksHi Garth,
I don't know the answer to your question because I don't like, or use the
SQL Server diagramming tool - for the exact reason you're experiencing ...
changes to the diagram make changes to the database.
While I used to use ER/win (which is a fantastic tool), I've shifted to
Visio. Now, without the developer edition (I think that's the one) you can't
do a forward engineer, but you can reverse engineer any DB you can connect
to (ODBC, OLE DB, etc), it provides at least 80% of what matters in ER/win
(or Rational Rose) and you have the advantage that anyone with Visio can
read the file.
I admit it's going to be hard to learn it (as there is virtually no one on
the boards who know how), but I find it far, far superior to what is
available in SQL Server and more convenient than anything else.
Thanks,
Jay
"Garth Wells" <nobody@.nowhere.com> wrote in message
news:eQq7Mx1FIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Using SQL Server 2000...
> I'm creating a series of database diagrams for a database that has
> ~ 200 tables. The tables are segmented by module, so instead of
> having one massive diagram I am creating a diagram per module.
> All I'm doing is creating a new diagram, selecting all the tables
> that belong to a module, and letting the software create the
> diagram. I do make some format/layout changes to make the
> diagram easier to read, but at no time am I making any structural
> changes to the table.
> For three of the four modules this approach has worked perfectly.
> However, there is one set of tables that the tool thinks has been
> altered, and it insists on writing the tables back to the database
> before it will save it. The first time this happened I just said "No"
> to any writing/saving and started over from scratch (I assumed I
> had accidentally made a change to a table). The next time I added
> all the module's tables, I simply moved one table two or three
> inches to the left, and then tried to save the daigram (having 100%
> confidence there were no accidental structural changes). Once
> again, it wanted to write a few of the tables back to the database
> before saving.
> I have no idea why it thinks any structural changes occured to the
> referenced tables. I certainly didn't make any, and on the rare
> occasion I have accidentally made a change, I was able to
> successfully start over by not writing/saving the change and
> closing/opening the diagram.
> Can anyone let me know what possible changes could have been
> applied to a table(s) outside the diagram tool, that could affect the
> diagram tool and make it think it needs to write the tables to the
> database before saving?
> Thanks
>
>

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