Viewing 15 posts - 1,786 through 1,800 (of 2,497 total)
Ian,
I have not tried having both of these specified at the same time. It is possible that both mechanisms would try to start Agent, resulting in at least 1...
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
February 7, 2008 at 10:10 am
The SQL Agent option 'auto restart if service stops unexpectedly' performs the same function as the Service applet auto restart function, but does it in a different way.
In order for...
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
February 7, 2008 at 2:57 am
The spSetDBOptions script is just part of SQL Server FineBuild. FineBuild helps provide 1-click install and configuration of SQL Server 2005.
To get the full product, go to http://www.codeplex.com/SQLServerFineBuild
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
February 7, 2008 at 2:40 am
You may find http://www.codeplex.com/SQLServerFineBuild helpful. FineBuild is something I published that helps you get a 1-click install and configuration of SQL Server 2005. It includes scripts that help...
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
February 6, 2008 at 7:32 am
You might find http://www.codeplex.com/SQLServerFineBuild helpful. It is something I published that helps you get a 1-click install and configuration of SQL Server 2005. One of the standard builds...
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
February 6, 2008 at 3:38 am
If you are managing SQL Server 2000, there is IMHO too much that does not work if the DBA is not also in the local Administrators group.
If you are managing...
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
February 6, 2008 at 3:34 am
I would advise against running SQL Server as local system. This means SQL Server has local admin rights on the box it is running on. If someone can...
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
February 6, 2008 at 3:32 am
If your work includes installing SQL Server, take a look at http://www.codeplex.com/SQLServerFineBuild. It is something I published that helps you get a 1-click install and configuration of SQL Server...
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
February 6, 2008 at 3:26 am
If you are installing Developer Edition on Vista (or Std or EE on a server), take a look at http://www.codeplex.com/SQLServerFineBuild It is something I published that helps you get...
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
February 6, 2008 at 3:03 am
I think it means the is a bug in Upgrade Advisor.
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
February 6, 2008 at 3:00 am
Loner,
It is like the two men in the woods, one asks "What do we do if a bear jumps out in front of us?" "I'll run as fast as I...
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
February 5, 2008 at 6:07 am
I have succesfully build SQL Server 2005 as the first and default instance, then installed SQL Server 2000 as a named instaNCE.
Why do you want to retain a SQL Sever...
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
February 5, 2008 at 5:47 am
Best of luck.. you will need it.
You need to plan for an in-place upgrade failing part-way through, leaving SQL completely dead. The only way out is to uninstall SQL...
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
February 5, 2008 at 5:44 am
The question says 'not usually used to improve ... performance'. Is this a typo?
I would have put the right answer of 'summary tables' on the side of 'usually used'.
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
February 5, 2008 at 5:37 am
You cannot install SQL Server 2000 on Vista or Windows 2008.
If somehow you do get it to work, you will have no support from 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
February 4, 2008 at 4:27 am
Viewing 15 posts - 1,786 through 1,800 (of 2,497 total)