<asp:Button runat="server" Text="UPDATE CATALOG" ID="btnUpdateCat" OnClick="btnUpdateCat_Click" />
protected void btnUpdateCat_Click(object sender, EventArgs e)
{
// NEED TO RUN THIS SQL CODE :
// exec sp_fulltext_catalog 'ProdCat', 'start_incremental' ???
}
I want to be able to Update the Full Text Catalog when that button is click by running :
"sp_fulltext_catalog 'ProdCat', 'start_incremental'' in the database.
I could write the stored procedure :
CREATE PROCEDURE UpdateSearchCatalog
AS
exec sp_fulltext_catalog 'ProdCat', 'start_incremental'
but I'm not sure how I would "call" it in the code.
Anyone have any ideas on how I can do this? thanks
...