concept procedure in category security

This is an excerpt from Manning's book The Art of Network Penetration Testing.
In MSSQL speak, these functions or methods are called stored procedures. As luck would have it, MSSQL comes with a helpful set of pre-made stored procedures called system stored procedures, which are intended to enhance the capabilities of MSSQL and in some cases allow you to interact with the host-level operating system. (If you’re interested in learning more about system stored procedures check out the docs page on Microsoft’s website. https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/system-stored-procedures-transact-sql
One particular system stored procedure, xp_cmdshell, takes an operating system command as an argument, runs the command within the context of the user account that is running the MSSQL server, and then displays the output of the command in a raw SQL response. Due to the abuse of this stored procedure by hackers (and penetration testers) over the years, Microsoft has opted to disable it by default. You can check to see if it’s enabled on your target server using the mssql_enum metasploit module.