Enable xp_cmdshell in SQL Server
Xp_cmdshell is an extended stored procedure which takes a dos command as a string and returns output in table format. It is disabled by default and can be enabled as shown …
Enable xp_cmdshell in SQL Server Read MoreTag: Xp_cmdshell
T-SQL script to delete files
Many a times need arises to access/modify windows folder structures from SQL server. Though SQL Server is not meant for this purpose, however here is a T-SQL script to delete files …
T-SQL script to delete files Read MoreSQL Server – SQL Agent Proxies
I have seen many DBAs arguing on xp_cmdshell as a security risk or a bad practice. And on a strong recommendation of a DBA Architect VENDOR your company has chosen to …
SQL Server – SQL Agent Proxies Read More