Forum Replies Created

Viewing 15 posts - 2,296 through 2,310 (of 2,497 total)

  • RE: Enterprise Manager not allowed to poll.

    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

  • RE: SQL Server Enterprise Edition supports more than 2GB RAM?

    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

  • RE: Is it safe to upgrade OS on production box without testing?

    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

  • RE: Issues with SQL Server Standard in Test and EE in Prod???

    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

  • RE: Windows Authentication with EM

    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

  • RE: Will SQL Server 2005 run on windows 2000 server?SQL Server 2005

    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

  • RE: When an account was last used

    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

  • RE: Unable to access 64 bit data from 32 bit management studio.

    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

  • RE: Data type for Gender

    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

  • RE: Moving distmdl.mdf and distmdl.ldf files...

    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

  • RE: SQL Mail

    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

  • RE: 64-bit Review

    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

  • RE: Operating System Command Job step Default Directory

    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

  • RE: Rolling back bad data

    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

  • RE: What language to learn?

    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

Viewing 15 posts - 2,296 through 2,310 (of 2,497 total)