It's a currency format That I use for NULL or 0.00, when it's zero it works fine, but when it's NULL it does not.

Fixed it like this:

SELECT NON EMPTY {

[Measures].[Measure1],

[Measures].[Measure2],

[Measures].[Measure3],

[Measures].[Measure4] } ON COLUMNS,

NON EMPTY { ([Segment].[CMkts].[Segment].ALLMEMBERS * [Ter].[Territories].[TK].ALLMEMBERS ) } ON ROWS FROM ( SELECT ( STRTOSET(@PERDN, CONSTRAINED) ) ON COLUMNS FROM (...

I believe the answer is that the Browser cache's the info so that the report does not have to go out to the Cube to get data and thus, no...

GUI and DB settings are as expected.

I have done manual runs atkleast 10 times and same results, Schedule must be Disabled to stop Job.

I'm absolutely sure about it. I ran a Trace on it.

if you make a proxy class with the changes you want, it will not get overwritten when you make changes. I have done this. Make a new class in a...

Am I missing something or does LINQ do this but better?

Yes actually, using SELECT instead of RETURN int he SP and setting the OUT param value to System.DbNull.Value in ADO when calling the SP fixed it.

I wish these error messages...

Yes, you're right. But I'm concerned about concurrency issues and the possibility of identical ID's being generated by multiple instances.

MS has an article: http://support.microsoft.com/kb/163446/ even on Guaranteeing unique...

No, that's the right setting. I have tried the others.

Thank you, however I think I will go the route or tracking my own ID's through this stored proc I wrote. It gives me the next ID for the requested...

Yes, my bad, I misunderstood, sorry. What you gave me originally is working very good. Thank you!

One other question, please, if you don't mind:

I noted that the SQL Identity...

Thanks so much, very kind of you.

One thing though, now I get a syntax error here:

CONSTRAINT FK_XXPARENT_CHILD FOREIGN KEY (XXSuiteID) REFERENCES XXParent(XXSuiteID)

Should this be inside one of the table scripts?...

Wow, that's crazy I'm doing this on SQL 200 SP3 QueryAnalyzer logged in as SA.

Like I said it works without error but the...

Thanks, but that doesn't do it. It just gives me the method's return result which is a long int.

I don't know, it seems so straight forward yet it ain't working.