Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
10 Cards in this Set
- Front
- Back
|
sp_help_proxy
|
lists all the proxies in the instance.
|
|
|
sp_enum_proxy_for_subsystem
|
Lists permissions for sql server agent proxies to access subsystems
|
|
|
sp_enum_login_for_proxy
|
lists associations between security principals and proxies
|
|
|
sp_enum_sqlagent_subsystems
|
lists the sql server agent subsystems
|
|
|
sp_help_operator
|
reports info about the operators defined for the server
|
|
|
sp_cycle_errorlog
|
closes the current error log file and cycles the error log extension numbers just like a server restart. The new error log contains version and copyright info and a line indicating that the new log has been created.
|
|
|
sp_add_proxy
|
adds a specific sql server agent proxy
|
|
|
sp_add_schedule
|
creates a schedule that can be used by jobs
|
|
|
sp_cycle_agent_errorlog
|
enables you to rotate the sql server agent error log
|
|
|
sp_updatestats
|
used to update the statistics of all user-defined and internal tables in the current db
|
