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 |
|
Fredforfree
Starting Member
49 Posts |
 Posted - 2009-09-11 : 07:55:29
|
Hi I am having difficulty with a simple select * between two servers.This is what i tried and it does not work.select * from [ressqlsource.int.Roger.ca].[dbo].[source_dialer].[dbo.view_isn_time]Any suggestions please?fredforfreeFred works now i just took the dbo out of [dbo.view_isn_time] |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-09-11 : 08:22:13
|
| select * from [ressqlsource.int.Roger.ca].[source_dialer].[dbo].[view_isn_time]MadhivananFailing to plan is Planning to fail |
 |
|
|
Fredforfree
Starting Member
49 Posts |
Posted - 2009-09-11 : 08:46:57
|
Thanks Madhivanan, i thought i had already tried that.quote:
Originally posted by madhivanan
select * from [ressqlsource.int.Roger.ca].[source_dialer].[dbo].[view_isn_time]MadhivananFailing to plan is Planning to fail
Fred |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-09-11 : 09:38:33
|
quote:
Originally posted by Fredforfree
Thanks Madhivanan, i thought i had already tried that.quote:
Originally posted by madhivanan
select * from [ressqlsource.int.Roger.ca].[source_dialer].[dbo].[view_isn_time]MadhivananFailing to plan is Planning to fail
Fred
You are welcome  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
select between two servers