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 |
|
Devin
Starting Member
1 Post |
 Posted - 2007-06-25 : 13:23:06
|
| Okay, i am attempting to run a query with a full path inside of it. Such as:SELECT * FROM [Server\Instance Name].[Database].[Owner].[Table] The problem is it runs an a query whom eventually times out, and never fully executes. However, if i run:SELECT * FROM [Database].[Owner].[Table] It works just fine.... Does anyone have any idea as to why this is? Thanks in advance for your help |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-25 : 22:34:20
|
| Create linked server to [Server\Instance Name] and query via linked server. |
 |
|
|
|
|
|
Full Instance Path executes Indefinate Query. HELP