Custom procedure using Freetext/Contains

[GoogleCodeExporter]

It seems that NetTiers does not recognize custom stored procedures containing 
FREETEXT or CONTAINS in WHERE clause. 

I am running SQL Server 2008 Express Edition 

CREATE PROCEDURE [dbo].[_People_FindFullTextData] 
(  
    @Keywords nvarchar(256) 
) 
AS

SELECT 
[Id],
[FullTextName],
...
...
...
FROM [Ajq].[dbo].[People] 
WHERE CONTAINS([FullTextName], @Keywords) 

Original issue reported on code.google.com by jannoj...@gmail.com on 24 Apr 2011 at 9:46

[GoogleCodeExporter]

Hello,

I have not been able to reproduce this behavior. I created this stored 
procedure and then created a second with a generic where clause. Both of them 
were generated. I would do a search in the source code for FindFullTextData. 
Does it show up? Also I would recommend debugging the matching logic by doing a 
find for the Stored Procedure Pattern Property (The one that defaults to 
_{0}_). I would see if this stored procedure is being matched or even loaded. 
Does this procedure show up in the Database Explorer?

Thanks
-Blake Niemyjski

Original comment by bniemyjski on 27 Apr 2011 at 7:45

• Changed state: AwaitingInfo