MS SQL search

[ash]

I want to search the content of some database tables,
do asp has some function or tool do this?
thx

 

[Ray Costanzo [MVP]]

Can you be more specific? If you want content from a database, you query
it.

Ray at work

 

[ash]

is there any function in asp read through all the tables in the db and
search the all content that matched, then display to the link relevant asp.

thx

 

[Bob Barrows [MVP]]

No. you need to look into Full-text indexing, which is built into SQL
Server.

 

[ash]

Is Full-text indexing is for searching the for all tables in the db with
matching word in the content? where can i find it in SQL Server?
Thx

Best Regards, Stephy Ku Innovation Square 2756 6618

 

[Bob Barrows [MVP]]

Is Full-text indexing is for searching the for all tables in the db
with matching word in the content?

Ummmm ... that's why I suggested it ....

where can i find it in SQL Server?
Thx

I've never used it myself so all I can tell you is to look it up in BOL
(Books Online).
You will have better luck looking for support in a sqlserver group. I think
they have one devoted to full-text indexing issues ... yes, it's called
microsoft.public.sqlserver.fulltext