Displaying 1 result from an estimated 1 matches for "sp_addlinkedserver".
2004 Jul 01
0
MS OLAP -- RODBC to SQL Server "Slice Server" pass-through query to MS OLAP
...g] 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 pass the MDX query and
return a resultset. The OPENQUERY function can be used in the "FROM
clause" of a SQL query,
a "stored procedure" or in MS SQL 2000 a "User Defined Function (UDF)."...