Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

linkerserver

Status
Not open for further replies.
junkmail

junkmail

Programmer
Joined
Jan 7, 2001
Messages
134
Location
US
I have created a linked server in SQL Management Studio using an ODBC connection to a MYsql server in which I have read only access. When I am in SQL Manaement Studio I can query the tables in the database but I can't see the tables in object explore view. Is that something I can change in SQL Management Studio and if so how or do I need the DB admin to change a setting on their side?
 
Sort by date Sort by votes
You'll need to sweet-talk the admin. Rights to view metadata objects are a different animal from read rights on the tables.

-----------
With business clients like mine, you'd be better off herding cats.
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top