Viewing 15 posts - 196 through 210 (of 9,725 total)
Well THIS is annoying.
I have an SSIS solution / project saved that is set to DontSaveSensitive. All the packages under it are saved as the same. Last week, everything was...
September 7, 2021 at 12:26 pm
So here's a random thought based on your last post, Steve. If this is the longest thread in the world, how do we get it into the Guinness book of...
August 30, 2021 at 5:13 pm
I find myself wondering how many people who frequent this website have gotten the dreaded bug and are unable to return for ... various reasons. I hope everyone is doing...
August 25, 2021 at 8:06 pm
Well, THAT was a pain.
As Mr. Monk would say, "Here's what happened..."
Somehow, several members of one team (Team A) got added to the security group of another team (Team B)....
August 25, 2021 at 5:40 pm
The individual users don't exist on the server. They are part of a windows login group, which is not returning results and erroring out.
I think I'm going nuclear. I've removed...
August 25, 2021 at 4:16 pm
HMMM... We use groups in SQL Server, so the individual login isn't working. And the group gives the same error.
Msg 15406, Level 16, State 1, Line 1
Cannot execute as the...
August 23, 2021 at 7:04 pm
Another thing to check is linked servers. If a linked server connection connects to that instance as a user who has permission to drop and create objects AND you...
August 23, 2021 at 4:37 pm
I assume you know which login dropped/created the procs.
and assuming you are a SYSADMIN what output do you get out of these
execute as login = 'loginname' SELECT * FROM...
August 23, 2021 at 4:32 pm
There is no schema owned by this group. But you brought up an interesting point. Sometimes groups become owner of system created database schemas, so I double-checked. The group does...
August 21, 2021 at 9:33 am
I am getting really annoyed with this "link to the post takes me to the second last page of the thread, not the actual post" issue.
August 21, 2021 at 9:19 am
It's Friday. I've been overwhelmed for several days and now I'm just confused. Help here appreciated:
https://www.sqlservercentral.com/forums/topic/mysterious-ability-to-drop-create-stored-procedures
It's late, so I might be missing something here. Are you saying...
August 21, 2021 at 9:18 am
It's Friday. I've been overwhelmed for several days and now I'm just confused. Help here appreciated:
https://www.sqlservercentral.com/forums/topic/mysterious-ability-to-drop-create-stored-procedures
August 20, 2021 at 8:05 pm
So my interview question of the day would be - "tell me about logging in SSIS" or "how do you write to the log table in SSIS?" And if...
August 19, 2021 at 9:44 am
Don't forget if you use Sprint for cell phone service, you're now T-Mobile and need to update stuff.
August 19, 2021 at 9:41 am
If they put Masters in the Basic requirements, HR will never forward anyone who doesn't have it, regardless of experience. Having it in preferred also gives them the option...
August 17, 2021 at 2:03 pm
Viewing 15 posts - 196 through 210 (of 9,725 total)