Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
USE [xxx] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[CEM_BulkOpsInsert] @tablename varchar(50), @table varchar(100) AS BEGIN SET NOCOUNT ON; Declare @error nvarchar(255) Declare @subject1 varchar(200) Declare @sql varchar(255) exec SF_BulkOps 'Insert',@tablename,@table Set @sql = 'Delete From ' + @table + ' WHERE LEN(ID) > 4' exec @sql Set @sql = 'select ' + @error + ' = COUNT(ID) From ' + @table + ' WHERE LEN(Error) > 4' exec @sql IF @error > 0 BEGIN Set @subject1 = 'Errors Exist In ' + @table + ' For ' + @tablename EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Host', @recipients = 'email@example.com', @body = '', @subject = @subject1; END END