Where can you view the list of server-scoped DDL

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

(Continued from previous question...)

Where can you view the list of server-scoped DDL triggers?

Answer
The Object Explorer for the server has a "Triggers" folder.
Explanation
The server-scoped DDL triggers will appear in Management Studio in the Object Explorer under the "Triggers" folder.

(Continued on next question...)

Other Job Interview Questions

• What do you need to do now to ensure you can recover the routes in the event of a disaster?
• A certificate is which type of security mechanism?
• When the network service built-in account connects to a network resource, what is the context?
• How are modified extents tracked in SQL Server 2005 (which internal structures)?
• What does a @@fetch_status of -2 mean in SQL Server 2005?
• You wish to prevent anyone from using the sa account on your SQL Server 2005 instance, but still keep it available if your polocy changes. What can you do?
• What the heck does ATN2 do?
• You then write a function to use this assembly, but it does not work. What could be the problem?
• What's an allocation unit?
• Using Report Builder, which of the following is the best statement about the formatting options for boolean columns?
• More...