Viewing 15 posts - 1 through 15 (of 5,343 total)
Never heard of it but from a quick google it seems its another DELL EMC product.
We did have Data Domain at one place I worked another DELL EMC product which...
May 27, 2020 at 8:59 am
I use ASG Remote Desktop the freeware version is great, ok it's limited as you cant have more then 3 RDP session open at anyone time, but I find it a...
May 26, 2020 at 12:07 pm
unsure, it depends, you may break it more than its already broken. its a risk you will need to take hence why I would build a new server and move...
May 22, 2020 at 12:58 pm
do they have read access to master?
we had this recently on a 2012 box and changing user permissions to be ssis_admin, they couldn't run the ssis reports without getting errors...
May 22, 2020 at 10:35 am
I would be cautious in this, if something has borked the installed on the engine, then installing SP2 may resolve it. Don't 100% expect it to work though.
If it didn't...
May 22, 2020 at 7:14 am
Remember that 2008R2 and below are all now out of mainstream support and extended support.
SQL 2012 and SQL 2014 are now out of mainstream support.
These legacy versions of the engine...
May 22, 2020 at 7:10 am
Compatibility level doesn't work like that.
If you on a 2017 server you get the 2017 syntax.
Changing the compatibility level is only for some internal things to revert to the old...
May 21, 2020 at 8:34 am
post the full details of the job output, not just what the overall job says, theres more to the job, expand it and select the details from the step
May 20, 2020 at 6:45 am
whats the output of the job step, not the overall job
May 19, 2020 at 1:10 pm
The only thing that stands out is the name "SP_RMT" I take it that, that object is a Stored Procedure via the prefix "SP".
If so you cant select direct from...
May 19, 2020 at 9:02 am
you cant get the versions of the shared features that way
run the SP2 installer or the CU installer and screen shot the part where you select the features to patch...
May 19, 2020 at 8:38 am
You sure it was 2016wSP2 in the media that installed it, the summary file shows the shared features are at a lower level than SP2.
Run the SP2 installer when you...
May 18, 2020 at 8:03 am
You need to alias after the delete to know where to delete from.
If you had a DELETE with multiple joins in the logic to only delete the right rows, you...
May 15, 2020 at 7:03 am
Well looking at the summary log, the shared features don't seem to have been updated past the RTM version so whoever did the initial patch to SP2 seems to have...
May 15, 2020 at 6:54 am
Sounds like you've run into the new cardinality estimator issues that everyone had who upgraded from 2014 onwards.
When you rebuilt your statistics did you rebuild with a fullscan or was...
May 15, 2020 at 6:45 am