Viewing 15 posts - 1 through 15 (of 313 total)
Thank you Rob-792003!!!! I will be reading your post multiple times to make sure I understand it. 🙂 Thank you!!
March 2, 2022 at 7:10 pm
A bit more on my thoughts:
While my agency may be getting more serious about producing browser-based applications, I've had these questions for many years. Why post now and here? I...
March 2, 2022 at 5:02 pm
I have a question that I hope is appropriate for this page. I read the article. The article it lists reasons when SQL Authentication is required, but I'm not sure...
March 2, 2022 at 4:37 pm
I attended an online, non-IT conference this past January which was fantastic. One of my favorite sessions was a time the conference reserved for no presentations at all. Instead, you...
June 15, 2021 at 6:33 pm
Thanks for the nice and helpful feedback Martin!
FYI: I'm essentially on my own for SQL Server stuff where I work. However, for this problem, it felt like I had a...
May 26, 2021 at 10:14 pm
re: "One more thing you can try is to set the procedure to EXECUTE AS OWNER"
I had not heard of "EXECUTE AS OWNER" before and was intrigued. So I researched...
May 26, 2021 at 10:06 pm
THANK YOU to everyone who helped!!
Etiquette Question: Several people helped and provided pieces of this puzzle. I summarized the answer in my previous post, but I don't know if...
May 25, 2021 at 11:30 pm
I believe we have a solution. For those interested in the solution and also all the tests we did, here you go.
Process Update: We got to a point where we...
May 25, 2021 at 11:25 pm
Jeffrey: re: "..then the stored procedure will execute in the context of the SQL Server service account." Thanks. That is good to know. I've been trying to follow the advice...
May 17, 2021 at 4:49 pm
Jeffrey: Thank you for clarifying how I could change my SSIS package so that it could run via Agent every X minutes. I understand what you are saying now. It...
May 14, 2021 at 10:47 pm
THIS IS AN INTERIM UPDATE: I wanted to wait until I had a final answer before posting back here, but a lot of time has gone by and I can't...
May 14, 2021 at 8:24 pm
Jeffrey: Thanks for clarifying the process you are thinking of. There's some kind of disconnect here as I'm still not fully following you. That's OK though. We can let this...
May 6, 2021 at 4:06 pm
re: "It seems this is a process that loads data into SQL Server from defined CSV files - which can be scheduled to run every xx minutes."
I don't think I...
May 5, 2021 at 9:38 pm
re: "However - this may not work because the action of right-clicking and executing the package in SSMS may not be using the user credentials that logged into SSMS, and...
May 5, 2021 at 9:32 pm
Jeffrey: Thanks for the reply and added information/explanation.
You asked why my user needs to run the job on demand. It's a fair question. Here's the situation:
In the past, when we...
May 5, 2021 at 9:11 pm