search for: openrowset

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...