Anonymous subscription is a specific type of pull subscription, for which information regarding the subscription and the subscribing server (Subscriber) is not stored, for various reasons such as security (if the subscribing server accesses publications over the Internet) or cutting maintenance overhead involved in storing extra information at either the publication or distribution database. Anonymous subscriptions are initiated at the subscribing server, which is also responsible for keeping such subscriptions synchronized.
The process of identifying and verifying a user who is attempting to establish a SQL Server session. Can be either Windows Authentication or SQL Server Authentication. With Windows Authentication (trusted logins), SQL Server uses Windows security mechanisms to determine who the users are and what they have access to. With SQL Server Authentication, users must have a SQL Server login and password, which are validated against a SQL Server system table. SQL Server can be configured to allow only Windows Authentication, or both Windows and SQL Server Authentication (Mixed mode).
An option that can be set on SQL Server databases. This option causes SQL Server to periodically attempt to reorganize the data, thereby acquiring additional space. Continually opening and closing the SQL Server database significantly affects the database. Therefore, the AutoClose option is disabled by default, thereby keeping the database always open and ready, regardless of user activity.