minionware

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 […]

You rated this post out of 5. Change rating

2004-10-28

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. 

You rated this post out of 5. Change rating

2004-07-19

52 reads

Blogs

Set a Runtime Variable in an Azure DevOps Pipeline

By

Note: I DO NOT recommend this. Any changes to a pipeline should be in...

A New Word: Symptomania

By

symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...

Query Store Keeps Switching Itself Off, Getting it Moving Again

By

I recently received a complaint that Query Store for a particular database was turned...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers