Your SQL Server 2005 Express Edition locks up fr

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Your SQL Server 2005 Express Edition locks up frequently and cannot be accessed. How can you enable the dedicated administrator connection?

Answer: You must use a trace flag to enable Express to listen with a DAC.
Explanation: The dedicated administrator connection is not normally available in SQL Server 2005 Express Edition, but with trace flag 7806 it can be enabled.

(Continued on next question...)

Other Job Interview Questions

• You have a Scalable Shared Database setup for reporting purposes on SQL2. You want to be able to keep a point in time view of the reporting database each month. What can you do?
• When the network service built-in account connects to a network resource, what is the context?
• You have a Scalable Shared Database setup for reporting purposes on SQL2. You want to be able to keep a point in time view of the reporting database each month. What can you do?
• What is the cost threshhold for parallelism in SQL Server 2005?
• If you use the EXECUTE AS clause to impersonate a user at a database-scoped level...
• You have upgraded your SQL Server 2000 on Windows 2000 server to SQL Server 2005 to take advantage ...
• Does a root element in an XML document necessarily contain all the content for a well-formed document?
• What's SQL Server
• What rights does a user need to perform a truncate table command SQL Server 2005?
• In SQL Server 2005 Integration Services, if you want to import a flat file very quickly that contains only integer data, what type of parsing should you use?
• More...