I have found this occurs after processing the cubes, restarting the service periodically cures the problem. You can set SQL Server to use x amount of memory in the server...

A few other questions, as someone mentioned this isn't the ideal and I have to put auditing into our applications sometime soon!

When designing from scratch is the auditing best...

SQL = SQL Server only, oledb = any db with oledb driver - replaced odbc (supports odbc too if only have older odbc drivers)

From what I remember I redeployed the reports and it was Ok.

Can also use pattern matching using a delimeter

i.e.

declare @x varchar(255)

set @x = '|a|b|c|' --this is the delimeted list youd pass into the stored procedure

select * from mytable where '%|' +...

Assuming you mean drillthrough options, the user needs ability to run drillthrough query (security option). To see which fields returned when drilling thro' just open the cube in the designer...

dont think you can (or need) to cross join with measures which is why initial query didnt work, generally cross join dimensions on rows and have measures on columns. descendants...

How about this string keys are to be avoided (not least because they become foreign keys), also the indexes will be larger and less efficient than integers. This method uses...

Seems like you/agent dont have the rights to run the job. Assuming your dts job is ok (i.e. you can run it in enterprise manager), the activex script runs as the agent...

From your posting I think you need to put a table (or two) within the table. The column you want to merge vertically can then be left as it is

e.g.

outer...

As far as I know the web service security is used to provide windows authentication for datasources is this what you mean? If you want anonymous access on top of this you...

This should work, assuming Sales is the database name not the cube you want to connect to?

Select oledb as the connection type

this is the connection string I use:

Provider=MSOLAP.2;Data Source=MISServer;Location=Sales;Initial Catalog=Sales;Client...

Could try embedding the username and password into the connection string? Another thing to try might be the SQLXML web service.

MySQL is free, the support etc. however costs extra I believe! Try these guys http://www.swissql.com/

could try this (will work with one match per row)

set nocount on

create table x ( t VARCHAR (100))

insert x (t) values ('This is a text')

insert x (t) values ('And this...