Openrowset issue

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Openrowset issue

Openrowset issue

Rate Topic

Display Mode

Topic Options

Author

Message

sqlbi.vvamsi

Posted Saturday, August 04, 2012 9:37 PM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 11:20 PM
Points: 50, Visits: 273

Hello,

I'm trying to fetch table data from Server B to a temp table in Server A. I didn't get entire data when I ran query below.

select * into temptbl from openrowset('SQLOLEDB','Data Source=Server B; Initial Catalog=DB;trusted_connection=yes;','select * from dbo.SrcTable')

To figure out where it is going wrong, I did count query to see how many rows it is fetching
when I run the below query from my local machine(client) I get less number of rows(count). when I run the same query directly on src machine it gives me exact count. Can someone tell me why and where am I losing data.

select count(*) from openrowset('SQLOLEDB','Data Source=Server B; Initial Catalog=DB;trusted_connection=yes;','select count(*) from dbo.SrcTable')

Note: I cannot use linked server.

Post #1340234

« Prev Topic | Next Topic »

Permissions