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 |
|
rwaldron
Posting Yak Master
131 Posts |
 Posted - 2007-07-04 : 11:37:54
|
| Hi all,I've just started using the SQL 2005 Query Designer.Does anyone know if I can easily browse to a Linked server that exists in SQL or do I still have to add these linked tables a s derived tablesm like before using openquery?Ray.. |
|
|
pootle_flump
1064 Posts |
Posted - 2007-07-04 : 11:44:32
|
| If you can I would advise you learn to write SQL. You will have to some day and the less you get dependent on a query designer the sooner you will comfortable writing it.Anyway - strictly on the question I have no clue as I don't use the designer. Can you just edit the SQL and put in the table name using four part identification (servername.dbname.schemaname.tablename)? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-04 : 17:02:23
|
| You can't browser linked server in query designer as I know. |
|
|
|
|
|
|
SQL 2005 Query Designer - Linked Server