--=_NextPart_000_0034_01C86DA3.377E73B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi All,
I am have created a linked server in MS SQL 2000 to Sage Line 50v12 = using the ODBC drivers in sage.I am able to view all the tables once I = clicked on the link server link in the SQL enterprise manager. However = when I run the below query I get only one records instead of 28.
SELECT * FROM OPENQUERY(SageL50, 'SELECT * from Sales_Ledger')
I am running SQL 2000 server with SP4
From the SQL online documentation I got to know that OPENQUERY returns = only a single record. Is there any other function/command that will = enable me to get all the records from a table from a linked server?
Can you let me know I am missing here?
Thanks and Regards,
Saurabh
--=_NextPart_000_0034_01C86DA3.377E73B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi All,
I am have created a linked server in = MS SQL 2000 to = Sage Line 50v12 using the ODBC drivers in sage.I am = able to view all the tables once I clicked on the link server link in the SQL = enterprise manager. However when I run the below query I get only one records = instead of 28.
SELECT * FROM OPENQUERY(SageL50, = 'SELECT * from Sales_Ledger')
I am running SQL 2000 server with SP4
From the SQL online documentation I = got to know that OPENQUERY returns only a single record. Is there any other = function/command that will enable me to get all the records from a table from a linked server?
Can you let me know I am = missing here?
Thanks and Regards,
Saurabh
--=_NextPart_000_0034_01C86DA3.377E73B0--This is a multi-part message in MIME format.
--=_NextPart_000_000F_01C86EEC.F996B580
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
Any updates on the below query.
Thanks and Regards,
Saurabh
"news" <news@.microsoft.com> wrote in message =news:%23b2csSXbIHA.484@.TK2MSFTNGP06.phx.gbl...
Hi All,
I am have created a linked server in MS SQL 2000 to Sage Line 50v12 =using the ODBC drivers in sage.I am able to view all the tables once I =clicked on the link server link in the SQL enterprise manager. However =when I run the below query I get only one records instead of 28.
SELECT * FROM OPENQUERY(SageL50, 'SELECT * from Sales_Ledger')
I am running SQL 2000 server with SP4
From the SQL online documentation I got to know that OPENQUERY returns =only a single record. Is there any other function/command that will =enable me to get all the records from a table from a linked server?
Can you let me know I am missing here?
Thanks and Regards,
Saurabh
--=_NextPart_000_000F_01C86EEC.F996B580
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi,
Any updates on the below =query.
Thanks and Regards,
Saurabh
"news"
Hi All,
I am have created a linked server =in MS SQL 2000 =to Sage Line 50v12 using the ODBC drivers in =sage.I am able to view all the tables once I clicked on the link server link in =the SQL enterprise manager. However when I run the below query I get only one =records instead of 28.
SELECT * FROM OPENQUERY(SageL50, ='SELECT * from Sales_Ledger')
I am running SQL 2000 server with SP4
From the SQL online documentation I =got to know that OPENQUERY returns only a single record. Is there any other function/command that will enable me to get all the records from a =table from a linked server?
Can you let me know I am =missing here?
Thanks and Regards,
Saurabh
--=_NextPart_000_000F_01C86EEC.F996B580--|||Did you try:
SELECT * FROM SageL50.<database>.<owner/schema>.Sales_Ledger
Replace <database> with the database that contains the table you want,
and the <owner/schema> with the owner of the table - generally dbo.
Example:
SELECT * FROM SageL50.db1.dbo.SalesLedger;
Jeff
news wrote:
> Hi,
> Any updates on the below query.
> Thanks and Regards,
> Saurabh
>
> "news" <news@.microsoft.com <mailto:news@.microsoft.com>> wrote in
> message news:%23b2csSXbIHA.484@.TK2MSFTNGP06.phx.gbl...
> Hi All,
> I am have created a linked server in MS SQL 2000 to Sage Line
> 50v12 using the ODBC drivers in sage.I am able to view all the
> tables once I clicked on the link server link in the SQL
> enterprise manager. However when I run the below query I get only
> one records instead of 28.
> SELECT * FROM OPENQUERY(SageL50, 'SELECT * from Sales_Ledger')
> I am running SQL 2000 server with SP4
> From the SQL online documentation I got to know that OPENQUERY
> returns only a single record. Is there any other function/command
> that will enable me to get all the records from a table from a
> linked server?
> Can you let me know I am missing here?
> Thanks and Regards,
> Saurabh
>
No comments:
Post a Comment