What rights does a user need to perform a trunca

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

(Continued from previous question...)

What rights does a user need to perform a truncate table command SQL Server 2005?

Answer: A member of the DDL_ADMIN role.

Explanation: You need to have db_owner, ddl_admin, sysadmin role membership or be the owner of the table.

(Continued on next question...)

Other Job Interview Questions

• Which of the following statements best describes the filter capabilities of Report Builder?
• You created a SQL Server 2005 Service Broker queue ....
• Is it possible to build an index on a view
• You want to partition these past orders columns into a new table. What type of partitioning is this?
• You are looking to secure your publisher to prevent unauthorized logins from accessing the data through replication. Where do you add the list of logins that have access?
• In configuring the thesaurus configuration file for SQL Server 2005 Full-Text Search, you set the diacritics_sensitive value to 1. What does this mean?
• Which of the following choices show the three report formats supported by Report Builder
• What tool is available for ad hoc reporting by non IT end users in Reporting Services 2005?
• How does a differential backup know which extents have changed so that it can be very quickly run?
• Which of these is not a parameter you can pass to the LOGINPROPERTY function?
• More...