Review Questions

  1. You have just installed a new SQL Server 2005 instance with all defaults and upgraded a database from SQL Server 2000. One of the users reports that a function in the application that uses xp_cmdshell to send a Windows message is not working. What is the likely problem?
    1. The xp_cmdshell stored procedure is not available in SQL Server 2005.
    2. The Windows executable is not available on this server.
    3. The Surface Area Configuration tool needs to be modified to enable this functionality.
    4. Windows messages are disabled in SQL Server 2005 servers.
  2. You have set up a new database for testing using the Developer edition of SQL Server 2005. However, the test group complains that they cannot access the server because remote connections are ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial