Viewing 15 posts - 2,281 through 2,295 (of 2,883 total)
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
To me, it sound then like audrey.abbey is likely correct...
September 6, 2017 at 8:18 am
Can you replicate the problem on another computer?
If you can replicate the problem, it makes me think the problem is not related to the end users computer.
If you...
September 5, 2017 at 4:24 pm
A quick google of that error brought me to this:
https://technet.microsoft.com/en-us/library/ms187005(v=sql.105).aspx
basically - update SSMS, possible network issues, server setting may need changing (depending on the windows server version).
September 5, 2017 at 3:39 pm
The database they were connected to had auto-close set to false, correct? I believe that is a database level setting... I am just thinking if they are running a query...
September 5, 2017 at 3:30 pm
Viewing 15 posts - 2,281 through 2,295 (of 2,883 total)