Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Linked Server
Message
 
 
To
08/10/2002 13:34:20
Alvin Lourdes
Children and Youth Services Cluster
Toronto, Ontario, Canada
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Miscellaneous
Thread ID:
00708839
Message ID:
00708878
Views:
9
>I have used EM but I do not see databases.... just system tables...
>
>How would I expose a specific database?
>
>Al

You can use four part name to access tables on linked server.
SELECT * FROM LinkedServer.DataBase.Owner.Table
In EM you'll see tables from default DB for the loging name you use for linked server.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform