There's a bad link in the comment above to the comparison of issue trackers, so I've corrected it in this post.
ctrager
@ctrager
Best posts made by ctrager
Latest posts made by ctrager
-
RE: Ask WTF: bug tracking?
-
RE: Ask WTF: bug tracking?
I'm the author of BugTracker.NET, which, readers, is free and open source. Through working on it I have become nosy about other bug trackers. Gemini might be the best fit. If you are satisfied, call it a day, but if not, then two more you might want to consider are OnTime and Jira which both work on SQL Server. I don't know if they fit your criteria, but they might, and both have their fans (as does Gemini).
About BugTracker.NET itself, you can add whatever custom fields you want very easily, including version found, version fixed, etc. You are right that you can't clone one bug into another, but there is a "save/use preset" feature that lets you save a half dozen fields from one bug and use them in another. You can create relationships between bugs. It has terrific Subversion integration.
Just for folks in your situation, I've put together a page of links to postings on the web like yours, people who have written a comparison of issue trackers.