Home Forums SQL Server 2005 Administering Placing a Development Database on the same SQL Server instance as the Production database RE: Placing a Development Database on the same SQL Server instance as the Production database

  • There are so many reasons this is a bad and so few reasons it is a good idea. Usually devs will have elevated privileges to the dev server that are not available to them in production. The resources being consumed on dev will have an impact on production, etc etc etc...

    Get a copy of sql express installed somewhere else as your dev instance. Unless you need all the feature of enterprise on your dev system it should be adequate in most situations.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/