Local Cubes in SS2005, specifically for the dev team

Hi,

A question on local cubes...

If I'm right in saying that if you use the CREATE CUBE statement to create a local cube using the MSOLAP.3 provider, that under the hood you will in fact still be using the MSOLAP.2 provider and hence creating AS2K local cubes, how will this tally with mainstream support for AS2K ending in 2008? Will these form of local cube cease to be supported at that time?

regards

Colin

No, your assumption is wrong - CREATE CUBE is sent to msolap90.dll and creates a AS2005 cube. It can't be opened with MSOLAP.2 provider.|||

Well I'm basing my assumption on the information in MDX Solutions, chapter 17, which in turn was based on information obtained directly from the development team

As I understand it, when the connection is made to the empty .cub file and the MSOLAP.3 provider sees the syntax CREATE CUBE and INSERT INTO, it automatically delegates the query to the MSOLAP80.dll which in turn creates an AS2K cube rather than an AS2005 one.

You only create an AS2005 cube if you use the CREATE GLOBAL CUBE syntax or ASSL.

regards

Colin

Local copy

Hi,
i have a Sqlserver 2000 database on a webserver. Now i want to move this
database to another provider (server). I have restricted access to the
database. What is the best way to retrieve all the data to a local pc ? What
i need is a sort of Backup to local pc. I have asked the provider to put
this on a cd-rom, but he refuse this.
GL.A quick way is to : create a database on a local server, transfer all
objects/data to the local server copy
Jack Vamvas
________________________________________
__________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"Grard Leclercq" <gerard.leclercq@.pas-de-mail.fr> wrote in message
news:UUNDf.225782$bM3.7399534@.phobos.telenet-ops.be...
> Hi,
> i have a Sqlserver 2000 database on a webserver. Now i want to move this
> database to another provider (server). I have restricted access to the
> database. What is the best way to retrieve all the data to a local pc ?
What
> i need is a sort of Backup to local pc. I have asked the provider to put
> this on a cd-rom, but he refuse this.
> GL.
>|||I know this issue, the same for my provider, the best is (as far as you
don=B4t store blob columns) to script the data out to a script file and
reapply the data to your destination database, This worked fine for me.
See this script here for more information:
http://vyaskn.tripod.com/code.htm#inserts
HTH, Jens Suessmeyer.|||Thank you, finally the provider have ask me 150 euro for a copy on CD. But
the next time i keep your advise in mind.
Thx - GL
"Jens" <Jens@.sqlserver2005.de> schreef in bericht
news:1138733350.602238.280700@.g44g2000cwa.googlegroups.com...
I know this issue, the same for my provider, the best is (as far as you
dont store blob columns) to script the data out to a script file and
reapply the data to your destination database, This worked fine for me.
See this script here for more information:
http://vyaskn.tripod.com/code.htm#inserts
HTH, Jens Suessmeyer.