Hi Vidar -
Why are you not taking advantage of full-textsearch? Isn't that what you really want?
Look in the Installation guide for informationon Configuring theIndex Service on the SQL Server System.
Thanks for your reply. I am aware of the indexed search, but it seems odd to rely on that when you have an SQL Server. It is my understanding that indexing works on the vault's files, not the database.
What we want is a lightning fast database search, independent of whether the actual files are indexed or not.
The problem is the files themselves are not in SQL, just themeta data and pointers to the actual files. Unless it is in thedatacard, SQL has no knowledge of what data is actually in the fileitself.
An indexing search isn't terribly slow, I'd give it a try.