How do I check that?  The job is owned by sa - is it not run under that?

I take it the SQL Service account is not visible under 'security -...

Thanks, that's great.

Yes, I checked books online but was looking for a 'create' statement.  In your example I presume the new_addresses table would have to exist already?

Dunno, I used this one:

SELECT PARSENAME(ip_addr, 3) AS 'SecondOctet'

Because I know I'll always have 4 parts.

Thank you all for this, I have gone with the parsename function, which is perfect for my needs.

And I am only slightly worried that you are all so enthusiastic about...

Excellent!  Many many thanks!

Hi Colin,

I have this exact problem and would like to try rpc but don't know how to.  I have a select statement using openquery.  It queries an oracle view using...

Ah, I see.  I already tried that (just didn't realise it was called a 4 part distributed query).  I'm thinking now that I should have RPC and RPC out selected. ...

How do I do a 4-part distributed query?

I've ran sp_addlinkedsrvlogin to add the windows username of the person trying to connect from the app, and specified remote login to the Oracle database using the oracle username nad...

Thanks to all. 

Ah, yes, because it's a.*.  Yes that will be it.  Thanks.  It's been a long day, my brain has gone to sleep too early.

I tried all of these.  The first two are great but the third brings back 4 extra rows!  I'm a bit confused.  Just crap data do you think?  The where clause is...

Ah, hallelujah!  That's it!  A million thanks.  I'd been trying all sorts of distinct / having count type combinations but just couldn't get it!

Thanks for trying but this still brings back the same as mine roughly, i.e. all ninumbers that exist more than once, but not just the ones that exist within different...