Hi FerSher,

We also use VSS 2005 to track version history of our stored procedures. We use Visual Studio 2005 to manage the whole process.

If you don't have Visual Studio...

JohnG (6/3/2008)

---

Several things (from experience).

1. Note that the CONTAINS function can utilize a variable. See the BOL. So you can build the search string in your application and...

Hi,

Thanks for taking the time to reply to this - the noise file definitely makes sense, I just didn't know it existed! I'll give this a try when I'm...

saravanrp (6/2/2008)

---

Hi,

If you want to use contains then you can't use like what you did it.

where contains(@field1,'"5 AND day"') -- This is wrong, because in full text search every word...

Hi,

Thanks for your reply! I'll format the string before I pass it into the procedure then.

One other question if you wouldn't mind answering it; Some of the strings I'm...

Sorry, just had a thought; should I be formatting the search string before calling the stored procedure? So in the code that calls the stored proc, I could change...

Thanks Jeff, much appreciated.

Jeff,

Thanks for taking the time to write and also for those excellent links!

You've said that every row in the table gets scanned using the method I'd described; is that only...