I have SQL database running through ASP in a Web Broswer. My users are running into serious problems with speed - the pages that need to search through large tables, or run multiple queries are running horribly slow, especially when many people are logged in.
I suspect the problem is that the tables are not indexed, but I can't get them to index. When I try to use the Indexing wizard in SQL Server 8, the wizard goes all the way through until it tells me that I don't have acess to the folder I am trying to save the index to and the that "Full-text search was not installed properly." THe folder is a folder I work in and build files in all the time, so that is not true, but it seems that there is a problem with indexing being installed.
I have tried enabling full text searching and indexing in the SQL Query Analyzer, but it doesn't seem to take. I keep getting this same error.
Does anyone know what I can do?