Because of external applications we can't use transactions, what seems to be used for sp_getapplock.

Can a global var be set?

Yes, that was the problem!

I'm not close to MDX yet, but I see this is essential for analysing.

Thanks a lot.

The sql server profiler shows:

WITH MEMBER [Measures].[-DimBrowseLevelKey 0-] AS '[Dim Konto].[Konto].currentmember.properties("key0", TYPED)'

SELECT { [Measures].[-DimBrowseLevelKey 0-] } ON 0,

Head( [Dim Konto].[Konto].[Konto].Children, 1000) ON 1

FROM [$Dim Konto]

CELL PROPERTIES VALUE

PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis" (<> removed...

Made a separate dimension for the table view(may mixing was not good), but now I get a missing attribute error because the fact table has more keys than the filtered...

The same db, so the name is like cosy_backup_200711182200.bak what is over 2 days old but isn't deleted.

Ok, habent seen this task.

So the files are only overwritten if not enough space is available on disc?

No denied permission, also tried with sa, same result.

Must security be configured by SQL Server surface configuration?

Could find it in the help, thanks.

Also you can set the Default_Database. But what about the database role or the system role?

Hi Andreas

This link address could not be found. Do you have another one?

Thanks

Jan

Your solution works.

The table does not have keys because of the origin data, not a good thing but I can't change it.

So first I group the data having count(*) >...

Two tables dbo.flightinfo and #duplicaterow with the same columns to eliminate duplicate rows.

The query looks like:

select b.company, b.airline_nr, b.awb, b.part_shipment, b.nr_1, b.from_destcode, b.to_destcode, b.mode, b.flight_1, b.flight_2, b.start_date, b.end_date, b.end_destcode, b.statuscode, b.pieces,...

Can I get the values from the sp_spaceused without changing the sp?

Because there are no values declared as output.

Thanks, Jan 

So then a non-clustered index holds data, unlike in the book explained?

Hi Dick

We are on SP2 with hotfix.

The retention time of the distributor was limited to 72 hours, so we put it much higher. It seems to work but we are...

Hope you can read the data in this form:

From table imp_beschr (import description):

beschr_id datum sprache_id subtyp...