There are over 80 distinct system privileges. Each system privilege allows a user to perform a particular database operation or class of database operations.
Such as:- 1. ANALYZE ANY 2. CREATE CLUSTER 3. CREATE ANY CLUSTER 4. ALTER ANY CLUSTER 5. DROP ANY CLUSTER 6. ALTER DATABASE 7. CREATE ANY INDEX 8. ALTER ANY INDEX 9. DROP ANY INDEX 10. GRANT ANY PRIVILEGE
If you have the better answer, then send it to us. We will display your answer after the approval.
Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.
I was asked in an interview... "Suppose u have a field with UNIQUE KEY. can u leave two or more cells NULL in SQL Server 2005...If Yes then Why...if NOT then Why.....