Create full-text index wizard returneaza eroare

Microsoft SQL Server 2008
In cazul in care vrei sa creezi full-text index folosind wizard-ul din Microsoft SQL Server Management Studio vei intampina urmatoarea eroare:

This wizard will close because it encountered the following error.
Failed to retrieve data for this request.
An exception occurred while executing a Transact-SQL statement or batch.
The EXECUTE permission was denied on the object 'sp_help_category', database 'msdb', schema 'dbo'.
The SELECT permission was denied on the object 'sysjobs_view', database 'msdb', schema 'dbo'.

Pentru a crea full-text index urmeaza pasii urmatori:

1. Dupa autentificare selecteaza baza ta de date;
2. Selecteaza nodul "Storage", click dreapta pe "Full Text Catalogs" si selecteaza "New Full-Text Catalog";
3. Scrie numele in casuta "Full-text catalog name", owner-ul si click ok;
4. Click dreapta pe catalog-ul nou creat, selecteaza ""Properties";
5. Selecteaza "Tables/Views", selecteaza tabelele disponibile pentru care doresti sa creezi full-text index;
6. Click OK.

Add Feedback