Database Engine configuration

• Ayyappan Thangaraj

  Old Hand

  Points: 364

  More actions

  April 29, 2008 at 6:53 am

  #189953

  if you receive any error related to query cost

  you can use

  exec sp_configure

  it will display database engine properties

  you can also change the property values. but it is sensitive.

• Grant Fritchey

  SSC Guru

  Points: 398882

  More actions

  April 29, 2008 at 9:26 am

  #808474

  Were you answering someone's question?

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning