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 @DBNAME VARCHAR(100) SET @DBNAME = 'DB1' DECLARE @SQL VARCHAR(MAX) DECLARE @TEST_TEMP TABLE( ID VARCHAR(10), NAME VARCHAR(50), ADDR1 VARCHAR(80), ADDR2 VARCHAR(80), CITY VARCHAR(100), STATE VARCHAR(50), ZIPCODE VARCHAR(10) ); DECLARE TEST_CURSOR CURSOR FOR SELECT DB, SERVERNAME FROM DBS WHERE NAME = @DB OPEN TEST_CURSOR FETCH NEXT FROM TEST_CURSOR INTO @DB, @SERVER WHILE (@@FETCH_STATUS = 0 ) BEGIN SELECT @SQL = ' SELECT DISTINCT ID, NAME, ADDR1, ADDR2, CITY, STATE, ZIPCODE FROM '+@DB+'.DBO.EMPLOYEE ' SET @SQL = N'SELECT * FROM OPENQUERY(' + @LNKSVR + ', ''' + REPLACE(@SQL, '''', '''''') + ''')' INSERT INTO @TEST_TEMP EXECUTE(@SQL) FETCH NEXT FROM TEST_CURSOR INTO @DB, @SERVER END CLOSE TEST_CURSOR DEALLOCATE TEST_CURSOR SELECT ID, ADDR1, ADDR2, CITY, STATE, ZIPCODE FROM @TEST_TEMP
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|MS SQL Update query with connected table data||3||77|
|Select question from MySQL||1||27|
|Access 2010 Only Including Numbers After Certain Limit||3||39|
|mysql workbecn having problems to export tables to cvs||4||19|
Join the community of 500,000 technology professionals and ask your questions.