August 22, 2005 at 2:25 pm
exec sp_fulltext_catalog N'MyDataBase', N'start_incremental'
I keep getting a permission error. Here is what I have done on the permission side of things.
In the MASTER database I have created a user that will only be used to run sp_fulltext_catalog I then give this user (ftiUser)
EXEC permissions for sp_fulltext_catalog.
On my ASP page I create a connection to the MASTER db using this one user who only has permissions to this one Stored Procedure. I then run the asp page and I get no error and no apparent population success after running a simple stored procedure to search for records. However when I login to the server and connect to the master Database using the ftiuser account, I get in however this is the error I receive when running the above script:
User does not have permission to perform this action.
Can anyone help me or point me to a place where I may be able to find out how to run either FULL or INCREMENTAL Full-Text catalogs using asp.
August 25, 2005 at 8:00 am
This was removed by the editor as SPAM
August 25, 2005 at 10:16 am
I'm not sure you want to do this in ASP since the time could be long and you may get timeouts. Better to use ASP to insert a value into a table. Then start a job or use a job to scan the table and run the full text catalog. You can requery the table from ASP to see if some status value has been updated.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply