Database architecture

Hello,
I am new in database administration, I have a SQL 2000 database on server. I
need to see the architecture/design of the current running database. Is there
any tool or way to find or see the database architecture/design, so that I
can easily figure out the relations between different tables and understand
the database design.
Thanks in advance,
Leo
Use "Create Database Diagram Wizard". Add all user tables into it, which will
give you a digramatic representation of the same. Hope this will help!!!
Thanks,
Sree
"Leo_Surf" wrote:

> Hello,
> I am new in database administration, I have a SQL 2000 database on server. I
> need to see the architecture/design of the current running database. Is there
> any tool or way to find or see the database architecture/design, so that I
> can easily figure out the relations between different tables and understand
> the database design.
> Thanks in advance,
> Leo
|||Thanks Sree..
will I be able to see/understand database schema from the diagrams? or there
is any other way to do that? because in diagrams I am not able to see the
relationship betewwn the tables.
Thanks in advance...
Leo
"Sreejith G" wrote:
[vbcol=seagreen]
> Use "Create Database Diagram Wizard". Add all user tables into it, which will
> give you a digramatic representation of the same. Hope this will help!!!
> Thanks,
> Sree
> "Leo_Surf" wrote:
|||Leo_Surf wrote:

> Thanks Sree..
> will I be able to see/understand database schema from the diagrams? or there
> is any other way to do that? because in diagrams I am not able to see the
> relationship betewwn the tables.
> Thanks in advance...
> Leo
>
The diagram should show relationships as long as the foreign keys
exist. Do they exist or are they missing from the diagram because they
aren't there? Use the Object Browser in Query Analyzer to check that
the foreign key constraints you expected are not missing.
Unfortunately Enterprise Manager's diagrams are extremely poor. They
don't use any of the proper notation for keys. They also don't easily
scale, print or embed in other documents. For any serious work you'll
want to consider using a different tool for diagrams such as Microsoft
Visio or ERwin.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx

Database architecture

Hello,
I am new in database administration, I have a SQL 2000 database on server. I
need to see the architecture/design of the current running database. Is ther
e
any tool or way to find or see the database architecture/design, so that I
can easily figure out the relations between different tables and understand
the database design.
Thanks in advance,
LeoUse "Create Database Diagram Wizard". Add all user tables into it, which wil
l
give you a digramatic representation of the same. Hope this will help!!!
Thanks,
Sree
"Leo_Surf" wrote:

> Hello,
> I am new in database administration, I have a SQL 2000 database on server.
I
> need to see the architecture/design of the current running database. Is th
ere
> any tool or way to find or see the database architecture/design, so that I
> can easily figure out the relations between different tables and understan
d
> the database design.
> Thanks in advance,
> Leo|||Thanks Sree..
will I be able to see/understand database schema from the diagrams? or there
is any other way to do that? because in diagrams I am not able to see the
relationship betewwn the tables.
Thanks in advance...
Leo
"Sreejith G" wrote:
[vbcol=seagreen]
> Use "Create Database Diagram Wizard". Add all user tables into it, which w
ill
> give you a digramatic representation of the same. Hope this will help!!!
> Thanks,
> Sree
> "Leo_Surf" wrote:
>|||Leo_Surf wrote:

> Thanks Sree..
> will I be able to see/understand database schema from the diagrams? or the
re
> is any other way to do that? because in diagrams I am not able to see the
> relationship betewwn the tables.
> Thanks in advance...
> Leo
>
The diagram should show relationships as long as the foreign keys
exist. Do they exist or are they missing from the diagram because they
aren't there? Use the Object Browser in Query Analyzer to check that
the foreign key constraints you expected are not missing.
Unfortunately Enterprise Manager's diagrams are extremely poor. They
don't use any of the proper notation for keys. They also don't easily
scale, print or embed in other documents. For any serious work you'll
want to consider using a different tool for diagrams such as Microsoft
Visio or ERwin.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

Database Access

I run several DTS Packages that load databases residing on two seperate
instances of SQL Server 2000 on the same server. For security reasons, I
need to be able to set the Databases on one instance to Read/Write access,
set the database access on the other instance to Read only, run the packages
on the first instance, and then reset the access to Read Only. The ideal
solution would be writing the logic in T-SQL in a stored procedure that is
already part of the Package or add a new stored procedure to the package. I
have not been able to find any reference to setting the Database access in
code. I would appreciate and welcome any advise on how to accomplish this
programming task. Thank you.
grp
Have a look at sp_dboption in bol.
You might be better off creating roles with the correct permissions and
moving the user between those roles.
"PGene2" wrote:

> I run several DTS Packages that load databases residing on two seperate
> instances of SQL Server 2000 on the same server. For security reasons, I
> need to be able to set the Databases on one instance to Read/Write access,
> set the database access on the other instance to Read only, run the packages
> on the first instance, and then reset the access to Read Only. The ideal
> solution would be writing the logic in T-SQL in a stored procedure that is
> already part of the Package or add a new stored procedure to the package. I
> have not been able to find any reference to setting the Database access in
> code. I would appreciate and welcome any advise on how to accomplish this
> programming task. Thank you.
> --
> grp
|||Thanks. This at least gives me a couple of directions to go in. I appreciate
the help.
grp
"Nigel Rivett" wrote:
[vbcol=seagreen]
> Have a look at sp_dboption in bol.
> You might be better off creating roles with the correct permissions and
> moving the user between those roles.
>
> "PGene2" wrote:

Database Access

I run several DTS Packages that load databases residing on two seperate
instances of SQL Server 2000 on the same server. For security reasons, I
need to be able to set the Databases on one instance to Read/Write access,
set the database access on the other instance to Read only, run the packages
on the first instance, and then reset the access to Read Only. The ideal
solution would be writing the logic in T-SQL in a stored procedure that is
already part of the Package or add a new stored procedure to the package. I
have not been able to find any reference to setting the Database access in
code. I would appreciate and welcome any advise on how to accomplish this
programming task. Thank you.
grpHave a look at sp_dboption in bol.
You might be better off creating roles with the correct permissions and
moving the user between those roles.
"PGene2" wrote:

> I run several DTS Packages that load databases residing on two seperate
> instances of SQL Server 2000 on the same server. For security reasons, I
> need to be able to set the Databases on one instance to Read/Write access,
> set the database access on the other instance to Read only, run the packag
es
> on the first instance, and then reset the access to Read Only. The ideal
> solution would be writing the logic in T-SQL in a stored procedure that is
> already part of the Package or add a new stored procedure to the package.
I
> have not been able to find any reference to setting the Database access in
> code. I would appreciate and welcome any advise on how to accomplish this
> programming task. Thank you.
> --
> grp|||Thanks. This at least gives me a couple of directions to go in. I appreciat
e
the help.
--
grp
"Nigel Rivett" wrote:
[vbcol=seagreen]
> Have a look at sp_dboption in bol.
> You might be better off creating roles with the correct permissions and
> moving the user between those roles.
>
> "PGene2" wrote:
>