Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 systables master all 12 REMOTE_FOO_FOO

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-05-30 : 08:48:10
gallush writes "TRYING TO GET INFO ON THE 12 REMOTE_........._...... TABLES IN THE MASTER(2000)
my problem is i mayed a sp_ that get count(*) from all tables
an its get in the @tabelname
and i call it from acursor with all my names
and get the 12 remote_ ask for serever parameter
(i can imagin this is the remote server(domie- i dont have any)
any way im running on alocal server trying to select * from one of this .myservername @@servername just not working
what i need is any info on this 12 tables
thanks
gallush"
   

- Advertisement -