These SSMS categories are aggregates of various server side featuresSecurity tab:
this shows Logins, Server Roles and Credentials
e.g. Logins node
a)shows existing login
b)Allows to add a new login
c)Allows to delete a login
Server node provides the server level permissions by adding a login to a predefined server fixed role and then assigning multiple permissions to that login.Server objects tab:
It providedsa) Backup Device Object -
monitor Microsoft SQL Server backup devices used for backup and restore operationsb) Linked Server Object -
Linked Servers allows to connect other database instances on the same server or on another machine or remote servers.c) Trigger objects -
It stores the Server Trigger
( select * from sys.server_triggers
For creating the replication like Transactional Replication,Snapshot Replication,Merge ReplicationManagement:
To achieve various kind of policies.
Suppose we need to schedule a job or a backup policy management or the resource governor
that helps to manage SQL Server workload and system resource consumption or db email
etc.We even have DTC
that coordinates transactions that update two or more transaction-protected resources, such as databases, message queues, files systems, and so on.
The Extended event
feature is use to identify a performance problem.
Hope this helpsAmatya, if this helps please login to Mark As Answer. | Alert Moderator