RichardB (11/6/2008)

---

How do you guys handle moving large files across networks - not just local networks but ones with a high enough rtt that ftp becomes a bit pointless?

Any good...

1. Backups are a must... the more backups the better

2. Document your flipping database. With that, consistent naming of database columns and consistent use of the same data types...

Matt Miller (10/2/2008)

---

Actually - if I were to ignore the cursor in your code for a minute, all you need to do to make your code work is to initialize...

Thanks a ton!

Well the typical string in this case that I'm considering ROT13'ing is about 10 characters long.

It's a device id... we have several devices that connect to a fax server. ...

The problem with this plan is that CLR doesn't work on SQL 2000.

Yes this is the SQL 2005 forum. But... what I'm working on needs to run on both......

If I remember right the account running the SQL Agent is used to access the UNC...

Since we lock our service accounts down tighter than drums... likely it doesn't have the...

After a lot of work on this project... I eventually gave up...

I either had one of two problems.

Since I was working on a proprietary data source

1. corrupted data in the...

Neither of them seem to like UNC paths either... :/

I had read that xp_fileexists was supposed to work nicely with UNC's... since it hates mapped drives... but alas...

The file names are (in/out) + recipientid + .zfx...

I can if I must... I'd rather avoid them...

No the files will...

The best thing I can think of...

If the number of records you will have left is significantly less than the number you are deleting.

Look into selecting what you want to...

Yah I was going to jump all over this RBAR stuff... but Phil beat me to it.

I forsee Jeff M coming along and bopping you on your head too 🙂

Ummm why not

SELECT

vs.[State],

vs.CountyName,

vs.City,

...