I am working with 2 sql servers
Server A I do a select from
[serverb].[database_b].[dbo].[table_b] it returns 0 rows
However when I go directly to serverB
And do a select * from table_b it returns 20 rows .
Please advise
I am working with 2 sql servers
Server A I do a select from
[serverb].[database_b].[dbo].[table_b] it returns 0 rows
However when I go directly to serverB
And do a select * from table_b it returns 20 rows .
Please advise
On ServerB, try:
SELECT * FROM database_b.dbo.table_b
I need to select form serverA. To get results from serverB
Selecting from
ServerB is not the issue
I was trying to verify that the view within that specific db had rows. But never mind, good luck with this.
is serverb configured as a linked server?
Yes Iinked server is created
do what @ScottPletcher recommended
select * from [database_b].[dbo].[table_b]
yeah Selecting from ServerB is not the issue but it will help us help you