What are included in SQL Server 2008 for automatic auditing
What are included in SQL Server 2008 for automatic auditing?
Expert
This automatic auditing in SQL server 2008 include as given below:
• Provision for the centralized audit logs’ storage as well as integration along with system center
• Good performance which is noticeable
• Allows free-grained auditing wherein an audit can be targeted for several specific actions by a principle against an exact object.
• Allows the objects of audit to be function as first class database objects that mean Transact-SQL DDL statements can create such objects.
• The database object is controlled through database engine’s enforcement control and permission model.
• A new level permission is characteristic in SQL Audit – CHANGE ANY SERVER AUDIT- that permits a principle to ALTER, DROP and CREATE an Audit Specification object.
• A database level permission as: ALTER ANY DATABASE AUDIT; all is introduced to permit a principle to CREATE, DROP and ALTER a Database requirement object.
Define the Synonyms in Structure Query Language.
What is Null value function?
Explain about the Commit.
Do you have ideas about PowerShell into SQL Server 2008?
Explain about the Sequences in SQL?
Explain about the Distributed Query in the SQL Statement.
How is MyISAM table stored?
What do you mean by Heap tables? And also define its characteristics?
What are the requirements for Hot Add CPU?
Describe the term sparse filtered index.
18,76,764
1932245 Asked
3,689
Active Tutors
1428293
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!