| |
Managing User Permissions
|
|
Permission hierarchy |
|
Default permissions |
|
Object versus statement permissions |
|
Granting and revoking permissions |
|
Displaying information on permissions |
|
Object dependency |
|
Ownership chains |
| |
Monitoring SQL Server Activity
|
|
Monitoring performance |
|
Event logging |
|
Event alerts |
|
Permission hierarchy |
| |
Fine-Tuning Performance and Operation
|
|
Tuning the platform |
|
Setting query, database and configuration options |
|
Locking |
|
Index considerations |
| |
Data Import and Export
|
|
The bulk copy program |
|
BCP permission requirements |
|
Index and logging considerations |
|
Integrity and consistency issues |
|
Executing BCP |
|
BCP options |
|
BCP format file |
| |
Diagnosing System Problems
|
|
Error logs |
|
Reporting errors |
|
Killing processes |
|
Database consistency checker (DBCC) |
|
Recovering from media failure |
| |
Managing Remote Servers
|
|
Adding remote servers |
|
Configuring for remote login |
|
Adding remote logins |
| |
Extended Stored Procedures
|
|
Definition of extended stored procedures |
|
Benefits of extended stored procedures |
|
Creating extended stored procedures |