Is XP_CMDSHELL enabled on your server? I recommend avoiding it for security. Here are two ways to check and turn it off, starting with T-SQL.
Interview Question of the Week #013 – Stored Procedure and Its Advantages – How to Create Stored Procedure
Learn how to create stored procedure code with parameters and NOCOUNT, then review security, plan reuse, and parameter-sensitive plans.
SQL SERVER – System procedures to know SQL Server Version
There are many ways to know SQL Server version, but did you know two system procedures, sp_server_info and xp_msver, also return it?
SQL SERVER – What are the Different Ways to Script Procedure with T-SQL
What are the different ways to script procedure code with T-SQL? There are four, including sp_helptext and INFORMATION_SCHEMA.ROUTINES. Here is each one.
Refactoring Old T-SQL One Procedure at a Time
Begin refactoring old T-SQL with one procedure, repeatable inputs, duplicate-aware result checks, measured reads, and a simple change log.
SQL SERVER – How to use Procedure sp_user_counter1 to sp_user_counter10
Want to plot your own values, like rows in a table, next to standard PerfMon counters? The procedures sp_user_counter1 to sp_user_counter10 do just that.
Natively Compiled Procedures: ATOMIC Blocks and T-SQL Limits
Native procedures check every statement when you create them. Build a tiny one and see which habits it will not accept.