FYI, I'm blogging most of my stuff over at More Wally now.
You might want to add my rss feed to your reader at:http://morewally.com/cs/blogs/wallym/rss.aspx
Check the filters installed in your Sql Server 2005 database - Wallace B. McClure

Wallace B. McClure

All About Wally McClure - The musings of Wallym on .NET, Sql, ASP.NET, and other crazy shenanigans

News

Personal Blog

Work Blog

.NET

Book Authors

Business

Family

Friends

Georgia Tech Bloggers

Personal

Check the filters installed in your Sql Server 2005 database

Would you like to find out the filters that are installed in your Sql Server 2005 database?  Try this: exec sp_help_fulltext_extensions;

The result is the set of file extensions, the path for the filter, the version (of the filter, I assume), and the clsid (of the filter, I assume).  With the December CTP, the sproc returns 50 entries.

FYI, I don't have a Sql Server 2k system to test on at this time.

Wally

 

Comments

Paul Schaeflein said:

Could not find stored procedure 'sp_help_fulltext_extensions'.
# January 9, 2005 11:23 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)