Viewing 15 posts - 2,296 through 2,310 (of 2,497 total)
You need to have permissions to start/stop the SQL services. This can be done using a local security template or via a GPO. Check with your infrastructure/security people to find...
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
October 10, 2005 at 6:31 am
My experience for 32-bit SQL Server is this:
1) The memory that SQL Server can address is dependant on Windows settings and SQL Server settings. The default is that any edition 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
October 7, 2005 at 5:30 am
Your proposed upgrade strategy appears to be designed to cause an outage.
I would look for an alternative, such as testing it first!
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
October 7, 2005 at 4:56 am
If you get any problems in Production that are related to EE functionality, you will not be able to test any fixes for these on a SE instance. Also, as...
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
October 7, 2005 at 4:51 am
In SQL2000 there are 2 ways to get new objects automatically created with the owner dbo.
1) If the account creating the object is a member of the sysadmin 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
October 4, 2005 at 4:22 am
We will not know for certain until the product goes RTM.
My understanding is that SQL2005 is dependant on .Net framework V2, which in turn needs W2003 SP1 or XP...
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
October 4, 2005 at 4:07 am
No.
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
October 4, 2005 at 4:01 am
Don't forget you are running a beta - things that should work may not do so.
Try downloading and using the June or September CTP, as these have fixed a lot 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
October 4, 2005 at 3:58 am
I would go for char(1). Many poorer countries do not perform gender assignment surgery for those babies whose bits are not obvious.
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
September 16, 2005 at 4:25 am
This is not a critical database, so use the same process you would for any user database that needs to be moved.
The easiest way normally is to detach the database,...
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
September 16, 2005 at 4:22 am
You need to log on as the SQL service account and create a Outlook mail profile. Mail profiles are personal to the account that created them, so the profile you...
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
September 16, 2005 at 4:19 am
My place is working on the assumption that during 2007 all new software will be released in 64-bit format only, and vendors will only market 64-bit servers. If you look at...
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
September 16, 2005 at 4:10 am
As phillcart says, you get a default directory of \system32 because cmd.exe lives there.
You could try copying cmd.exe to your preferred location, and ensure that location is in the PATH...
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
September 13, 2005 at 3:40 am
It sounds like you are trying to use the database technology to overcome an application problem.
It may well be possible to use a log sniffer (e.g. Log PI, etc) to...
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
September 13, 2005 at 3:30 am
I agree with Chris Hedgate. If you are mainly a Windows shop then one of the .Net languages should be your first priority. C# would be my choice, unless your...
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
August 19, 2005 at 5:54 am
Viewing 15 posts - 2,296 through 2,310 (of 2,497 total)