How to avoid appending incremental number to filename I don't want Drupal to add incremental numbers to my file names to make them unique. I want to always have files stored with the same name they had when I uploaded them. 

If the file with given name already exist, "Replace already existing file?" prompt should appear instead of default behaviour.
The Upload File Replace module should do the trick:


  Module Page Description
  
  This is a small utility module that automatically stops Drupal from
  renaming new files upload via filefield CCK. When 2 files with the
  same name exist, the older files will be renamed.


Edit: Sorry, I missed the part where you are expecting a prompt. According to the comment below, it is not possible.