I have a machine which have 2 SQLServer instances
WINXP-PRO\SQLSERVER2000(SQL Server 2000)
WINXP-PRO\SQLEXPRESS(SQL Server 2005 Express Edition).
\SQLEXPRESS, I have database wavinet2 and wavinet2_mapic. In
\SQLSERVER2000, I create linked server to
[IP_ADDRESS]\SQLEXPRESS, the linked server is created.
All tables have shown up except for database
I provide the remote login using
sa. I try to select and it cannot found the table.
Any hint what is causing this problem?