Erin Ramsay (3/4/2013)
Booyah, Lowell! You hit it. I forgot to define the size of my stored proc variables.Good catch!
IIRC, that maximum size for a DOS Path is 512 bytes. Not sure what it is for a UNC but I'd bullet proof the code a bit by making the variables on both ends with a width of at least 512 or maybe even 1024.
--Jeff Moden
Change is inevitable... Change for the better is not.