Accessing the name of all the related tables name

Hi Everyone,

I would like to ask a question, Is there any way or tool available in the sql server 2000, that tells the user, how many tables contains the same column name (such as Col_N, is a primary key and I want to know all the table names that have the same Foreign key (COL_N)).

If anybody knows that, pls help me.

Thanking you

Gaurav

Using SQL 2000, you may wish to examine the Information_Schema views for a list of which tables contain a particular column, such as:

SELECT Table_Name
FROM Information_Schema.Columns
WHERE Column_Name = @.x

accessing remote sql server 2000 ( enterprise manager like tool)

Hi all,

I need to gain access to a remote SQL Server 2000 storing my data.
The remote SQL machine can only be accessed via an internet connection,
that is - it is not part of my network.

I know Enterprise Manager can do the job, but EM only comes bundled in
MS SQL Server, which is not installed on the client machine.

Please let me know which other (preferably free) tools can perform
such remote access.

Thanks,
Gilad HaimovOn 25 Oct 2003 03:36:11 -0700, giladha@.hotmail.com (gilad) wrote:

>Hi all,
>I need to gain access to a remote SQL Server 2000 storing my data.
>The remote SQL machine can only be accessed via an internet connection,
>that is - it is not part of my network.
>I know Enterprise Manager can do the job, but EM only comes bundled in
>MS SQL Server, which is not installed on the client machine.
>Please let me know which other (preferably free) tools can perform
>such remote access.
>Thanks,
>Gilad Haimov
In theory anything that can attach to a database, VB MS-Access Fxopro
etc etc. More of a problem would be is the database directly
accessible from the internet at all? I would have thought this was a
very bad idea.