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.
What are the fundamental tools of Notification services?
Create a procedure named BASKET_ADD_SP that accepts a product id, basket id, price, quantity, size code(1or2) and from code(3 or 4) and that uses this information to add a new item to the BB_BASKETITEM table.
What is the Window PowerShell snaps SQL server provided?
What are the conditions in Isolation level ignored?
What are the new capabilities of SQL server 2008 for persisting BLOB data?
What are the limits applicable when creating views?
Explain about Enhanced database mirroring in SQL server 2008.
Illustrates commands BREAK and COMPUTE?
Explain about the plan freezing in SQL server 2008.
Describe benefits of SQL Server 2008 for automatic auditing.
18,76,764
1924615 Asked
3,689
Active Tutors
1453199
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!