Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2008-06-09 : 09:40:35
|
| How can I use SSMS to display and query an Access database tables.I can see all the tables when I use a Visual studio dataset designer tool, But i want to be able to do that using SSMS.Any idea, pls?thank you very much :) |
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-06-09 : 09:44:26
|
| By using linked server you can.ManojMCP, MCTS |
 |
|
|
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2008-06-09 : 13:07:06
|
quote:
Originally posted by mdubey
By using linked server you can.ManojMCP, MCTS
Can I see the list of all tables. How please? |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-06-09 : 15:29:59
|
| You will only be able to use the GUI portions of SSMS with SQL Servers. You can query Oracle, but it will be all with text. Oracle markets its own Enterprise Manager. |
|
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-06-09 : 16:06:40
|
quote:
Originally posted by rtutus
quote:
Originally posted by mdubey
By using linked server you can.ManojMCP, MCTS
Can I see the list of all tables. How please?
You should be able to see all Tables and views with the help of linked server. You just need to expand the server object and under that you are there.ManojMCP, MCTS |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-09 : 22:48:15
|
| >> Can I see the list of all tables. How please? If you just like to see Orace tables, better to use Oracle client tool. |
|
|
|
|
|
|
Accessing Oracle DB from SSMS