Viewing 15 posts - 2,251 through 2,265 (of 2,857 total)
I was re-reading the problem and discussing it outside of this thread a little bit, and I'm not sure if the current path that we are following will lead us...
September 18, 2017 at 4:18 pm
heh... yep... that fixed it. I changed my fiew to "tiles" and it was fixed so I am expecting it to be the same problem.
I'll schedule a window...
September 15, 2017 at 11:50 am
September 15, 2017 at 10:16 am
Adding to what Sue_H said, I don't think you can nicely set up a local account (such as NT Service\MSSQLSERVER) with KERBEROS without using delegation. I think in that case...
September 15, 2017 at 10:07 am
Steve Jones - SSC Editor - Friday, September 15, 2017 9:51 AMwebmaster @ this domain
Email sent. I found 4 emails after doing...
September 15, 2017 at 10:02 am
September 15, 2017 at 9:20 am
I had this happen to me a few times too. One time it was a spam bots post that it claimed I was following. I still have copies of the...
September 15, 2017 at 8:37 am
AlexSQLForums - Tuesday, September 12, 2017 9:22 AMThank you bmg002
Not a problem. If you have any questions about that powershell, let...
September 12, 2017 at 10:38 am
Good thoughts with that Thom. SQL Injection, while unlikely in a NVARCHAR(19), could occur. Your solution does eliminate the risk involved of SQL injection.
I suppose if you knew that...
September 12, 2017 at 10:36 am
I could be wrong, but I think you will need to build this as dynamic SQL. That is:DECLARE @query varchar(255)
DECLARE @comp_cod nvarchar(19) = N'2,3'
SELECT @query...
September 12, 2017 at 8:40 am
AlexSQLForums - Friday, September 8, 2017 8:29 PMHi Jeff
Using exec xp_cmdshell works but the requirement is to be done in PS.
Just to...
September 11, 2017 at 11:10 am
Adding to what Sue_H said, and expanding on what Steve Jones said, I tend to avoid ms_foreachdb (for the reasons that Sue_H posted) and would much rather write my own...
September 11, 2017 at 10:09 am
Nested queries can be problematic as well. Might want to use a CTE or a temp table to store the nested query which may give better results. Since you are...
September 6, 2017 at 10:45 am
Viewing 15 posts - 2,251 through 2,265 (of 2,857 total)