Try this:
ALTER PROCEDURE [dbo].[spGetFilesForTitle]
@PartName NVARCHAR(MAX)
AS
BEGIN
SELECT d.ID, d.Title, f.* FROM Documents d
JOIN DiskFile f ON f.DocId = d.ID
WHERE d.Title LIKE '%' + @PartName + '%'
END
It's what I use ... and it works just fine.