Results 1 to 2 of 2

Thread: Database Options

Threaded View

  1. 02-21-2007, 12:26 PM #1
    rgarrison
    rgarrison is offline Registered User
    Join Date
    Dec 2006
    Location
    Portland, Oregon
    Posts
    64

    Question Database Options

    This thread is related to the second article in the SqlCredit series: Part 2: Creating the Database, Tables, CRUD Procedures.

    There are a number of database options that are OFF by default but should be ON based on recommendations from the SQL Server 2000 Best Practices Analyzer. The CreateDatabase script sets all these options to ON:
    • ANSI_NULLS
    • ANSI_WARNINGS
    • ARITHABORT
    • CONCAT_NULL_YIELDS_NULL
    • QUOTED_IDENTIFIER

    I am very interested to find what people are using in production environments (either 2000 or 2005).

    Are you setting these options to ON? If not, why not? What other options do you change, and why?

    Rob
    Last edited by rgarrison; 02-23-2007 at 01:00 PM. Reason: Updated after article published.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules