Forum Replies Created

Viewing 15 posts - 2,386 through 2,400 (of 2,497 total)

  • RE: Server h/w upgrade with data already held on SAN (SQL2K SE)

    I would go with the approach of C70070540 (Are you related to R2D2?), with a few tweaks.

    First build the new server with a different name, connect it to the SAN, 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

  • RE: Migrating DTS package of sql sever 2000 to sql server 2005

    The advice I have heard from SQL Server MVPs who have been involved with SQL2005 DTS since alpha-test days is that it is best to re-engineer your DTS, and not...

    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: How to save DB diagram, generated in SQL ,in word format?

    It is quite easy to save a database diagram as a .pdf document. 

    This is done by printing the document to a virtual printer that outputs the results as 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

  • RE: Default table permissions

    It sounds like what you want to do is to have a template of security permissions that will be automatically applied to an object when it is created. 

    This is...

    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 SMTP mail problem (fiber mode)

    Lots of things are not supported or stop working when running in Fiber mode.  A KB search for "Fiber mode" shows some of the issues.

    My suggestion is to turn off Fiber mode...

    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: SA PASSWORD

    What justification do the Network people have for needing SA rights?

    If they act as a backup to the DBAs, then SA might be justified.  In our shop, there are enough...

    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: c2 audit mode option

    C2 audit mode is based in the C2 definition in the US DOD 5200.28 standard.  This standard is now obsolete and has been replaced be a security evaluation system called...

    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: Performance on Windows 2003

    My experience is that there are 2 most likely possibilities:

    1) The W2003 DB server is very badly tuned and is running slowly.  This is unlikely, unless your site has done...

    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: How to restore only 1 file group as a new database

    If you use SQLBackTrack backup/recovery software from BMC, this can be done.  With standard SQL Server backup/recovery the answer is 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: Simple SQL using IN

    Apart from anything else, your clause '@LearnID IN (puTOP_SECTIONID)' is the wrong way round.  The IN clause works like 'needle IN haystack'.  Try rewriting it as 'puTOP_SECTIONID IN...

    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: Unreliable Index Creation

    To get PSS support, phone your local Microsoft office.  If that is not the right number they will give it to you.  When you get to PSS, you will either...

    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: Upgrade to MDAC 2.8 or not?

    If you use W2003, you do not have any choice about using MDAC 2.8 - it is the version shipped with W2003.

    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: Unreliable Index Creation

    I would echo Chris's advice.  You should contact PSS regardless of anything else you do.

    It may also be worth looking at your autogrow parameters.  Try to work out the likely...

    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: Error Message when running a Job

    As with all debugging, the most likely thing is that the error message is telling you the truth.  The most likely cause is that one of the file paths 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

  • RE: How to shrink transactional logs

    As some people have already said, you need to do transaction log backups to save your log information.  Do not use the truncate_only option unless you really want to loose...

    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,386 through 2,400 (of 2,497 total)