Hey Seth,

Got it! nvarchar(512) takes 1024 bytes because it's unicode. Since my windows paths are always ASCII, I could have declared the column in the table as varchar(512) which takes 512 bytes.

It works, thanks to some "DBA in the making" on another forum.

Venkat Renuka Prasad Sahukara.