You are using SQL Server 2005 and you wish to fi

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

(Continued from previous question...)

You are using SQL Server 2005 and you wish to find a number of details about stored procedures created...

You are using SQL Server 2005 and you wish to find a number of details about stored procedures created. The details include date and time, the server that created the stored procedure, the login name and the contents. How would you do this?

Answer
Create a DDL trigger on CREATE_PROCEDURE database event

Explanation
The answer is Create a DDL trigger on CREATE_PROCEDURE database event You can find the answer on page 448 of Beginning SQL Server 2005 for Developers: From Novice to Professional

(Continued on next question...)

Other Job Interview Questions

• After you've completed a backup for your Sales server to disk...
• You are using SQL Server 2005 and you wish to find a number of details about stored procedures created...
• When you install SQL Server 2005 and create a new database, is a Database Master Key created?
• Which of the following is not available to you?
• What does the tablediff utility do?
• You want to be sure your database server if properly secured. You have two instances, a default instance and a named instance installed. Which ports do you need to open?
• What does the PAD_INDEX parameter do when you create an index in SQL Server 2005?
• What tool is available for ad hoc reporting by non IT end users in Reporting Services 2005?
• Your SQL Server 2005 Express Edition locks up frequently and cannot be accessed. How can you enable the dedicated administrator connection?
• Out of the box Report Builder supports two report level fields that can be shown on a report. Which option below has those two options?
• More...