:::: MENU ::::

SQL Server 2005 optional features kept off by default

  • Jan 28 / 2009
  • 0
DBA Interview questions, dbDigger, SQL Server tools

SQL Server 2005 optional features kept off by default

Keeping in view the fact that more accessible features causes more security threats, Microsoft SQL Server 2005 came with optional features kept off by default. These features include

  • CLR Integration
  • OLE Automation sys procedures
  • Database Mail sys procedures
  • SQL Mail sys procedures
  • Ad Hoc remote queries
  • SQL Server web assistant
  • XP_cmdShell availability
  • Remote use of dedicated admin connection

It will be best that you keep off these features as long as you do not need. When you require any of these features, you may turn it on through Surface Area configuration tool or Surface Area configuration command line interface.

Consult us to explore the Databases. Contact us