Hi all,
We are devloping reports in the regional language. When we create a report
for the indian language kannada we are not able to see the text we are only
seeing "?" . Our OS is Windows XP and when we export reports to tiff format
we are able to see the kannada characters.
can you helpTo start with, make sure that exact font is available on both the server and
all the clients that attempt to view the PDF file. We do not embed the
fonts into the PDF documents.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Srini" <Srini@.discussions.microsoft.com> wrote in message
news:E7A0B237-BF36-4228-86BB-C20D00A9DCD0@.microsoft.com...
> Hi all,
> We are devloping reports in the regional language. When we create a report
> for the indian language kannada we are not able to see the text we are
> only
> seeing "?" . Our OS is Windows XP and when we export reports to tiff
> format
> we are able to see the kannada characters.
> can you help
Showing posts with label text. Show all posts
Showing posts with label text. Show all posts
Wednesday, March 21, 2012
Indexing Word Docs
We currently have an application that OCRs a tif image and places the
recognized text in a SQL table.
The table is then indexed by the FTS service.
The app then allows you to search for any of the text and display the
corresponding tif image in a viewer.
I would also like to be able to search WORD docs for their contents using
the same catalog.
What is the proper manner to have the WORD docs indexed by the FTS service?
Do I need to extract the text from the WORD doc and store it in the table
much like the recognized text
from the OCR process?
Thanks
John,
What is the relationship between FTS and Indexing Service?
It looks like the Indexing Service maintains a catalog much the same as FTS.
We have support for WORD in our app already by storing the WORD doc in our
file warehouse on the file system.
We can display the .doc file in our viewer the same as a .tif image.
We currently don't have functionality to search for data in the WORD docs,
only text from the OCR process.
Since the WORD file is already stored in the file system and referenced by
our application, I was wondering about the feature that is titled "Full-text
Querying of File Data"
It looks like it uses the Index Service to allow searching for data in files
on the file system.
Wouldn't that work for my scenario?
It appears that when we want to search for data contained in a WORD doc, we
would use the SCOPE function in our query. Otherwise, we continue to search
for text from the OCR process.
Can you provide some insight?
Thanks
"John Kane" <jt-kane@.comcast.net> wrote in message
news:O7TiL6BWEHA.2928@.tk2msftngp13.phx.gbl...
> Binder,
> What version of SQL Server (2000 or 7.0) and on what OS platform (NT4.0,
> Win2K, or Win2003) is it installed? Could you post the full output of
> SELECT @.@.version -- as this is helpful to answering your question.
> If you are using SQL Server 2000, you can use it's new feature (this
feature
> is not present in SQL 7.0) - from SQL Sever 2000 BOL title "Filtering
> Supported File Types". This feature allows you to store the binary version
> of the MS Word document and then in your table define a file extension
> column and populate it with the correct values ("doc" for MS Word
document)
> and then run a Full Population and then you can use the CONTAINS or
FREETEXT
> quires to FTS the contents of these files stored in a sql table>
> If you are using SQL Server 7.0, you will need to setup a process to
extract
> the MS Word text and then store this text in a TEXT column and the FT
Index[vbcol=seagreen]
> that column, much as you do for your OCR'ed data.
> Regards,
> John
>
> "Binder" <rgondzur@.NO_SPAM_aicsoft.com> wrote in message
> news:eIXu546VEHA.2716@.tk2msftngp13.phx.gbl...
using[vbcol=seagreen]
> service?
table
>
|||System Parameters:
Windows 2000 Server
Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
"Binder" <rgondzur@.NO_SPAM_aicsoft.com> wrote in message
news:OcUOqQGWEHA.1012@.TK2MSFTNGP09.phx.gbl...
> John,
> What is the relationship between FTS and Indexing Service?
> It looks like the Indexing Service maintains a catalog much the same as
FTS.
> We have support for WORD in our app already by storing the WORD doc in our
> file warehouse on the file system.
> We can display the .doc file in our viewer the same as a .tif image.
> We currently don't have functionality to search for data in the WORD docs,
> only text from the OCR process.
> Since the WORD file is already stored in the file system and referenced by
> our application, I was wondering about the feature that is titled
"Full-text
> Querying of File Data"
> It looks like it uses the Index Service to allow searching for data in
files
> on the file system.
> Wouldn't that work for my scenario?
> It appears that when we want to search for data contained in a WORD doc,
we
> would use the SCOPE function in our query. Otherwise, we continue to
search[vbcol=seagreen]
> for text from the OCR process.
> Can you provide some insight?
> Thanks
>
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:O7TiL6BWEHA.2928@.tk2msftngp13.phx.gbl...
> feature
version
> document)
> FREETEXT
> extract
> Index
> using
> table
>
|||Binder,
Q. What is the relationship between FTS and Indexing Service?
A. While they use the same underlying Microsoft Search Technology, they full
text index different servers. Indexing Service handles the server's files on
its local disk drive, while FTS (or really the "Micrsoft Search" service
[mssearch.exe]) full text indexes textaul (char, nvarchar, text, etc.)
columns in SQL Server tables. Yes, it seems to me that using the Indexing
Service, should work for you.
What is the name of your app? Does it support SQL Server 2000? If so, does
it support the storage of MS Word documents in columns that are defined with
the IMAGE datatype? Is the feature that is titled "Full-text Querying of
File Data", a feature of your app, or are you referring to the feature of
SQL Severer (version) ?
In addition to SQL Server's Full-text Search (FTS) component, you can also
define a "Linked Server" to the Indexing Service via using MSIDX, the "OLE
DB Provider for Microsoft Indexing Service". You would define this linked
server via sp_addlinkedserver. Below is an example from SQL Server 2000
Books Online:
G. Use the Microsoft OLE DB Provider for Indexing Service
This example creates a linked server and uses OPENQUERY to retrieve
information from both the linked server and the file system enabled for
Indexing Service.
EXEC sp_addlinkedserver FileSystem,
'Index Server',
'MSIDXS',
'Web'
GO
USE pubs
GO
IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'yEmployees')
DROP TABLE yEmployees
GO
CREATE TABLE yEmployees
(
id int NOT NULL,
lname varchar(30) NOT NULL,
fname varchar(30) NOT NULL,
salary money,
hiredate datetime
)
GO
INSERT yEmployees VALUES
(
10,
'Fuller',
'Andrew',
$60000,
'9/12/98'
)
GO
IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS
WHERE TABLE_NAME = 'DistribFiles')
DROP VIEW DistribFiles
GO
CREATE VIEW DistribFiles
AS
SELECT *
FROM OPENQUERY(FileSystem,
'SELECT Directory,
FileName,
DocAuthor,
Size,
Create,
Write
FROM SCOPE('' "c:\My Documents" '')
WHERE CONTAINS(''Distributed'') > 0
AND FileName LIKE ''%.doc%'' ')
WHERE DATEPART(yy, Write) = 1998
GO
SELECT *
FROM DistribFiles
GO
SELECT Directory,
FileName,
DocAuthor,
hiredate
FROM DistribFiles D, yEmployees E
WHERE D.DocAuthor = E.FName + ' ' + E.LName
GO
Regards,
John
"Binder" <rgondzur@.NO_SPAM_aicsoft.com> wrote in message
news:OcUOqQGWEHA.1012@.TK2MSFTNGP09.phx.gbl...
> John,
> What is the relationship between FTS and Indexing Service?
> It looks like the Indexing Service maintains a catalog much the same as
FTS.
> We have support for WORD in our app already by storing the WORD doc in our
> file warehouse on the file system.
> We can display the .doc file in our viewer the same as a .tif image.
> We currently don't have functionality to search for data in the WORD docs,
> only text from the OCR process.
> Since the WORD file is already stored in the file system and referenced by
> our application, I was wondering about the feature that is titled
"Full-text
> Querying of File Data"
> It looks like it uses the Index Service to allow searching for data in
files
> on the file system.
> Wouldn't that work for my scenario?
> It appears that when we want to search for data contained in a WORD doc,
we
> would use the SCOPE function in our query. Otherwise, we continue to
search[vbcol=seagreen]
> for text from the OCR process.
> Can you provide some insight?
> Thanks
>
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:O7TiL6BWEHA.2928@.tk2msftngp13.phx.gbl...
> feature
version
> document)
> FREETEXT
> extract
> Index
> using
> table
>
recognized text in a SQL table.
The table is then indexed by the FTS service.
The app then allows you to search for any of the text and display the
corresponding tif image in a viewer.
I would also like to be able to search WORD docs for their contents using
the same catalog.
What is the proper manner to have the WORD docs indexed by the FTS service?
Do I need to extract the text from the WORD doc and store it in the table
much like the recognized text
from the OCR process?
Thanks
John,
What is the relationship between FTS and Indexing Service?
It looks like the Indexing Service maintains a catalog much the same as FTS.
We have support for WORD in our app already by storing the WORD doc in our
file warehouse on the file system.
We can display the .doc file in our viewer the same as a .tif image.
We currently don't have functionality to search for data in the WORD docs,
only text from the OCR process.
Since the WORD file is already stored in the file system and referenced by
our application, I was wondering about the feature that is titled "Full-text
Querying of File Data"
It looks like it uses the Index Service to allow searching for data in files
on the file system.
Wouldn't that work for my scenario?
It appears that when we want to search for data contained in a WORD doc, we
would use the SCOPE function in our query. Otherwise, we continue to search
for text from the OCR process.
Can you provide some insight?
Thanks
"John Kane" <jt-kane@.comcast.net> wrote in message
news:O7TiL6BWEHA.2928@.tk2msftngp13.phx.gbl...
> Binder,
> What version of SQL Server (2000 or 7.0) and on what OS platform (NT4.0,
> Win2K, or Win2003) is it installed? Could you post the full output of
> SELECT @.@.version -- as this is helpful to answering your question.
> If you are using SQL Server 2000, you can use it's new feature (this
feature
> is not present in SQL 7.0) - from SQL Sever 2000 BOL title "Filtering
> Supported File Types". This feature allows you to store the binary version
> of the MS Word document and then in your table define a file extension
> column and populate it with the correct values ("doc" for MS Word
document)
> and then run a Full Population and then you can use the CONTAINS or
FREETEXT
> quires to FTS the contents of these files stored in a sql table>
> If you are using SQL Server 7.0, you will need to setup a process to
extract
> the MS Word text and then store this text in a TEXT column and the FT
Index[vbcol=seagreen]
> that column, much as you do for your OCR'ed data.
> Regards,
> John
>
> "Binder" <rgondzur@.NO_SPAM_aicsoft.com> wrote in message
> news:eIXu546VEHA.2716@.tk2msftngp13.phx.gbl...
using[vbcol=seagreen]
> service?
table
>
|||System Parameters:
Windows 2000 Server
Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
"Binder" <rgondzur@.NO_SPAM_aicsoft.com> wrote in message
news:OcUOqQGWEHA.1012@.TK2MSFTNGP09.phx.gbl...
> John,
> What is the relationship between FTS and Indexing Service?
> It looks like the Indexing Service maintains a catalog much the same as
FTS.
> We have support for WORD in our app already by storing the WORD doc in our
> file warehouse on the file system.
> We can display the .doc file in our viewer the same as a .tif image.
> We currently don't have functionality to search for data in the WORD docs,
> only text from the OCR process.
> Since the WORD file is already stored in the file system and referenced by
> our application, I was wondering about the feature that is titled
"Full-text
> Querying of File Data"
> It looks like it uses the Index Service to allow searching for data in
files
> on the file system.
> Wouldn't that work for my scenario?
> It appears that when we want to search for data contained in a WORD doc,
we
> would use the SCOPE function in our query. Otherwise, we continue to
search[vbcol=seagreen]
> for text from the OCR process.
> Can you provide some insight?
> Thanks
>
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:O7TiL6BWEHA.2928@.tk2msftngp13.phx.gbl...
> feature
version
> document)
> FREETEXT
> extract
> Index
> using
> table
>
|||Binder,
Q. What is the relationship between FTS and Indexing Service?
A. While they use the same underlying Microsoft Search Technology, they full
text index different servers. Indexing Service handles the server's files on
its local disk drive, while FTS (or really the "Micrsoft Search" service
[mssearch.exe]) full text indexes textaul (char, nvarchar, text, etc.)
columns in SQL Server tables. Yes, it seems to me that using the Indexing
Service, should work for you.
What is the name of your app? Does it support SQL Server 2000? If so, does
it support the storage of MS Word documents in columns that are defined with
the IMAGE datatype? Is the feature that is titled "Full-text Querying of
File Data", a feature of your app, or are you referring to the feature of
SQL Severer (version) ?
In addition to SQL Server's Full-text Search (FTS) component, you can also
define a "Linked Server" to the Indexing Service via using MSIDX, the "OLE
DB Provider for Microsoft Indexing Service". You would define this linked
server via sp_addlinkedserver. Below is an example from SQL Server 2000
Books Online:
G. Use the Microsoft OLE DB Provider for Indexing Service
This example creates a linked server and uses OPENQUERY to retrieve
information from both the linked server and the file system enabled for
Indexing Service.
EXEC sp_addlinkedserver FileSystem,
'Index Server',
'MSIDXS',
'Web'
GO
USE pubs
GO
IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'yEmployees')
DROP TABLE yEmployees
GO
CREATE TABLE yEmployees
(
id int NOT NULL,
lname varchar(30) NOT NULL,
fname varchar(30) NOT NULL,
salary money,
hiredate datetime
)
GO
INSERT yEmployees VALUES
(
10,
'Fuller',
'Andrew',
$60000,
'9/12/98'
)
GO
IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS
WHERE TABLE_NAME = 'DistribFiles')
DROP VIEW DistribFiles
GO
CREATE VIEW DistribFiles
AS
SELECT *
FROM OPENQUERY(FileSystem,
'SELECT Directory,
FileName,
DocAuthor,
Size,
Create,
Write
FROM SCOPE('' "c:\My Documents" '')
WHERE CONTAINS(''Distributed'') > 0
AND FileName LIKE ''%.doc%'' ')
WHERE DATEPART(yy, Write) = 1998
GO
SELECT *
FROM DistribFiles
GO
SELECT Directory,
FileName,
DocAuthor,
hiredate
FROM DistribFiles D, yEmployees E
WHERE D.DocAuthor = E.FName + ' ' + E.LName
GO
Regards,
John
"Binder" <rgondzur@.NO_SPAM_aicsoft.com> wrote in message
news:OcUOqQGWEHA.1012@.TK2MSFTNGP09.phx.gbl...
> John,
> What is the relationship between FTS and Indexing Service?
> It looks like the Indexing Service maintains a catalog much the same as
FTS.
> We have support for WORD in our app already by storing the WORD doc in our
> file warehouse on the file system.
> We can display the .doc file in our viewer the same as a .tif image.
> We currently don't have functionality to search for data in the WORD docs,
> only text from the OCR process.
> Since the WORD file is already stored in the file system and referenced by
> our application, I was wondering about the feature that is titled
"Full-text
> Querying of File Data"
> It looks like it uses the Index Service to allow searching for data in
files
> on the file system.
> Wouldn't that work for my scenario?
> It appears that when we want to search for data contained in a WORD doc,
we
> would use the SCOPE function in our query. Otherwise, we continue to
search[vbcol=seagreen]
> for text from the OCR process.
> Can you provide some insight?
> Thanks
>
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:O7TiL6BWEHA.2928@.tk2msftngp13.phx.gbl...
> feature
version
> document)
> FREETEXT
> extract
> Index
> using
> table
>
Indexing text within pdf content as a text file
Hello everyone,
I have a very strange problem : I've installed SQL server 2005, create
a storage for full index and full text index on a table. I've also
installed Adobe IFilter. Searches are OK but only on one criteria I
have problem. let me explain.
I'm searching in files in database for "c#" and some pdf files returned
by search are not containing "c#". Opening these PDF files with notepad
and searching for string "c#" let me find out why this file is returned
by search... Is it really the problem or not ? (is seems to do the same
on word files too...)
Thanks for your help.
Regards,
Ben.
SQL FTS interprets C# as C#, but c# as c. So you need to capitalize the C in
your searches and content for this to work correctly.
Hilary Cotter
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
<benjamin.soulier@.gmail.com> wrote in message
news:1169490279.707200.130060@.a75g2000cwd.googlegr oups.com...
> Hello everyone,
> I have a very strange problem : I've installed SQL server 2005, create
> a storage for full index and full text index on a table. I've also
> installed Adobe IFilter. Searches are OK but only on one criteria I
> have problem. let me explain.
> I'm searching in files in database for "c#" and some pdf files returned
> by search are not containing "c#". Opening these PDF files with notepad
> and searching for string "c#" let me find out why this file is returned
> by search... Is it really the problem or not ? (is seems to do the same
> on word files too...)
> Thanks for your help.
> Regards,
> Ben.
>
|||Hello Hilary,
Thanks for your quick answer, but it seems that the problem still
remains : I was wondering if it has something to do with the full text
index in database, as I configured it to case insensitive.
Do I have to put it back to case sensitive to make it work ?
Do I have to change noise words files (I've already removed "C" letter
from neutral and english files) ?.
Hilary Cotter a crit :[vbcol=seagreen]
> SQL FTS interprets C# as C#, but c# as c. So you need to capitalize the Cin
> your searches and content for this to work correctly.
> --
> Hilary Cotter
> 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
>
> <benjamin.soulier@.gmail.com> wrote in message
> news:1169490279.707200.130060@.a75g2000cwd.googlegr oups.com...
|||I tried to do a test for myself on this :
I created a new table, with full text index in case sensitive mode,
adding documents to it.
I still get files not containing C# values (all types of documents).
I even tried to use CONTAINSTABLE and FREETEXTTABLE, but problem is the
same...
Any ideas ?
benjamin.soulier@.gmail.com a crit :[vbcol=seagreen]
> Hello Hilary,
> Thanks for your quick answer, but it seems that the problem still
> remains : I was wondering if it has something to do with the full text
> index in database, as I configured it to case insensitive.
> Do I have to put it back to case sensitive to make it work ?
> Do I have to change noise words files (I've already removed "C" letter
> from neutral and english files) ?.
> Hilary Cotter a crit :
|||I take it you are Swiss and using the German or French (or Italian) word
breakers. In these languages c# and C# are indexed as c and C# - a search on
c# or C# will match with c and c# (lower and upper case). English
unfortunately is the exception here. c# is indexed as c, and C# is indexed
as C#, the search is done on C# which will match with C# and a search on c#
will match with c.
Hilary Cotter
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
<benjamin.soulier@.gmail.com> wrote in message
news:1169542818.105342.131360@.a75g2000cwd.googlegr oups.com...
Hello Hilary,
Thanks for your quick answer, but it seems that the problem still
remains : I was wondering if it has something to do with the full text
index in database, as I configured it to case insensitive.
Do I have to put it back to case sensitive to make it work ?
Do I have to change noise words files (I've already removed "C" letter
from neutral and english files) ?.
Hilary Cotter a crit :[vbcol=seagreen]
> SQL FTS interprets C# as C#, but c# as c. So you need to capitalize the C
> in
> your searches and content for this to work correctly.
> --
> Hilary Cotter
> 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
>
> <benjamin.soulier@.gmail.com> wrote in message
> news:1169490279.707200.130060@.a75g2000cwd.googlegr oups.com...
|||Hello,
I need to implement full text search with in PDF and Text files along with tables in sql server 2000 , I think you have done some simimlar things ,
Can you give me detail s on how i can achieve same .
Thanks for your help in advance
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
I have a very strange problem : I've installed SQL server 2005, create
a storage for full index and full text index on a table. I've also
installed Adobe IFilter. Searches are OK but only on one criteria I
have problem. let me explain.
I'm searching in files in database for "c#" and some pdf files returned
by search are not containing "c#". Opening these PDF files with notepad
and searching for string "c#" let me find out why this file is returned
by search... Is it really the problem or not ? (is seems to do the same
on word files too...)
Thanks for your help.
Regards,
Ben.
SQL FTS interprets C# as C#, but c# as c. So you need to capitalize the C in
your searches and content for this to work correctly.
Hilary Cotter
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
<benjamin.soulier@.gmail.com> wrote in message
news:1169490279.707200.130060@.a75g2000cwd.googlegr oups.com...
> Hello everyone,
> I have a very strange problem : I've installed SQL server 2005, create
> a storage for full index and full text index on a table. I've also
> installed Adobe IFilter. Searches are OK but only on one criteria I
> have problem. let me explain.
> I'm searching in files in database for "c#" and some pdf files returned
> by search are not containing "c#". Opening these PDF files with notepad
> and searching for string "c#" let me find out why this file is returned
> by search... Is it really the problem or not ? (is seems to do the same
> on word files too...)
> Thanks for your help.
> Regards,
> Ben.
>
|||Hello Hilary,
Thanks for your quick answer, but it seems that the problem still
remains : I was wondering if it has something to do with the full text
index in database, as I configured it to case insensitive.
Do I have to put it back to case sensitive to make it work ?
Do I have to change noise words files (I've already removed "C" letter
from neutral and english files) ?.
Hilary Cotter a crit :[vbcol=seagreen]
> SQL FTS interprets C# as C#, but c# as c. So you need to capitalize the Cin
> your searches and content for this to work correctly.
> --
> Hilary Cotter
> 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
>
> <benjamin.soulier@.gmail.com> wrote in message
> news:1169490279.707200.130060@.a75g2000cwd.googlegr oups.com...
|||I tried to do a test for myself on this :
I created a new table, with full text index in case sensitive mode,
adding documents to it.
I still get files not containing C# values (all types of documents).
I even tried to use CONTAINSTABLE and FREETEXTTABLE, but problem is the
same...
Any ideas ?
benjamin.soulier@.gmail.com a crit :[vbcol=seagreen]
> Hello Hilary,
> Thanks for your quick answer, but it seems that the problem still
> remains : I was wondering if it has something to do with the full text
> index in database, as I configured it to case insensitive.
> Do I have to put it back to case sensitive to make it work ?
> Do I have to change noise words files (I've already removed "C" letter
> from neutral and english files) ?.
> Hilary Cotter a crit :
|||I take it you are Swiss and using the German or French (or Italian) word
breakers. In these languages c# and C# are indexed as c and C# - a search on
c# or C# will match with c and c# (lower and upper case). English
unfortunately is the exception here. c# is indexed as c, and C# is indexed
as C#, the search is done on C# which will match with C# and a search on c#
will match with c.
Hilary Cotter
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
<benjamin.soulier@.gmail.com> wrote in message
news:1169542818.105342.131360@.a75g2000cwd.googlegr oups.com...
Hello Hilary,
Thanks for your quick answer, but it seems that the problem still
remains : I was wondering if it has something to do with the full text
index in database, as I configured it to case insensitive.
Do I have to put it back to case sensitive to make it work ?
Do I have to change noise words files (I've already removed "C" letter
from neutral and english files) ?.
Hilary Cotter a crit :[vbcol=seagreen]
> SQL FTS interprets C# as C#, but c# as c. So you need to capitalize the C
> in
> your searches and content for this to work correctly.
> --
> Hilary Cotter
> 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
>
> <benjamin.soulier@.gmail.com> wrote in message
> news:1169490279.707200.130060@.a75g2000cwd.googlegr oups.com...
|||Hello,
I need to implement full text search with in PDF and Text files along with tables in sql server 2000 , I think you have done some simimlar things ,
Can you give me detail s on how i can achieve same .
Thanks for your help in advance
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
Indexing Service and Full Text Search?
I have a solutions database I am adding Full Text Search to.
Unfortunately, a huge part of the "solutions" resides on a shared lan in the
form of attachments.
I've used FTS before, and I've used Index server before (though never on
files located remotely)
Are there any resources on using both FTS and the Indexing Service together?
I thought I read that it was possible to run all the queries through SQL
server and that SQL server could go out and talk to the Indexing service
behind the sceens.
- thanks
Jack
Jack.fruhatsolcorpdotcom
you can't really use them together in any meaningful way. Your best bet is
to either index everything using IS by spitting your content out row by row
into the file system naming each file after the pk. This way you can track
which row your hits belong to.
Please refer to this link for more info on how to do this.
http://groups.google.com/groups?selm...utp ut=gplain
Alternatively you could push all of your documents into the database.
However it is difficult to search on properties this way. For instance you
can search on documents which contain the word microsoft and are greater
than a certain date, but you have to return the entire results set from
MSSearch and then filter by date. For large row sets this can be a very
expensive operation.
Another option is to add a linked server to index server and then query it
this way, however this is not scalable.
You also get better performance by migrating your content on the LAN
locally, however the performance hit is not that significant while querying,
but is significant when indexing.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Jack" <jack.fruhReplacewith@.Solcorp.com> wrote in message
news:uo8VMpKsEHA.624@.TK2MSFTNGP09.phx.gbl...
> I have a solutions database I am adding Full Text Search to.
> Unfortunately, a huge part of the "solutions" resides on a shared lan in
the
> form of attachments.
> I've used FTS before, and I've used Index server before (though never on
> files located remotely)
> Are there any resources on using both FTS and the Indexing Service
together?
> I thought I read that it was possible to run all the queries through SQL
> server and that SQL server could go out and talk to the Indexing service
> behind the sceens.
> - thanks
> Jack
> Jack.fruhatsolcorpdotcom
>
Unfortunately, a huge part of the "solutions" resides on a shared lan in the
form of attachments.
I've used FTS before, and I've used Index server before (though never on
files located remotely)
Are there any resources on using both FTS and the Indexing Service together?
I thought I read that it was possible to run all the queries through SQL
server and that SQL server could go out and talk to the Indexing service
behind the sceens.
- thanks
Jack
Jack.fruhatsolcorpdotcom
you can't really use them together in any meaningful way. Your best bet is
to either index everything using IS by spitting your content out row by row
into the file system naming each file after the pk. This way you can track
which row your hits belong to.
Please refer to this link for more info on how to do this.
http://groups.google.com/groups?selm...utp ut=gplain
Alternatively you could push all of your documents into the database.
However it is difficult to search on properties this way. For instance you
can search on documents which contain the word microsoft and are greater
than a certain date, but you have to return the entire results set from
MSSearch and then filter by date. For large row sets this can be a very
expensive operation.
Another option is to add a linked server to index server and then query it
this way, however this is not scalable.
You also get better performance by migrating your content on the LAN
locally, however the performance hit is not that significant while querying,
but is significant when indexing.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Jack" <jack.fruhReplacewith@.Solcorp.com> wrote in message
news:uo8VMpKsEHA.624@.TK2MSFTNGP09.phx.gbl...
> I have a solutions database I am adding Full Text Search to.
> Unfortunately, a huge part of the "solutions" resides on a shared lan in
the
> form of attachments.
> I've used FTS before, and I've used Index server before (though never on
> files located remotely)
> Are there any resources on using both FTS and the Indexing Service
together?
> I thought I read that it was possible to run all the queries through SQL
> server and that SQL server could go out and talk to the Indexing service
> behind the sceens.
> - thanks
> Jack
> Jack.fruhatsolcorpdotcom
>
Monday, March 19, 2012
indexing document stored in IMAGE fields
Hi guys,
in the Full Text Retrieval documentation of MS SQLserver 2000 it's said that the document stored in IMAGE
fields are "filtered" using the Microsoft provided filters (for these file extensions: .doc, .xls, .ppt, .txt
and .htm) or third party filters (e.g. Adobe for .pdf).
Little after there's a note stating that "For full-text indexing, a document must be less than 16 megabytes (MB)
in size and must not contain more than 256 kilobytes (KB) of filtered text.".
While I can check if a file is larger than the max supported size, how can I check if a document contains more
than 256 KB of filtered text ? Is this information "exported" in some way by the filter applied to the document ?
If I store a document that does not satisfy the MSSearch requirements (size > 16MB or "filtered size" > 256 KB), which
actions are made by MSSearch ? Does indexing simply ignore it ?
Many THXS for your kind reply
MadMax
The best way to do this is to get filtdump from the platform sdk and do this
filtdump -b mydoc.doc >c:\out.out and then measure the size of the output.
In other versions of Microsoft Search products there were limits of the amount fo text per document that would be indexed. You could adjust this with a registry key setting. Any bytes over this interval would not be retrieved or indexed.
There are settings within MSSearch which allows you to control the maximum raw size of a document you are indexing but AFAIK there is no setting to allow you to increase the maximum amount of textual data it will index.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
|||THX very much Hilary.
Do you know what happen if the indexed document is bigger than the MSSearch limits (size 16MB, filtered size 256KB) ?
Is the document indexed (may be only for the part <16MB / filtered size < 256) or the indexing process fails completely ?
Max
|||My understanding is that only the first 16 M is extracted and only the first 256 k of text indexed.
The rest is ingnored.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
|||Max, Hilary,
I posted this reply in Nov. 2003, on this same subject... "I believe that
this is a DOC bug, i.e., a bug or incorrect information in
Books Online (BOL). To the best of my knowledge, no public KB exists for
this bug, however a related KB article - 308771 (Q308771) "PRB: A Full-Text
Search May Not Return Any Hits If It Fails to Index a File" at
http://support.microsoft.com/default...b;en-us;308771 has
information on the use of the Registry key: FilterProcessMemoryQuota.
You can control the size of the FT Index doc via Registry Key
FilterProcessMemoryQuota and setting it's value. Specifically,
HKLM\Software\Microsoft\Search\1.0\gathering
manager\filterProcessMemoryQuota, (DWORD).
It should default to 25MB and you can make it larger as it only affects the
limit for memory usage in the daemon [MSSdmn] process. In addition to the
memory allocated to SQL Server, it is recommended that a minimum of 15 MB of
RAM be reserved for the Microsoft Search service and a maximum of 512 MB of
RAM be allocated for the Microsoft Search service. If you plan on FT
Indexing large documents, you will need to set aside more memory for the
"Microsoft Search" (mssearch.exe) service and TEST the performance FT
Indexing very large documents as well as ensure that you have enough free
disk space on you system drive and the drive where your FT Catalogs reside
at all times."
Regards,
John
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:32335399-ADC7-45AD-B179-8D97C46CBC73@.microsoft.com...
> My understanding is that only the first 16 M is extracted and only the
first 256 k of text indexed.
> The rest is ingnored.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
in the Full Text Retrieval documentation of MS SQLserver 2000 it's said that the document stored in IMAGE
fields are "filtered" using the Microsoft provided filters (for these file extensions: .doc, .xls, .ppt, .txt
and .htm) or third party filters (e.g. Adobe for .pdf).
Little after there's a note stating that "For full-text indexing, a document must be less than 16 megabytes (MB)
in size and must not contain more than 256 kilobytes (KB) of filtered text.".
While I can check if a file is larger than the max supported size, how can I check if a document contains more
than 256 KB of filtered text ? Is this information "exported" in some way by the filter applied to the document ?
If I store a document that does not satisfy the MSSearch requirements (size > 16MB or "filtered size" > 256 KB), which
actions are made by MSSearch ? Does indexing simply ignore it ?
Many THXS for your kind reply
MadMax
The best way to do this is to get filtdump from the platform sdk and do this
filtdump -b mydoc.doc >c:\out.out and then measure the size of the output.
In other versions of Microsoft Search products there were limits of the amount fo text per document that would be indexed. You could adjust this with a registry key setting. Any bytes over this interval would not be retrieved or indexed.
There are settings within MSSearch which allows you to control the maximum raw size of a document you are indexing but AFAIK there is no setting to allow you to increase the maximum amount of textual data it will index.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
|||THX very much Hilary.
Do you know what happen if the indexed document is bigger than the MSSearch limits (size 16MB, filtered size 256KB) ?
Is the document indexed (may be only for the part <16MB / filtered size < 256) or the indexing process fails completely ?
Max
|||My understanding is that only the first 16 M is extracted and only the first 256 k of text indexed.
The rest is ingnored.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
|||Max, Hilary,
I posted this reply in Nov. 2003, on this same subject... "I believe that
this is a DOC bug, i.e., a bug or incorrect information in
Books Online (BOL). To the best of my knowledge, no public KB exists for
this bug, however a related KB article - 308771 (Q308771) "PRB: A Full-Text
Search May Not Return Any Hits If It Fails to Index a File" at
http://support.microsoft.com/default...b;en-us;308771 has
information on the use of the Registry key: FilterProcessMemoryQuota.
You can control the size of the FT Index doc via Registry Key
FilterProcessMemoryQuota and setting it's value. Specifically,
HKLM\Software\Microsoft\Search\1.0\gathering
manager\filterProcessMemoryQuota, (DWORD).
It should default to 25MB and you can make it larger as it only affects the
limit for memory usage in the daemon [MSSdmn] process. In addition to the
memory allocated to SQL Server, it is recommended that a minimum of 15 MB of
RAM be reserved for the Microsoft Search service and a maximum of 512 MB of
RAM be allocated for the Microsoft Search service. If you plan on FT
Indexing large documents, you will need to set aside more memory for the
"Microsoft Search" (mssearch.exe) service and TEST the performance FT
Indexing very large documents as well as ensure that you have enough free
disk space on you system drive and the drive where your FT Catalogs reside
at all times."
Regards,
John
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:32335399-ADC7-45AD-B179-8D97C46CBC73@.microsoft.com...
> My understanding is that only the first 16 M is extracted and only the
first 256 k of text indexed.
> The rest is ingnored.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
Monday, March 12, 2012
Indexing custom BLOB Field with SQL Server 2000!
Hi,
I want define a full text indexing in a BLOB field that store custom binary
file. As I know in such cases should write an IFilter for extracting plain
text from this binary file.
How is is possible with SQL Server 2000? Is there a guide about writing an
IFilter?
Hilary Cotter
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
"Mamouri" <m@.m.com> wrote in message
news:eYphDbuHHHA.420@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I want define a full text indexing in a BLOB field that store custom
> binary
> file. As I know in such cases should write an IFilter for extracting plain
> text from this binary file.
> How is is possible with SQL Server 2000? Is there a guide about writing an
> IFilter?
>
I want define a full text indexing in a BLOB field that store custom binary
file. As I know in such cases should write an IFilter for extracting plain
text from this binary file.
How is is possible with SQL Server 2000? Is there a guide about writing an
IFilter?
Hilary Cotter
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
"Mamouri" <m@.m.com> wrote in message
news:eYphDbuHHHA.420@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I want define a full text indexing in a BLOB field that store custom
> binary
> file. As I know in such cases should write an IFilter for extracting plain
> text from this binary file.
> How is is possible with SQL Server 2000? Is there a guide about writing an
> IFilter?
>
Indexing a view that contains text or ntext
I've created a view and started to create my first index (unique, clustered)
but got the following error:
"Cannot create index on view 'MyDB.dbo.myview'. It contains text, ntext,
image or xml columns. (Mircrosoft SQL Server, Error: 1492)"
There is only one field among the fields I'm using that is ntext.
Unfortunately I don't see how I can change it's data type since the largest
number of characters in this field is over 22,000 characters. What are my
options for creating indexes on this view? Is there a workaround that I can
do? Any suggestions?
Hi
From BOL: "Note Columns consisting of the ntext, text, or image data types
cannot be specified as columns for an index. In addition, a view cannot
include any text, ntext, or image columns, even if they are not referenced in
the CREATE INDEX statement."
Therefore with your current view you can not create an index. Does this
column need to be in the view?
John
"archuleta37" wrote:
> I've created a view and started to create my first index (unique, clustered)
> but got the following error:
> "Cannot create index on view 'MyDB.dbo.myview'. It contains text, ntext,
> image or xml columns. (Mircrosoft SQL Server, Error: 1492)"
> There is only one field among the fields I'm using that is ntext.
> Unfortunately I don't see how I can change it's data type since the largest
> number of characters in this field is over 22,000 characters. What are my
> options for creating indexes on this view? Is there a workaround that I can
> do? Any suggestions?
but got the following error:
"Cannot create index on view 'MyDB.dbo.myview'. It contains text, ntext,
image or xml columns. (Mircrosoft SQL Server, Error: 1492)"
There is only one field among the fields I'm using that is ntext.
Unfortunately I don't see how I can change it's data type since the largest
number of characters in this field is over 22,000 characters. What are my
options for creating indexes on this view? Is there a workaround that I can
do? Any suggestions?
Hi
From BOL: "Note Columns consisting of the ntext, text, or image data types
cannot be specified as columns for an index. In addition, a view cannot
include any text, ntext, or image columns, even if they are not referenced in
the CREATE INDEX statement."
Therefore with your current view you can not create an index. Does this
column need to be in the view?
John
"archuleta37" wrote:
> I've created a view and started to create my first index (unique, clustered)
> but got the following error:
> "Cannot create index on view 'MyDB.dbo.myview'. It contains text, ntext,
> image or xml columns. (Mircrosoft SQL Server, Error: 1492)"
> There is only one field among the fields I'm using that is ntext.
> Unfortunately I don't see how I can change it's data type since the largest
> number of characters in this field is over 22,000 characters. What are my
> options for creating indexes on this view? Is there a workaround that I can
> do? Any suggestions?
Indexing a view that contains text or ntext
I've created a view and started to create my first index (unique, clustered)
but got the following error:
"Cannot create index on view 'MyDB.dbo.myview'. It contains text, ntext,
image or xml columns. (Mircrosoft SQL Server, Error: 1492)"
There is only one field among the fields I'm using that is ntext.
Unfortunately I don't see how I can change it's data type since the largest
number of characters in this field is over 22,000 characters. What are my
options for creating indexes on this view? Is there a workaround that I can
do? Any suggestions?Hi
From BOL: "Note Columns consisting of the ntext, text, or image data types
cannot be specified as columns for an index. In addition, a view cannot
include any text, ntext, or image columns, even if they are not referenced i
n
the CREATE INDEX statement."
Therefore with your current view you can not create an index. Does this
column need to be in the view?
John
"archuleta37" wrote:
> I've created a view and started to create my first index (unique, clustere
d)
> but got the following error:
> "Cannot create index on view 'MyDB.dbo.myview'. It contains text, ntext,
> image or xml columns. (Mircrosoft SQL Server, Error: 1492)"
> There is only one field among the fields I'm using that is ntext.
> Unfortunately I don't see how I can change it's data type since the larges
t
> number of characters in this field is over 22,000 characters. What are my
> options for creating indexes on this view? Is there a workaround that I ca
n
> do? Any suggestions?
but got the following error:
"Cannot create index on view 'MyDB.dbo.myview'. It contains text, ntext,
image or xml columns. (Mircrosoft SQL Server, Error: 1492)"
There is only one field among the fields I'm using that is ntext.
Unfortunately I don't see how I can change it's data type since the largest
number of characters in this field is over 22,000 characters. What are my
options for creating indexes on this view? Is there a workaround that I can
do? Any suggestions?Hi
From BOL: "Note Columns consisting of the ntext, text, or image data types
cannot be specified as columns for an index. In addition, a view cannot
include any text, ntext, or image columns, even if they are not referenced i
n
the CREATE INDEX statement."
Therefore with your current view you can not create an index. Does this
column need to be in the view?
John
"archuleta37" wrote:
> I've created a view and started to create my first index (unique, clustere
d)
> but got the following error:
> "Cannot create index on view 'MyDB.dbo.myview'. It contains text, ntext,
> image or xml columns. (Mircrosoft SQL Server, Error: 1492)"
> There is only one field among the fields I'm using that is ntext.
> Unfortunately I don't see how I can change it's data type since the larges
t
> number of characters in this field is over 22,000 characters. What are my
> options for creating indexes on this view? Is there a workaround that I ca
n
> do? Any suggestions?
Indexing a view that contains text or ntext
I've created a view and started to create my first index (unique, clustered)
but got the following error:
"Cannot create index on view 'MyDB.dbo.myview'. It contains text, ntext,
image or xml columns. (Mircrosoft SQL Server, Error: 1492)"
There is only one field among the fields I'm using that is ntext.
Unfortunately I don't see how I can change it's data type since the largest
number of characters in this field is over 22,000 characters. What are my
options for creating indexes on this view? Is there a workaround that I can
do? Any suggestions?Hi
From BOL: "Note Columns consisting of the ntext, text, or image data types
cannot be specified as columns for an index. In addition, a view cannot
include any text, ntext, or image columns, even if they are not referenced in
the CREATE INDEX statement."
Therefore with your current view you can not create an index. Does this
column need to be in the view?
John
"archuleta37" wrote:
> I've created a view and started to create my first index (unique, clustered)
> but got the following error:
> "Cannot create index on view 'MyDB.dbo.myview'. It contains text, ntext,
> image or xml columns. (Mircrosoft SQL Server, Error: 1492)"
> There is only one field among the fields I'm using that is ntext.
> Unfortunately I don't see how I can change it's data type since the largest
> number of characters in this field is over 22,000 characters. What are my
> options for creating indexes on this view? Is there a workaround that I can
> do? Any suggestions?
but got the following error:
"Cannot create index on view 'MyDB.dbo.myview'. It contains text, ntext,
image or xml columns. (Mircrosoft SQL Server, Error: 1492)"
There is only one field among the fields I'm using that is ntext.
Unfortunately I don't see how I can change it's data type since the largest
number of characters in this field is over 22,000 characters. What are my
options for creating indexes on this view? Is there a workaround that I can
do? Any suggestions?Hi
From BOL: "Note Columns consisting of the ntext, text, or image data types
cannot be specified as columns for an index. In addition, a view cannot
include any text, ntext, or image columns, even if they are not referenced in
the CREATE INDEX statement."
Therefore with your current view you can not create an index. Does this
column need to be in the view?
John
"archuleta37" wrote:
> I've created a view and started to create my first index (unique, clustered)
> but got the following error:
> "Cannot create index on view 'MyDB.dbo.myview'. It contains text, ntext,
> image or xml columns. (Mircrosoft SQL Server, Error: 1492)"
> There is only one field among the fields I'm using that is ntext.
> Unfortunately I don't see how I can change it's data type since the largest
> number of characters in this field is over 22,000 characters. What are my
> options for creating indexes on this view? Is there a workaround that I can
> do? Any suggestions?
Indexing a TEXT Column
Hey
I want to index a TEXT column to accelerate my searchfunction,
does anybody have experience or good idea's ??
Greetz Da WitteHi,
Try index tuning wizard..
It will tell you if you should create an index and helps you do that.
Create a workload file and run it thru index tuning wizard..
Good luck
Tommy|||Text and image columns cannot be indexed. Use a long VARCHAR datatype instead.
blindman|||Good point Blindman !! :-)|||Originally posted by blindman
Text and image columns cannot be indexed. Use a long VARCHAR datatype instead.
blindman
Problem... I want to store >1000000 characters and also want to search in those records !!|||Look up Full-Text Indexes in Books Online. I think it will do what you are looking for.
blindman
I want to index a TEXT column to accelerate my searchfunction,
does anybody have experience or good idea's ??
Greetz Da WitteHi,
Try index tuning wizard..
It will tell you if you should create an index and helps you do that.
Create a workload file and run it thru index tuning wizard..
Good luck
Tommy|||Text and image columns cannot be indexed. Use a long VARCHAR datatype instead.
blindman|||Good point Blindman !! :-)|||Originally posted by blindman
Text and image columns cannot be indexed. Use a long VARCHAR datatype instead.
blindman
Problem... I want to store >1000000 characters and also want to search in those records !!|||Look up Full-Text Indexes in Books Online. I think it will do what you are looking for.
blindman
Friday, February 24, 2012
Indexes
How can i send Indexes of all table in the sql database to a text file
--
Yousuf Khan
ProgrammerHi,
By using the generate sql script option we will be able to generate scripts
for any objects in the DB.
Select Only the script indexes option so u will have the script only for all
indexes and save this to a file.
any questions le me know.
--
Herbert
"Yousuf" wrote:
> How can i send Indexes of all table in the sql database to a text file
> --
> Yousuf Khan
> Programmer|||Hi Herbert
You can also run a small select statement againt sysindexes table and save
the output to a text file.
Someting like:
sp_MSForEachTable 'exec sp_helpindex ''?'''
Good luck
JP
"Herbert" wrote:
[vbcol=seagreen]
> Hi,
> By using the generate sql script option we will be able to generate script
s
> for any objects in the DB.
> Select Only the script indexes option so u will have the script only for a
ll
> indexes and save this to a file.
> any questions le me know.
> --
> Herbert
>
> "Yousuf" wrote:
>
--
Yousuf Khan
ProgrammerHi,
By using the generate sql script option we will be able to generate scripts
for any objects in the DB.
Select Only the script indexes option so u will have the script only for all
indexes and save this to a file.
any questions le me know.
--
Herbert
"Yousuf" wrote:
> How can i send Indexes of all table in the sql database to a text file
> --
> Yousuf Khan
> Programmer|||Hi Herbert
You can also run a small select statement againt sysindexes table and save
the output to a text file.
Someting like:
sp_MSForEachTable 'exec sp_helpindex ''?'''
Good luck
JP
"Herbert" wrote:
[vbcol=seagreen]
> Hi,
> By using the generate sql script option we will be able to generate script
s
> for any objects in the DB.
> Select Only the script indexes option so u will have the script only for a
ll
> indexes and save this to a file.
> any questions le me know.
> --
> Herbert
>
> "Yousuf" wrote:
>
Indexes
How can i send Indexes of all table in the sql database to a text file
--
Yousuf Khan
ProgrammerHi,
By using the generate sql script option we will be able to generate scripts
for any objects in the DB.
Select Only the script indexes option so u will have the script only for all
indexes and save this to a file.
any questions le me know.
--
Herbert
"Yousuf" wrote:
> How can i send Indexes of all table in the sql database to a text file
> --
> Yousuf Khan
> Programmer|||Hi Herbert
You can also run a small select statement againt sysindexes table and save
the output to a text file.
Someting like:
sp_MSForEachTable 'exec sp_helpindex ''?'''
Good luck
JP
"Herbert" wrote:
> Hi,
> By using the generate sql script option we will be able to generate scripts
> for any objects in the DB.
> Select Only the script indexes option so u will have the script only for all
> indexes and save this to a file.
> any questions le me know.
> --
> Herbert
>
> "Yousuf" wrote:
> > How can i send Indexes of all table in the sql database to a text file
> > --
> > Yousuf Khan
> > Programmer
--
Yousuf Khan
ProgrammerHi,
By using the generate sql script option we will be able to generate scripts
for any objects in the DB.
Select Only the script indexes option so u will have the script only for all
indexes and save this to a file.
any questions le me know.
--
Herbert
"Yousuf" wrote:
> How can i send Indexes of all table in the sql database to a text file
> --
> Yousuf Khan
> Programmer|||Hi Herbert
You can also run a small select statement againt sysindexes table and save
the output to a text file.
Someting like:
sp_MSForEachTable 'exec sp_helpindex ''?'''
Good luck
JP
"Herbert" wrote:
> Hi,
> By using the generate sql script option we will be able to generate scripts
> for any objects in the DB.
> Select Only the script indexes option so u will have the script only for all
> indexes and save this to a file.
> any questions le me know.
> --
> Herbert
>
> "Yousuf" wrote:
> > How can i send Indexes of all table in the sql database to a text file
> > --
> > Yousuf Khan
> > Programmer
Sunday, February 19, 2012
Indexes
How can i send Indexes of all table in the sql database to a text file
Yousuf Khan
Programmer
Hi,
By using the generate sql script option we will be able to generate scripts
for any objects in the DB.
Select Only the script indexes option so u will have the script only for all
indexes and save this to a file.
any questions le me know.
Herbert
"Yousuf" wrote:
> How can i send Indexes of all table in the sql database to a text file
> --
> Yousuf Khan
> Programmer
|||Hi Herbert
You can also run a small select statement againt sysindexes table and save
the output to a text file.
Someting like:
sp_MSForEachTable 'exec sp_helpindex ''?'''
Good luck
JP
"Herbert" wrote:
[vbcol=seagreen]
> Hi,
> By using the generate sql script option we will be able to generate scripts
> for any objects in the DB.
> Select Only the script indexes option so u will have the script only for all
> indexes and save this to a file.
> any questions le me know.
> --
> Herbert
>
> "Yousuf" wrote:
Yousuf Khan
Programmer
Hi,
By using the generate sql script option we will be able to generate scripts
for any objects in the DB.
Select Only the script indexes option so u will have the script only for all
indexes and save this to a file.
any questions le me know.
Herbert
"Yousuf" wrote:
> How can i send Indexes of all table in the sql database to a text file
> --
> Yousuf Khan
> Programmer
|||Hi Herbert
You can also run a small select statement againt sysindexes table and save
the output to a text file.
Someting like:
sp_MSForEachTable 'exec sp_helpindex ''?'''
Good luck
JP
"Herbert" wrote:
[vbcol=seagreen]
> Hi,
> By using the generate sql script option we will be able to generate scripts
> for any objects in the DB.
> Select Only the script indexes option so u will have the script only for all
> indexes and save this to a file.
> any questions le me know.
> --
> Herbert
>
> "Yousuf" wrote:
Subscribe to:
Posts (Atom)