Sean Lange (5/7/2015)
spaghettidba (5/7/2015)
T-SQL is a horrible tool for this job and using the CPU of the SQL Server box to send pings is not a wise choice, generally speaking. Not to mention the security concerns that xp_cmdshell brings.Are you sure you cannot code this in a different way or with a different tool?
+10000
Heh, you raise a good point. It was early and I was focused on getting the problem solved and didn't consider the wisdom of doing so. Thanks to both of you for pointing it out. I learned from this post that I shouldn't post before coffee.