bluecjh
Programmer
- Mar 12, 2003
- 385
SQL SERVER 2005. (both remote and local)
a linked server (OLEDB provider for sql server) exists
which uses users current security context. I am sysadm
on both boxes.
A new database created on the remote server cannot be seen. I get the error
"The OLE DB provider "SQLNCLI" for linked server "mylinkedserver" does not contain the table ""database"."dbo"."table"". The table either does not exist or the current user does not have permissions on that table.
i.e. select * from server.database.dbo.table
errors
This is supported by the fact that under the list of catalogs the database in question is missing.
any ideas?
many thanks
BlueCJH
a linked server (OLEDB provider for sql server) exists
which uses users current security context. I am sysadm
on both boxes.
A new database created on the remote server cannot be seen. I get the error
"The OLE DB provider "SQLNCLI" for linked server "mylinkedserver" does not contain the table ""database"."dbo"."table"". The table either does not exist or the current user does not have permissions on that table.
i.e. select * from server.database.dbo.table
errors
This is supported by the fact that under the list of catalogs the database in question is missing.
any ideas?
many thanks
BlueCJH
