I have a major issue with an application that I wrote last year.
The business I wrote it for changed from a Win2000 Server to Win2003 SBS. They installed SQL 2000, and we moved over the application. It was previously using SQL7 on the 2000 machine.
Anyway, the application searches through the fields and finds data on their film projects. The idea being that they can lease some stock footage, or even reuse some they may have already. It used to work great.
Now, however, when they do a search looking for "all of" in the fields, it returns 0 results. The "any of" works still. The query had to change based on the differences of the server, but it works just great. The query analyzer works, and returns 300-or-so results...which is the desired effect. However, in the application, it does not. I know it's right, because I can search on some items, and I can get some limited results, but they seem to only be finding words in the "description" field.
It appears that it is only searching through the description of the footage shots, but not the medium (for example: film or video) or the actual show they were filming it for. All of those fields (columns) are in the FT catalog, and I've had another person watch to make sure I included them when I rebuilt it.
Now, here's the thing. The EXACT same coding works on an EXACT version of SQL 2000, but it's on a Win2003 Standard Server (not SBS). The Standard server is not theirs, so it can't stay there. The same data is in that DB, and it works just great. So I know it's not my coding, I know it's not my Query, and I know it's not the data.
Is there any reason that this SBS server might not search all the fields or all the fields may not populate properly in the Full Text Catalog?
This has been going on for months, and I'm completely out of ideas. Can anyone suggest anything?
Thanks for any and all thoughts.
rob
The business I wrote it for changed from a Win2000 Server to Win2003 SBS. They installed SQL 2000, and we moved over the application. It was previously using SQL7 on the 2000 machine.
Anyway, the application searches through the fields and finds data on their film projects. The idea being that they can lease some stock footage, or even reuse some they may have already. It used to work great.
Now, however, when they do a search looking for "all of" in the fields, it returns 0 results. The "any of" works still. The query had to change based on the differences of the server, but it works just great. The query analyzer works, and returns 300-or-so results...which is the desired effect. However, in the application, it does not. I know it's right, because I can search on some items, and I can get some limited results, but they seem to only be finding words in the "description" field.
It appears that it is only searching through the description of the footage shots, but not the medium (for example: film or video) or the actual show they were filming it for. All of those fields (columns) are in the FT catalog, and I've had another person watch to make sure I included them when I rebuilt it.
Now, here's the thing. The EXACT same coding works on an EXACT version of SQL 2000, but it's on a Win2003 Standard Server (not SBS). The Standard server is not theirs, so it can't stay there. The same data is in that DB, and it works just great. So I know it's not my coding, I know it's not my Query, and I know it's not the data.
Is there any reason that this SBS server might not search all the fields or all the fields may not populate properly in the Full Text Catalog?
This has been going on for months, and I'm completely out of ideas. Can anyone suggest anything?
Thanks for any and all thoughts.
rob
