all groups > sql server full text search > september 2003 > threads for september 22 - 28, 2003
Filter by week: 1 2 3 4 5
searching inside a image column
Posted by vishal at 9/27/2003 1:52:41 AM
Hi
I have stored my word doucument inside a column of type
image in sql 2000. I have created a full text index on
this column and also have cretaed a column that specifies
the type of file as ".doc". I am not able to search inside
the stored document.
Please guide me .
Thanks
... more >>
SQL 6.5 .mdf is at capacity...
Posted by Sheryl at 9/26/2003 5:34:35 AM
I was wondering if someone could give me an idea of what
would be the best procedure to follow if the database is
at capacity? It was set to 500mb and that is what it is
at now; the users are unable to use their application.
Any assistance would be greatly appreciated!
... more >>
Maintaining the .LDF (log) file
Posted by Jack at 9/25/2003 8:04:20 PM
I have a .LDF (log) file that has grown to 5GB.
Could you recommend a safe procedure to complete the
following?
1) Backup up Timeport_log.LDF
2) Remove all data from Timeport_log.LDF so that only
one or more days of log information is contained in this
file.
Could you provide recommend... more >>
Importing Catalog files
Posted by Naser geraminia at 9/24/2003 11:27:14 PM
Hi all
I have a database in my old SqlServer 2000 on computer1,
which named x.mdf. I have Fulltext catalogs on this
database.
Next, i transfered the x.mdf and catalog files seprately
to computer 2. i attached the x.mdf to new SqlServer 2000
on computer2.
now can i import catalog files fr... more >>
Install these patch for Windows
Posted by Király Illés at 9/23/2003 10:39:00 PM
Microsoft Consumer
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which resolves
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now t... more >>
Watch the security package from the Microsoft Corp.
Posted by r frieson at 9/23/2003 5:25:18 PM
Microsoft User
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to ... more >>
are these groups still moderated?
Posted by Andy Svendsen at 9/23/2003 10:09:15 AM
It is bad enough that my email address got harvested for the fake Microsoft
IE 4.01 product alert email that has a virus attachment as a security patch.
But I think the posts should be more closely censored as you can see from
some of the posts in this newsgroup.
--
***********************... more >>
Fulltext Search Problem
Posted by goku24_dc NO[at]SPAM yahoo.com at 9/23/2003 6:27:54 AM
I have a table with book titles. Let's say some of the titles are
"Science", "Journal of Science", "Great Adventures in Science",
"People in Science", and others. When the user searches based on the
keyword "Science", all book title with the word science in them should
be returned. This works... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Error message when searching for reserved words.
Posted by omar NO[at]SPAM designlevel2.com at 9/22/2003 11:15:07 AM
I have gotten an odd response from a client of mine. They would like
to alter the error message when a user searches for reserved words.
For example if a user searches ('if'), why they would do that I dont
know, I need to alter the feedback the user gets on their end. Has
anyone run into this pr... more >>
Fulltext Spreed
Posted by Naser geraminia at 9/22/2003 7:49:57 AM
Hi all
My Fulltext Populating speed decreases progressively.
Thus I set Resource_usage to 5, but Populating didn't use
100% of Cpu and Ram (estamated:40%).
I think that the problem's cause is I/O rate.
Can i have Fulltext catalogs On Ram for increasing the
speed?
Thanks...... more >>
Performance Issues when using CONTAINSTABLE
Posted by Shadowfax at 9/22/2003 3:37:12 AM
I have a number of tables with Full Text Indexing set up
on some of the columns.
The problem is that performance is badly affected when
retrieving rows using CONTAINSTABLE, as in the following:
INSERT INTO temp_Placements(PlacementID, UserID, Switch)
SELECT DISTINCT PlacementInfo3.P... more >>
|