Viewing 15 posts - 1,096 through 1,110 (of 2,497 total)
Are you running the BC file included in the SQL 2008 media? If you are then it would have been better to have included backward compatibility as one of...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 5, 2010 at 7:19 am
The SEE_MASK_NOZONECHECKS environment variable does not normally exist. When it does not exist Windows assumes the setting is off. Use the command SET SEE_MASK_NOZONECHECKS=1 to turn it on,...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 5, 2010 at 6:58 am
It was originally added to suppress warnings for the unattended install done by FineBuild. It will also suppress some warnings for an interactive install.
I suggest you try it and...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 5, 2010 at 6:24 am
I have successfully installed DTS Designer on W2008 R2. This needs to be followed with copying the DTS Designer dll files to the SQL 2008 program folders as noted...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 5, 2010 at 3:47 am
As far as I know there is no documented procedure from Microsoft for removing these groups. Therefore if you do remove the groups you may put yourself outside of...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 5, 2010 at 3:34 am
At what point in the install process is this error happening?
If it is right at the beginning before Setup has displayed any windows to you, then you are having a...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 5, 2010 at 3:06 am
I think this is a very helpful article. There is one aspect that many people take for granted, but I think should get challenged more, even if the challenge...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 4, 2010 at 3:15 am
These short videos from Andy Warren give good advice about updating statistics:
http://www.sqlshare.com/updating-statistics-part-1_695.aspx
http://www.sqlshare.com/updating-statistics-part-2_696.aspx
http://www.sqlshare.com/updating-statistics-part-3_697.aspx
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 4, 2010 at 2:50 am
For 64-bit Windows 2003, 2008 and above:
/3GB is not relevant to 64-bit, and is ignored if it is supplied.
/PAE is always on for 64-bit, and makes no difference if it...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
December 29, 2009 at 4:07 am
IMHO the only version of SQL Server that handles international and DST-affected times correctly is SQL Server 2008 when using the UTC-aware data types. If you are not using...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
December 24, 2009 at 3:26 am
You need to download and install the 'SQL Server 2000 DTS Designer Components' from the SQL Server 2005 Feature Pack.
Many sites find they need to then also apply the KB917406...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
December 24, 2009 at 3:17 am
You have given the SQL Server erroelog. What is in the SQL Agent errorlog.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
December 23, 2009 at 8:18 am
Everything in your log file looks fine.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
December 23, 2009 at 7:57 am
If this works in a script but the same command fails in SSMS, then I suggest you raise this as a bug with Microsoft.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
December 23, 2009 at 4:13 am
It is normally safe to uninstall the default instance of SQL Server and leave a named instance running.
However, in your situation I would prefer to set the default instance services...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
December 23, 2009 at 4:09 am
Viewing 15 posts - 1,096 through 1,110 (of 2,497 total)