Add Category to SQL Full-text

I'm moving my STS sites to WSS, and I'm running into a bit of a
problem. We've got everyone on our team adding a category to their
documents to help us search and organize them. However, seach under
WSS (w/ SQL and Free-Text search) doesn't pick up the category field
in my Word documents.
I saw some talk about adding it via SQL so it appears in searchs
through Sharepoint, but I've no idea how. Any suggestions or
instructions that could help me out here?
that's correct. SQL FTS only indexes documents contents when they are stored
in the image data type columns. It doesn't index properties. You would have
to extract the property and store it separately in a column in the table you
are full text indexing.
"Elroy" <derekvof@.yahoo.com> wrote in message
news:47f03009.0403231310.5344561b@.posting.google.c om...
> I'm moving my STS sites to WSS, and I'm running into a bit of a
> problem. We've got everyone on our team adding a category to their
> documents to help us search and organize them. However, seach under
> WSS (w/ SQL and Free-Text search) doesn't pick up the category field
> in my Word documents.
> I saw some talk about adding it via SQL so it appears in searchs
> through Sharepoint, but I've no idea how. Any suggestions or
> instructions that could help me out here?

Activity log backup

My company requires a 6 month retention of the archive activity logs for
SQL2000 servers. I need a job that will run each night moving the logs to an
archive file naming the logs to date.logs leaving only the "Current-date
time" log. I have set up the sp-cycle-errorlog to run each night. This
creates a new log in the number sequence.
Any assistance is greatly appreciated. Thanks.
Jerry
Hi
You may want to check out http://www.sqldts.com/default.aspx?292
John
"Jerry" wrote:

> My company requires a 6 month retention of the archive activity logs for
> SQL2000 servers. I need a job that will run each night moving the logs to an
> archive file naming the logs to date.logs leaving only the "Current-date
> time" log. I have set up the sp-cycle-errorlog to run each night. This
> creates a new log in the number sequence.
> Any assistance is greatly appreciated. Thanks.
> --
> Jerry

Activity log backup

My company requires a 6 month retention of the archive activity logs for
SQL2000 servers. I need a job that will run each night moving the logs to a
n
archive file naming the logs to date.logs leaving only the "Current-date
time" log. I have set up the sp-cycle-errorlog to run each night. This
creates a new log in the number sequence.
Any assistance is greatly appreciated. Thanks.
--
JerryHi
You may want to check out http://www.sqldts.com/default.aspx?292
John
"Jerry" wrote:

> My company requires a 6 month retention of the archive activity logs for
> SQL2000 servers. I need a job that will run each night moving the logs to
an
> archive file naming the logs to date.logs leaving only the "Current-date
> time" log. I have set up the sp-cycle-errorlog to run each night. This
> creates a new log in the number sequence.
> Any assistance is greatly appreciated. Thanks.
> --
> Jerry

Activity log backup

My company requires a 6 month retention of the archive activity logs for
SQL2000 servers. I need a job that will run each night moving the logs to an
archive file naming the logs to date.logs leaving only the "Current-date
time" log. I have set up the sp-cycle-errorlog to run each night. This
creates a new log in the number sequence.
Any assistance is greatly appreciated. Thanks.
--
JerryHi
You may want to check out http://www.sqldts.com/default.aspx?292
John
"Jerry" wrote:
> My company requires a 6 month retention of the archive activity logs for
> SQL2000 servers. I need a job that will run each night moving the logs to an
> archive file naming the logs to date.logs leaving only the "Current-date
> time" log. I have set up the sp-cycle-errorlog to run each night. This
> creates a new log in the number sequence.
> Any assistance is greatly appreciated. Thanks.
> --
> Jerry