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.
--declare all variables used declare @tblName varchar(150) declare @fields varchar(150) declare @sql varchar (2000) DECLARE c1 CURSOR READ_ONLY FOR (select TABLE_NAME from information_schema.columns where TABLE_CATALOG = 'SiteMinder_FULL' group by TABLE_NAME ) OPEN c1 FETCH NEXT FROM c1 INTO @tblName WHILE @@FETCH_STATUS = 0 BEGIN select COLUMN_NAME from information_schema.columns where TABLE_NAME = @tblName set @sql = 'select '+@fields+' into ' + @tblName + ' from OCX..SST.' + @tblName + '' exec (@sql) ----first cursor FETCH NEXT FROM c1 INTO @tblName END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.