Viewing 15 posts - 1 through 15 (of 398 total)
Hi Ant-Green.
System::StartTime behaves just like System::ContainerStartTime in that it returns blank.
Not sure if it was clear before, but I use String datatype when setting this parameter in Parameter Mapping because...
December 7, 2020 at 5:40 pm
Thank you Jonathan AC Roberts for two SQL ways. I currently have no idea what the CURSOR that you shared does, but I'm looking it over and I hope it...
May 3, 2020 at 5:04 am
Frederico,
on the other post you suggested my code would actually FAIL "if you are one of those that puts comments BEFORE the create procedure command"
So now you are saying...
May 1, 2020 at 8:56 pm
It's not like I can just install Visual Studio on the server that is hosting the databases without discussing with higher ups. Additionally I believe this requires a coding ability...
May 1, 2020 at 5:28 pm
Noo source control, also there are hundreds of sprocs containing this error.
I provided DDL. Can anyone show me dynamic cursor way?
May 1, 2020 at 2:44 pm
anyway, thanks Frederico.
Are you saying that it's expected to be able to impersonate only once per connection because once I have impersonated I am not longer operating as sysadmin? Also,...
May 1, 2020 at 6:12 am
If I had known the reason for the problem I wouldn't have posted the question. Isn't that the point of posting Frederico? Now I understand that impersonating a login mapped...
April 30, 2020 at 3:58 pm
I am able to impersonate a single user (as opposed to a Security Group mapped to multiple users in AD).
IT SEEMS TO BE WORKING ONLY AS LONG AS I IMPERSONATE...
April 30, 2020 at 6:15 am
Hi Frederico,
Attached snapshots of results for both logins
I will create a single user (instead of using a security group name mapped to multiple aliases) and see if impersonate works against...
April 23, 2020 at 7:08 pm
Sorry, duplicate reply not intended, I have slow system and appeared original reply didn't work.
April 21, 2020 at 4:37 pm
Hi Frederico,
I get:
containment_desc = NONE
type-desc = WINDOWS_LOGIN
is_disabled = 0
default_database_name = master
serverproperty = 3
screenshot attached.
April 21, 2020 at 4:33 pm
Hi Frederico_Fonseca,
This is what I got:
User DOMAIN\myself Is sysadmin
Msg 15406, Level 16, State 1, Line 10
Cannot execute as the server principal because the principal "DOMAIN\theOtherUser" does not exist, this type...
April 21, 2020 at 6:36 am
Hi frederico_fonseca, Thanks for your time.
I get same error with EXECUTE. See attached image.
theOtherUser is a Login on the Server (with only 'public' security privilege) and a User on the...
April 20, 2020 at 11:38 pm
Hi John Mitchell & Grant Fritchey for answering the question. Couple more along these lines I wonder if you could help me with:
February 20, 2020 at 3:54 pm
Viewing 15 posts - 1 through 15 (of 398 total)