System Stored Procedures Stored procedures are groups of SQL statements that execute in a single transaction. SQL Server includes many stored procedures by default. These procedures are used by SQL Server to manage the system. For instance, when you add a login or change a user s permissions, SQL Server executes a stored procedure and updates information in the Master database. Because system stored procedures are so powerful, they need to be protected.
Replication is a complicated and involved topic.
If used in your organization, you may want to consult SQL Server Books Online prior to attempting an audit. If replicating information over the Internet, transmission of delicate information should be encrypted. If replicating over the Internet, the distribution server should be separated from the publishing server. If practical, information should only be pushed from the publishing server to the distribution server rather than the other way around.