Just out of curiosity, in which database would the function be stored in. would it be master (not recommended), or one of the user databases?

the reason it probably works as...

But I still have the problem:

as login works:

execute as LOGIN = 'xxx_admin'

select [admin].[fn_db_get_sqltext] (1)

revert

but as USER works not.

execute as USER = 'xxx_admin'

select [admin].[fn_db_get_sqltext] (1)

revert

No!

Msg 297, Level 16, State 1, Line 4

The user does not have permission to perform this action.

I had added the folliwing permissions to the login:

use master

grant view server state to...

No, i want to execute as the Login, not as the User. Accordingly BOL i had to specify the keyword LOGIN, or?

<context_specification>::=

{ LOGIN | USER } = 'name'

...

That are good points. I will try. Thank you

If I understand your requirements, you would need a foreign key, that refers to table2 XOR table3. That's not possible. If you are not working with performance critical data you...

ok, thank you so far. I already tried to find proper DMV's but did not succeed. The intention of my post was to get some tsql samples as I think,...

just in case..

Indeed I have no problems, when I keep the format of the content.

this helped me:

http://bytes.com/groups/net-c/652496-how-update-xml-file

There is no law to do ETL in the Dataflow ;-). In my opinion there are cases where the database is stronger.

So you could save intermediate results in staging/transformation...

@Phil: I just like to play with c# in my hotel room. I wondered if i could write a command based tool to build or update SSIS-Packages.

So I tried a...

Great, you found my mistake. Now the query works like I expected.

Thanks!

Sorry for the delay..

I have installed the Adventure Works DW Example and tried to get the YTD-Values there:

WITH

MEMBER [Measures].[Amount YTD] as

SUM ( periodsToDate(

[Dim...

I don't see the difference to my query in spite of the translation..

What I want is:

Period YTD

..

200811 110

200812 120

200901 ...

I attached the query and the plan and also the query with the hint, so you can see, where the problem is.

the following cix did not help:

create UNIQUE clustered index...

Hello,

I would like to confirm that the method worked:

prepare the data in a "stage" table. Doing this not in one transaction but splitting the data and iterate.

If no error occured,...