Technical Article

RE: Whois lookup from stored procedure

  • Reply

To extend on Steve, here's a code snippet that might give you some ideasset nocount on declare @ip varchar(255), @cmd varchar(100) set @cmd = 'ping ' + HOST_NAME() create table #temptb (grabfield varchar(255)) insert into #temptb exec master.dbo.xp_cmdshell @cmd select @ip = substring(grabfield,  charindex('[',grabfield)+1, charindex(']',grabfield)-charindex('[',grabfield)-1) from #temptb  where left(grabfield,7) = 'Pinging' print @ip drop table […]


Technical Article

DTS and Oracle

  • Topic

Is it possible to retrieve data from an Oracle database (using DTS) without installing an Oracle client at the SQL-Server database-server ?It works fine whit the Oracle client installed; but we would like to avoid the installation of Oracle-stuff on our SQL-Server database-server. 


53 reads


Daily Coping 26 Jan 2023


Today’s coping tip is to focus on what’s good, even if today feels tough....

Working With Tags in FlashArray using PowerShell


Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...

Using SQL Data Compare from the Command Line with a Project


SQL Data Compare (SDC) is a great way to sync data among tables. It’s...

Read the latest Blogs


Visual Studio Code - SQL Server (mssql) Version 1.17.0 - Encryption By Default

By o.schoen

Microsoft is warning of a "BREAKING CHANGE" and indeed this little update took my...

SQL Table Issue

By Jobs90312

Hi everyone, In below code I am creating a table and inserting some english...

what does the backup log init do?

By vpmaciel

what does the backup log init do?

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers