Try using the undocumented sp

xp_fileexist

There  is various sites where you read up on the usage