did you even bothered reading the manual?

https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkident-transact-sql?view=sql-server-ver15

interesting and a good example for SSIS - but does not catch all cases, neither addresses the real issue that is that the file was badly created and is therefore...

this may help you https://docs.microsoft.com/en-us/analysis-services/analysis-services-backward-compatibility

regarding multidimensional only mentions are that these 2 are deprecated

• Data Mining
• Remote linked measure groups

and these were discontinued

• Remote partitions
• Remote linked measure groups
• Dimensional...

I never did figure out why it would work in one place and then not installed on the server.   I'm still thinking there is potentially a permissions issue.   I...

• This reply was modified 6 years, 6 months ago by frederico_fonseca.

code here instead of word doc - easier for most to see

one thing i would change is the fact that the code, if the record does not exist already, does...

Ola's code is, indeed, the "Gold...

Hi frederico_fonseca, thank you for your reply. Actually I can explain this to my management and they would probably accept it as useful information. I believe your advise is...

a update that does not update any row is not an exception so the code is behaving correctly.

examples of what and exception would be are

• divide by zero
• insert of...

I think you do need to dig further and explain to them that a SSIS Catalog Environment equates to a xmlconfig file on the filesystem.

this makes it possible to have...

most likely permissions.

as this is on your PC first thing to try is to run SSMS as administrator - just to confirm that it is indeed permissions of your user

and...

Mona,

the insert-update block does not do the update itself - just inserts the rows that need to be updated onto a a staging table, and then the "apply staged updates"...

you should then do yourself a favor and search for outer apply examples and study them.

they are incredibly powerful and know how to use them is a must for a...

something like this should do the trick.

the "allow" column returned by the SQL you only use for validation, and do not show on your page.

If for some reason for a...

we would need the explain plan file itself, not images of it.

Frederico your code works!

Apparently somebody pointed sources to linked server to PRODUCTION (Damn.. I think that's why i wasn't getting a match for  five days!..) And that's why function...