MS SQL Server - sp_tables_ex returns less than 1/2 the tables it should?

Author

sp_tables_ex returns less than 1/2 the tables it should?

Seattle86 via SQLMonster.com

2005-10-12, 11:23 am

Microsoft SQL Server 2000 - 8.00.892 (Intel X86) Dec 5 2003 13:58:42
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)

Running sp_tables_ex against a linked server returns 70 tables. However when
I logon to the remote server via Query Analyzer, I can see 219 tables!! This
is using the same account for both Query Analyzer and the linked table.

What would cause more than half the tables to disappear from the linked table?

Jerry Spivey

2005-10-12, 11:23 am

Check the owner of the tables - is it a different owner? Does the user
account used have SELECT permissions on the tables? Ensure you are
connecting to the same SQL Server and the same database (i.e., not a test
copy).

HTH

Jerry
"Seattle86 via webservertalk.com" <u14810@uwe> wrote in message
news:55b7f6a9ae357@u
we...
> Microsoft SQL Server 2000 - 8.00.892 (Intel X86) Dec 5 2003 13:58:42
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on
> Windows
> NT 5.2 (Build 3790: Service Pack 1)
>
> Running sp_tables_ex against a linked server returns 70 tables. However
> when
> I logon to the remote server via Query Analyzer, I can see 219 tables!!
> This
> is using the same account for both Query Analyzer and the linked table.
>
> What would cause more than half the tables to disappear from the linked
> table?
>

Sponsored Links