Viewing 15 posts - 1,141 through 1,155 (of 2,883 total)
Is there a reason you NEED to do this in powershell? it feels like it is the wrong tool to me when SQL Server can handle this without the need...
May 27, 2021 at 8:33 pm
Thinking this link will help:
To paraphrase the important part - your execution timeout period is too short. You will need to specify a longer timeout period. Depending on the size...
May 27, 2021 at 7:44 pm
I would recommend downloading this:
https://www.microsoft.com/en-us/download/details.aspx?id=50731
That is the LATEST CU for 2012 SP2 which includes the TLS 1.2 stuff. Feels to me like a much safer bet than downloading an older...
May 27, 2021 at 2:10 pm
For SQL Server 2012, TLS 1.2 (transport layer security 1.2) depends on your SP version. For SP2, it is CU10. For SP1, it is CU3. This can be found here:
As...
May 26, 2021 at 5:22 pm
I kind of expected SQL to be smart enough to not let you re-use files like that during the install, but was just guessing in case that was the issue.
I...
May 26, 2021 at 2:01 pm
"ACCESS DENIED" is actually very informative, depending on where you are seeing it as it SHOULD contain more information such as what access is being denied.
Is that in the SQL...
May 25, 2021 at 9:03 pm
From the Microsoft documentation:
When this option is enabled, network communication between DTC services can fall back to non-authenticated communication or to non-encrypted communication if a secure communication channel cannot be...
May 25, 2021 at 5:21 pm
On top of what Jeff was asking (what the scripts looked like before), I would be curious to see the execution plans for a slow run vs a fast run.
May 25, 2021 at 5:03 pm
My first thought is that the local user Paolo is a member of a group on the local machine that has additional permissions on the SSRS instance.
That or you are...
May 25, 2021 at 3:48 pm
To emphasize what Sue_H said, check the logs.
Without error messages it is impossible to say what is wrong.
And to reiterate what Sue_H said, "Shared Features" are features that are shared...
May 25, 2021 at 3:26 pm
Kind of, but SQL is a little bit different than the images you sent (that look like Excel?).
SQL has all of the data in the database and is just holding...
May 21, 2021 at 4:53 pm
I would recommend looking into Truth Tables. But basically, what the approach is doing is if condition1 AND condition2 are both TRUE, then use the first option. If EITHER condition...
May 20, 2021 at 7:15 pm
I think that is possible, but not QUITE the way you wrote it. What I think you would need to do (I don't have your data or any DDL to...
May 20, 2021 at 5:55 pm
Kind of. Anything that needs to authenticate as that account will fail. Anything that has previously authenticated will work fine. SO, the SQL instance will continue to run without problems,...
May 20, 2021 at 5:41 pm
I sometimes do use the table name as the alias. The reason I do this is that SQL Prompt SQL Format will automatically add the alias onto my columns IF...
May 18, 2021 at 4:40 pm
Viewing 15 posts - 1,141 through 1,155 (of 2,883 total)