FullText

Hello,

I am using SQL 2005 and SQL Server Management Studio.

How can I activate FullText in my database?
Or should I do this only for the tables where I need it?
How can I do this?

Thank You,
Miguel

Try the thread below I have posted most of the information you will need and why it may not work in Express and if you are in Express the second thread covers some work around solution. Hope this helps.

http://forums.asp.net/thread/1460813.aspx

http://forums.asp.net/thread/1446828.aspx

FullText

Hello,
I am using SQL 2005 and SQL Server Management Studio.
How can I activate FullText in my database?
Or should I do this only for the tables where I need it?
How can I do this?
Thank You,
Miguel
Hi
Take a look at this article in the BOL
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/fulltxt9/html/db3747e0-db12-4c69-9d81-b5011984eb3a.htm
"shapper" <mdmoura@.gmail.com> wrote in message
news:1165763736.508363.291910@.n67g2000cwd.googlegr oups.com...
> Hello,
> I am using SQL 2005 and SQL Server Management Studio.
> How can I activate FullText in my database?
> Or should I do this only for the tables where I need it?
> How can I do this?
> Thank You,
> Miguel
>
sql

FullText

Hello,
I am using SQL 2005 and SQL Server Management Studio.
How can I activate FullText in my database?
Or should I do this only for the tables where I need it?
How can I do this?
Thank You,
MiguelHi
Take a look at this article in the BOL
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/fulltxt9/html/db3747e0-db12-4c69-9d81-
b5011984eb3a.htm
"shapper" <mdmoura@.gmail.com> wrote in message
news:1165763736.508363.291910@.n67g2000cwd.googlegroups.com...
> Hello,
> I am using SQL 2005 and SQL Server Management Studio.
> How can I activate FullText in my database?
> Or should I do this only for the tables where I need it?
> How can I do this?
> Thank You,
> Miguel
>

FullText

Hello,
I am using SQL 2005 and SQL Server Management Studio.
How can I activate FullText in my database?
Or should I do this only for the tables where I need it?
How can I do this?
Thank You,
MiguelHi
Take a look at this article in the BOL
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/fulltxt9/html/db3747e0-db12-4c69-9d81-b5011984eb3a.htm
"shapper" <mdmoura@.gmail.com> wrote in message
news:1165763736.508363.291910@.n67g2000cwd.googlegroups.com...
> Hello,
> I am using SQL 2005 and SQL Server Management Studio.
> How can I activate FullText in my database?
> Or should I do this only for the tables where I need it?
> How can I do this?
> Thank You,
> Miguel
>

Fulltable scan/sec - How to resolve

Hi All,

When we did PT for our application, Full Scans/sec is really huge and it is between 75 to 150. When we did stress testing, it is above 500.

Please help me in identifying the problem that causes too much of FT scans.

I tried doing this, but I'm not sure whether the approach is correct:

Step 1. Create performance log counter against SQLServer:Access Methods\Full Scans/sec
(Results as)
Time \SQLServer:Access Methods\Full Scans/sec
07/19/2006 04:56:03 PM 13.518823923
07/19/2006 04:56:13 PM 3.600423705
07/19/2006 04:56:23 PM 30
07/19/2006 04:56:33 PM 10.099895061

Step 2. Create Trace (using SQL Profiler)
Start both the Performance log and SQL Profiler at same time.

Step 3. Pick a time duration from Performance Log results and identify the queries that got executed during this time frame using Profiler.

Step 4. From Profiler results, identify the queries that got executed and evaluate the query plan of these queries.
Here I'm not clear with the queries that i pick, because there are different eventclass during this time like RPC:Completed,SQL:BatchStarting, SQL:BatchCompleted. I did analysis on "TextData" only against RPC:Completed and counted on Table/Clustered Index Scans from Query Plan.

Full Scans/sec. isn't always an indicator of a problem needing resolution. For instance, if I have a read-only lookup table that has 5 rows, chances are, I won't pay much attention to indexing this column. If it's used a lot, then you'll likely see a table scan every time. Is that a problem? Maybe, maybe not. If reading 5 rows (probably a single IO) from a table is your only application bottleneck, fixing it may take higher priority.

So, make sure that you're really looking at a problem that needs to be solved. Regarding your question, it sounds like you're on the right track. Find the plan events, and then locate the ones that have Table Scans in the operator tree.

Thanks,
--R

Fullt Text Search fails in a 2 node cluster

Hi!
I have a problem with Full Text Search in a clustered enviroment.
The Resource Fullt Text Search will not come online, it fails and giving me
a error in the log that says
"An Error occurred during the online operation for instance <SQL Server
Fulltext (UTB2)>: 80070002 - the system cannot find the file specified."
I′ve tried to reinstall Full Text by reading the KB 827449, but when i get
to the part where i should use the command "ftsetup.exe" i get a error in the
application log saying:
"Faulting application ftsetup.exe, version 2000.80.2039.0 faulting module
msvcr71.dll, version 7.10.3052.4, fault adress 0x00014d5c."
I also get a similar error concerning msvcrt.dll version 7.0.3790.1830.
We are using Windows 2003 SP1 and SQL 2000 Enterprise edition SP4
The strange about this is that right now there are 4 instances on the same
node where 2 of them has full text online and working but the 2 others has
the error mentioned above, so as i can understand there are no problem with
the nodes but instead i believe that the instances is not aware of Microsoft
Search. therefore as the KB article says i need to run the command
FTSETUP.EXE to configure the instances with Microsoft Search.
Right now i have no other ideas, fearing that the only thing to solve this
is to reinstall the whole SQL instance :o( wich is nothing i′m looking
forward to.
So please if you have any ideas, fill me in...
SweGuy
Sweden
Look in the FTData folder for each instance for files called Clus0.0,
clus0.1 etc. If those are not there, you may want to consider calling PSS
on this, as clustered FT issues are very difficult to troubleshoot.
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
http://kevin3nf.blogspot.com
"SweGuy" <SweGuy@.discussions.microsoft.com> wrote in message
news:FB3CFE0A-FDB8-4DE6-ACD0-9395599AE818@.microsoft.com...
> Hi!
> I have a problem with Full Text Search in a clustered enviroment.
> The Resource Fullt Text Search will not come online, it fails and giving
> me
> a error in the log that says
> "An Error occurred during the online operation for instance <SQL Server
> Fulltext (UTB2)>: 80070002 - the system cannot find the file specified."
> Ive tried to reinstall Full Text by reading the KB 827449, but when i get
> to the part where i should use the command "ftsetup.exe" i get a error in
> the
> application log saying:
> "Faulting application ftsetup.exe, version 2000.80.2039.0 faulting module
> msvcr71.dll, version 7.10.3052.4, fault adress 0x00014d5c."
> I also get a similar error concerning msvcrt.dll version 7.0.3790.1830.
> We are using Windows 2003 SP1 and SQL 2000 Enterprise edition SP4
> The strange about this is that right now there are 4 instances on the same
> node where 2 of them has full text online and working but the 2 others has
> the error mentioned above, so as i can understand there are no problem
> with
> the nodes but instead i believe that the instances is not aware of
> Microsoft
> Search. therefore as the KB article says i need to run the command
> FTSETUP.EXE to configure the instances with Microsoft Search.
> Right now i have no other ideas, fearing that the only thing to solve this
> is to reinstall the whole SQL instance :o( wich is nothing im looking
> forward to.
> So please if you have any ideas, fill me in...
> --
> SweGuy
> Sweden
|||Yes the FDATA folder exist and i have also granted both the SQL and the
Cluster Service Account full control to the folder. Also checked permissions
in the registry. It looks OK everywhere but it fails on the DLLs mentioned
before.
SweGuy
IT Professional
Sweden
"Kevin3NF" wrote:

> Look in the FTData folder for each instance for files called Clus0.0,
> clus0.1 etc. If those are not there, you may want to consider calling PSS
> on this, as clustered FT issues are very difficult to troubleshoot.
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> http://kevin3nf.blogspot.com
>
> "SweGuy" <SweGuy@.discussions.microsoft.com> wrote in message
> news:FB3CFE0A-FDB8-4DE6-ACD0-9395599AE818@.microsoft.com...
>
>
|||does this help?
http://www.indexserverfaq.com/clusterfailure.htm
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"SweGuy" <SweGuy@.discussions.microsoft.com> wrote in message
news:FB3CFE0A-FDB8-4DE6-ACD0-9395599AE818@.microsoft.com...
> Hi!
> I have a problem with Full Text Search in a clustered enviroment.
> The Resource Fullt Text Search will not come online, it fails and giving
> me
> a error in the log that says
> "An Error occurred during the online operation for instance <SQL Server
> Fulltext (UTB2)>: 80070002 - the system cannot find the file specified."
> Ive tried to reinstall Full Text by reading the KB 827449, but when i get
> to the part where i should use the command "ftsetup.exe" i get a error in
> the
> application log saying:
> "Faulting application ftsetup.exe, version 2000.80.2039.0 faulting module
> msvcr71.dll, version 7.10.3052.4, fault adress 0x00014d5c."
> I also get a similar error concerning msvcrt.dll version 7.0.3790.1830.
> We are using Windows 2003 SP1 and SQL 2000 Enterprise edition SP4
> The strange about this is that right now there are 4 instances on the same
> node where 2 of them has full text online and working but the 2 others has
> the error mentioned above, so as i can understand there are no problem
> with
> the nodes but instead i believe that the instances is not aware of
> Microsoft
> Search. therefore as the KB article says i need to run the command
> FTSETUP.EXE to configure the instances with Microsoft Search.
> Right now i have no other ideas, fearing that the only thing to solve this
> is to reinstall the whole SQL instance :o( wich is nothing im looking
> forward to.
> So please if you have any ideas, fill me in...
> --
> SweGuy
> Sweden
|||I have opened a case with Microsoft Support. Hopefully we can clear this out.
I′l let you know how it goes.
SweGuy
IT Professional
Sweden
"Hilary Cotter" wrote:

> does this help?
> http://www.indexserverfaq.com/clusterfailure.htm
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "SweGuy" <SweGuy@.discussions.microsoft.com> wrote in message
> news:FB3CFE0A-FDB8-4DE6-ACD0-9395599AE818@.microsoft.com...
>
>
|||Who got your case? I mean the support engineer at MS...
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"SweGuy" <SweGuy@.discussions.microsoft.com> wrote in message
news:01CAF11F-F93A-44B5-9631-206DCB2885D0@.microsoft.com...[vbcol=seagreen]
>I have opened a case with Microsoft Support. Hopefully we can clear this
>out.
> Il let you know how it goes.
> --
> SweGuy
> IT Professional
> Sweden
>
> "Hilary Cotter" wrote:
|||I have no specific name but the guy i talked to in the phone was Daniel
Berglund. He has passed the problem forward to other support engineers.
Apperently this kind of problems ususally result in a re-installation of the
SQL instance, but Daniel thought that maybe someone has solved this matter in
another way.
And thats what i′m hoping for :o)
SweGuy
IT Professional
Sweden
"Kevin3NF" wrote:

> Who got your case? I mean the support engineer at MS...
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "SweGuy" <SweGuy@.discussions.microsoft.com> wrote in message
> news:01CAF11F-F93A-44B5-9631-206DCB2885D0@.microsoft.com...
>
>
|||Yup. The only "Official" way to fix most full-text resource issues is
uninstall/re-install.
Download filemon from sysinternals to get the exact file and path it is
looking for and go from there...
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"SweGuy" <SweGuy@.discussions.microsoft.com> wrote in message
news:FD031460-357C-414A-A2E4-2B69293DC12F@.microsoft.com...[vbcol=seagreen]
>I have no specific name but the guy i talked to in the phone was Daniel
> Berglund. He has passed the problem forward to other support engineers.
> Apperently this kind of problems ususally result in a re-installation of
> the
> SQL instance, but Daniel thought that maybe someone has solved this matter
> in
> another way.
> And thats what im hoping for :o)
> --
> SweGuy
> IT Professional
> Sweden
>
> "Kevin3NF" wrote:

Fulldatabase backup query

SQL Server full backup displays the following message on successful
completion of the full database backup.
Processed 1136 pages for database 'MyDB', file 'MyDB' on file 1.
Processed 3 pages for database 'MyDB', file 'MyDB_log' on file 1.
BACKUP DATABASE successfully processed 1139 pages in 0.902 seconds (10.336
MB/sec).
I understand SQL Server manages data files in the form of pages and thats
the reason on completion of backup it display message "Processed 1136 pages
for database 'MyDB', file 'MyDB' on file 1". But why does it display message
"Processed 3 pages for database 'MyDB', file 'MyDB_log' on file 1" when the
transaction log files are not managed in the form of pages.
Hi
When BACKUP started , it reads (backups) all data pages and last step it
goes to LOG file and reads/backups all the data in the LOG from the point
the BACKUP was started
"Balaji" <Balaji@.discussions.microsoft.com> wrote in message
news:CA26E224-37C4-4C61-8F37-579C7A357DE7@.microsoft.com...
> SQL Server full backup displays the following message on successful
> completion of the full database backup.
> Processed 1136 pages for database 'MyDB', file 'MyDB' on file 1.
> Processed 3 pages for database 'MyDB', file 'MyDB_log' on file 1.
> BACKUP DATABASE successfully processed 1139 pages in 0.902 seconds (10.336
> MB/sec).
> I understand SQL Server manages data files in the form of pages and thats
> the reason on completion of backup it display message "Processed 1136
> pages
> for database 'MyDB', file 'MyDB' on file 1". But why does it display
> message
> "Processed 3 pages for database 'MyDB', file 'MyDB_log' on file 1" when
> the
> transaction log files are not managed in the form of pages.
>
sql