Viewing 15 posts - 16 through 30 (of 53 total)
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...
November 12, 2009 at 12:38 am
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
November 2, 2009 at 6:19 am
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...
November 2, 2009 at 5:47 am
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'
...
October 13, 2009 at 8:24 am
That are good points. I will try. Thank you
October 13, 2009 at 12:10 am
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...
October 6, 2009 at 7:28 am
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,...
September 18, 2009 at 8:48 am
just in case..
Indeed I have no problems, when I keep the format of the content.
this helped me:
June 9, 2009 at 9:33 am
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...
June 9, 2009 at 8:32 am
@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...
June 9, 2009 at 8:13 am
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...
May 14, 2009 at 11:21 am
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,...
May 6, 2009 at 2:27 am
Viewing 15 posts - 16 through 30 (of 53 total)