Displaying 1 result from an estimated 1 matches for "openrowset".
Did you mean:
openrowley
2004 Jul 01
0
MS OLAP -- RODBC to SQL Server "Slice Server" pass-through query to MS OLAP
...foreign data base's syntax). That way "MDX is executed on the
OLAP server, and not locally
in SQL Server." Chipman & Baron, p. 645 -- which would accomplish your
objective of "[Keeping] the data
intensive tasks on the DB server side."
Although you can use the MS SQL OPENROWSET() function to set up an ad hoc
connection, the
recommended method would be two steps:
1. Set up a Linked Server using either MS SQL Enterprise Manager or
MS SQL system stored procedure EXEC sp_addlinkedserver.
2. Use an OPENQUERY() function (which works with any OLE DB data source)
to pas...