October 31, 2012 at 9:13 am
Hi there,
in our dev environment we have a SQL2000 server, several databases. This server is available as a linked server. When I create a new table in the database I expect to see this table in the linked server catalog.
When I create the same table in a SQL2005 server (same script) the linked server for this instance shows the table as soon as I refresh?
What do we need to do to add the table to the linked server tables? (If I try to select from the table the error is returned that the table does not exists or the permissions are not correct.)
Other tables that we can see have no special permissions set.
Stumped
October 31, 2012 at 10:01 am
Does the linked server use a login with the right permissions on that table? Hopefully, you're not using sa in your linked server connection (the Security tab will tell you what login you are using). Check if that login has limited rights. Perhaps rights granted on individual objects instead of on the whole database, or on the relevant schema.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 31, 2012 at 10:32 am
We have checked the security settings of the other tables and all settings are the same. There is no special permission set to the tables that are visible.
Is there a difference between 2000 and 2005?
(And no, we are not using sa 😉 )
As you mention we where thinking at the same lines, but can't see anything
October 31, 2012 at 10:55 am
Don't check the tables. Check the properties of the login you're using.
On the server you're linking to, use SETUSER as that login, and see if you can access the table from there.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply