Xp_cmdshell Use Cases
Today Steve asks for the ways in which you use xp_cmdshell in your environment.
2024-07-03
245 reads
xp_cmdshell
Check if xp_cmdshell is turned on and flip the bit
The code works well for an automation process that needs to have xp_cmdhsell turned on.
2017-02-22 (first published: 2017-02-13)
1,341 reads
2016-10-24
1,065 reads
Blogs
Happy Thanksgiving! (USA Holiday)
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Getting SQL Server 2025 RTM Running in Containers on macOS
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you...
The PASS Data Community Summit 2025 Recap
By Steve Jones
It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m...
Forums
Cannot execute SQL cursor in Azure Query Editor (Preview)
Apologies if this is posted in the wrong forum, but I am trying to...
SQl Server 2014 linked server remote server
Hello all, I have a linked server created on an instance which only has...
Find all the tables in a database containing particular column value
Hi, I want to find all the tables name under a database where tables...
Question of the Day
The Ending Substring
In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']' See possible answers