Hi, the below should get you want you need based on your details.

If not, please follow the second link in my signature on how to post code and data so...

Duplicate post, didn't see this, this morning when looking through the topics

http://www.sqlservercentral.com/Forums/Topic1313689-145-1.aspx#bm1313709

change the FROM clause to point to your table in question

so you will need the following rules

LocalIPAddress on ANY port to RemoteIPAddress Port 1433 -- Local Firewall

RemoteIPAddress Port 1433 to LocalIPAddress ANY port -- Remote Firewall

Probably a better way to do it but heres my first quick go

declare @tab table (filepath nvarchar(100))

insert into @tab values ('H:\FOLDER\123456\document1.doc'),

('H:\FOLDER\1234\document2.doc'),

('H:\FOLDER\98765\document1.doc')

SELECT

Filepath,

LEFT(REPLACE(filepath,'H:\Folder\',''),(CHARINDEX('\',REPLACE(filepath,'H:\Folder\',''),1)-1))

FROM

@tab

Nope, SQL wont allow files to be on network drives, they have to be on local storage only.

Is that IP external facing or internal facing?

Do you know the port numbers the server is using? http://support.microsoft.com/kb/287932

Do you have a SQL authentication account ready on that server to login...

A self join will do the trick

declare @tab table (name nvarchar(100), MemberID INT, PrimaryID INT, Expiration DATE)

insert into @tab values

('John Smith',1024,null,'2013-01-01'),

('Mary Smith',1025,1024,'2013-01-15'),

('Jim Smith',2033,1024,'2013-01-18'),

('Kate Smith',2100,1024,'2013-01-17')

select * from @tab

UPDATE t

SET...

Does the remote SQL server have an external IP address? If not it needs one, or you need to put some routing in place which routes SQL packets coming...

Depends on how you want to connect to SQL.

There are two main options

1, get a machine on the remote site which you have RDP access to and have SSMS installed...

First, please may I say that you need to switch caps lock off.

Second please follow the second link in my signature on how to post code and data for the...

Gold Digger, now your talking my kind of tipple, other than that Red Beard, Bank Top Blonde, Bad to the Bone, Sweeney's or Barley to Beer are by far a...

SQLDBA360 (6/11/2012)

---

Tried these last week, imagine the looks you get when you tell folkes that you had 2 pints of http://www.stonehengeales.co.uk/pigswill.html and a http://www.ratebeer.com/beer/bank-top-old-slapper/35536/.

Sounds like a night out wit Wayne...

I'll second that with Waitrose, nearest one is in Manchester city center and is quite small so the selection is limited, other than that the biggest one is in Cheadle....

As Asda have a 2 for £3 deal on ale, I thought it would be rude of me not to pick up a few new ones to try and I...