I’ve some experienced using SQL Detective (SD) in few month, though its so powerfull but its still have some bugs that always raised. Here is list of bugs in SQL Detective version 4.0 Release 2 build 22 :
1. Replace text tool (known as replace all in some application)
Sql detective is usually miss replacing texts.
2. Truncate/Alter table
As I mention before that SD is always terminated/stack right after some table truncated.
3. Drop index
Sometime SD, raised exception in assembler when I try to drop some index
4. Alter table5. Square Characters usually show when procedure compiled or replacing text
ex : CREAT6. Compile Object
ex : SQLDetective has experienced an error.
Error message: CREATE [OR REPLACE] statement is missing.
Error time: 8/1/2008 10:27:24 am
5. Access violation raised when accessing table with database link.
6. Open object dialog always show the different procedure