September 10, 2008 at 4:14 am
Dear All,
Am working in sql server 2000. I added a linked server which is SQL server 2005 using 'sa' user. It got connected succesfullly and am able to see all the databases. But am able to see USER TABLES only in one database. In all other database am seeing only system tables.
Infact the database am seeing (with user tables) in linked server(2005) was restored from one of the database in the server am working (2000). I checked for all the logins. everything seems to be OK...anyways I connected using 'sa' login.
Wot should I do now..?. Pls help.
Regards,
Santhu.
September 10, 2008 at 4:22 am
I think this has to do with the schema. SQL Server 2005 uses schema instead of ownership.
The fully qualified names is somewhat like this
FOR SQL 2000
Server_name.catalog_name.Owner.Object_name
... just an opinion
For SQL Server 2005
Server_name.catalog_name.Schema_name.Object
Albert B. Matubis
Database Administrator: Trend Micro PH
MCP. MCAD. MCDBA. MCT
MCTS: SQL Server 2005
MCTS: Business Intelligence
MCITP: Database Administrator
MCITP: Business Intelligence Applications Developer
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply