Cant be possible in a single query in SQL 2000, you have to use loop  or a temp table.

I am a big fan of Bill Gates. With limited knowledge of his business style. I feel he is doing a great job. Go Bill !!!!!

You can custom write a proc or use sp_depend "<Table Name>".

Points to remeber :

Cross database joins.

Dynamic Query.

* is the column list.

If you have written query in Jobs.

Written queries in...

Be very careful if you have hard-coded references to Server. Transferring them will not change the server name. Things can be ugly if you execute them

Can I change this through Query Analyser.

I mean the table which need to push to all the servers

I feel you can manage that in several ways. What is the size of you table and are the same in same location (I meant how good is your network...

Thanks Steve for the update. if we get SQL 2005 in year 2005. I will be happy and 3 cheers to MICROSOFT

check the owner of the object

by default on default instance the port is 1433. If you want to find the port on multiple instance. Run the below query

DECLARE @key VARCHAR(100)

DECLARE @PortNumber VARCHAR(20)

SET @key...

This is happening in Transaction Replication.

I learn every hour

I change the server setting to send as a pure update instead of INSERT/DELETE pair but I want to learn...

Had this problem for one of my client. Spent 3 days to determine the problem. There can be several reasons for this error. Let us know whether this problem occurs ever time...

http://support.microsoft.com/kb/238254/EN-US/

thank you. now I can customize them