Viewing 15 posts - 1 through 15 (of 107 total)
That is good to know before deploying the certificate to all the servers.
Thanks
December 1, 2021 at 2:51 pm
error
November 23, 2020 at 1:42 pm
Another thing I found out while testing.
When logged into SSMS from a remote client (2 hop) my sysadmin Domain User account does not allow bulk insert
when logged into SSMS from...
February 21, 2020 at 7:21 pm
SVR is a token that suppose to provide the Name of the computer running SQL Server. If the SQL Server instance is a named instance, this includes the instance name.
December 4, 2018 at 11:25 am
Here is a couple links that helped me fix mine.
https://www.codykonior.com/2015/05/31/login-errors-with-syspolicy-purge-history/
https://serverfault.com/questions/211014/syspolicy-purge-history-generates-failed-logins
I had to correct the formatting in the script in the...
December 4, 2018 at 7:12 am
They are at the default settings. I tried tweaking it on the 2014 instance but nothing helped.
September 15, 2018 at 10:17 am
September 15, 2018 at 9:26 am
Another interesting find. On my SQL 2014 instance were the SP takes 66 min to run, It I switch the database to Compatibility level SQL Server 2012, it runs in...
September 15, 2018 at 6:44 am
September 14, 2018 at 1:33 pm
September 14, 2018 at 12:27 pm
ZZartin - Friday, September 14, 2018 11:39 AMHave you tried updating statistics and recompiling the SP on the slower system?
Yes that has...
September 14, 2018 at 11:43 am
I got it working. I was just expecting the preview to work.
December 20, 2017 at 8:50 am
We have...
December 12, 2017 at 5:36 pm
Found out I have to use the SQL Server 2016 isdeploymentwizard.exe to deploy rather then deploying within SSTD. I thought MS was making the tools backward compatible. We may have to...
December 8, 2017 at 1:50 pm
August 30, 2017 at 9:32 am
Viewing 15 posts - 1 through 15 (of 107 total)