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...
--Quote me
December 7, 2020 at 5:40 pm
Thanks Sergiy, problem solved.
--Quote me
August 14, 2020 at 3:01 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...
--Quote me
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...
--Quote me
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...
--Quote me
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?
--Quote me
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,...
--Quote me
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...
--Quote me
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...
--Quote me
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...
--Quote me
April 23, 2020 at 7:08 pm
Sorry, duplicate reply not intended, I have slow system and appeared original reply didn't work.
--Quote me
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.
--Quote me
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...
--Quote me
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...
--Quote me
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:
--Quote me
February 20, 2020 at 3:54 pm
Viewing 15 posts - 1 through 15 (of 398 total)