Database administrators can perform variety of tasks with the database:
• Back up the database and restore the database by overwriting the existing one with
an earlier one. (To restore a new database, you must be a server administrator.)
• Send
DISCOVER_SESSIONS requests to find all the existing sessions that are open
against the current database. After viewing the database sessions, a database admin-
istrator can send a
Cancel command that ends a given session.
• Use the SQL Server Profiler application to monitor activities within your database.
To see all the activities on the server, you must be a server administrator. You won’t
see
Discover requests because they are performed as lightweight operations.
Evaluating the permissions involved in every ...