[table][tr][td]SP_AddDatabase[/td][td]Add a database. Parameter 1 is Database name. Parameter 2 is DefaultPath, Parameter 3 is DefaultDBAdapter, Parameter 4 is DefaultConnectionString[/td][/tr][tr][td]SP_AddExternalReference[/td][td]Add a extrenal reference. Parameter number must be 2. Parameter 1 is refer name and parameter 2 is assembly file path![/td][/tr][tr][td]SP_AddSchema[/td][td]Add a schema. Parameter 1 is schema xml string.[/td][/tr][tr][td]SP_AnalyzerList[/td][td]List all analyzers![/td][/tr][tr][td]SP_AttachTable[/td][td]Attach table. Parameter 1 is directory Parameter 2 is table name Parameter 3 is connectString Parameter 4 is DBTableName. The last thress is optional[/td][/tr][tr][td]SP_ChangePassword[/td][td]Add a user account. Parameter 1 is user name. Parameter 2 is password[/td][/tr][tr][td]SP_Columns[/td][td]List all columns in the table. The number of parameters must be 1. Parameter 1 is table name.[/td][/tr][tr][td]SP_Configure[/td][td]Configure system.[/td][/tr][tr][td]SP_CreateBigTable[/td][td]Create bigtable. Parameter 1 is table name, parameter 2 is indexfolder, parameter 3 is xml string of bigtable.[/td][/tr][tr][td]SP_CreateUser[/td][td]Add a user account. Parameter 1 is user name. Parameter 2 is password, Parameter 3 is system user right[/td][/tr][tr][td]SP_DatabaseList[/td][td]List all databases[/td][/tr][tr][td]SP_DBAdapterList[/td][td]List all db adapters[/td][/tr][tr][td]SP_DeleteExternalReference[/td][td]Delete external reference. Parameter number must be 2. Parameter 1 is refer name and parameter 2 is assembly file path![/td][/tr][tr][td]SP_DetachTable[/td][td]Detach table. Parameter 1 is table name[/td][/tr][tr][td]SP_DropDatabase[/td][td]Drop database. Parameter 1 is Database name.[/td][/tr][tr][td]SP_DropTable[/td][td]Drop table. Parameter 1 is table name.[/td][/tr][tr][td]SP_ExcuteSql[/td][td]Excute sql directly from database. Parameter 1 is table name or sql for excute. Parameter 2 is sql for excute if Parameter 1 is table name[/td][/tr][tr][td]SP_ExternalReference[/td][td]List external reference[/td][/tr][tr][td]SP_FieldAnalyze[/td][td]Analyze text using the analyzer of the field that input. Parameter 1 is table name, Parameter 2 is field name, Parameter 3 is a text for test, Parameter 4 is analyzer type(optional)[/td][/tr][tr][td]SP_GCCollect[/td][td]Force collect GC[/td][/tr][tr][td]SP_GetBigTable[/td][td]Get bigtable. Parameter 1 is table name[/td][/tr][tr][td]SP_GetDatabaseAttributes[/td][td]Get attributes of the database. First parameter is database name.[/td][/tr][tr][td]SP_GetSchema[/td][td]Get task schema by SchemaId![/td][/tr][tr][td]SP_GetTableAttributes[/td][td]Get table attribute. First parameter is table name.[/td][/tr][tr][td]SP_GetTableMergeRate[/td][td]Get merge rate of table. First parameter is table name.[/td][/tr][tr][td]SP_GetTableSchema[/td][td]Get table's schema from database. Parameter 1 is DBAdapter Name. Parameter 2 is ConnectionString. Parameter 3 is table name.[/td][/tr][tr][td]SP_GetTableSyncProgress[/td][td]Get synchronize progress of table. First parameter is table name.[/td][/tr][tr][td]SP_GetTFIDF[/td][td]Get inverse document frequency. First parameter is table name, second parameter is field name, third parameter is words. SP_GetIDF 'tablename', 'fieldname', 'abc news'[/td][/tr][tr][td]SP_GetUserRights[/td][td]List all rights of specific user. First parameter is user name[/td][/tr][tr][td]SP_Help[/td][td]List all store procedures[/td][/tr][tr][td]SP_OptimizeTable[/td][td]Optimize table. Parameter 1 is table name. Parameter 2 is optimize option(optional)[/td][/tr][tr][td]SP_QueryByDocIds[/td][td]Query by docids. Parameter 1 is select statement before where. Parameter 2 - n is docids.[/td][/tr][tr][td]SP_QueryCacheReport[/td][td]Report the query cache[/td][/tr][tr][td]SP_QuerySql[/td][td]Query sql directly from database. Parameter 1 is table name or sql for query. Parameter 2 is sql for excute if Parameter 1 is table name[/td][/tr][tr][td]SP_Rebuild[/td][td]rebuild the table. Parameter 1 is table name, Parameter 2 is step, Parameter 3 is merge mode, Parameter 4 flag.[/td][/tr][tr][td]SP_RemoveSchema[/td][td]Remove schema by SchemaId. Parameter 1 is SchemaId[/td][/tr][tr][td]SP_RemoveUser[/td][td]Remove a user account. Parameter 1 is user name. [/td][/tr][tr][td]SP_RemoveUserRight[/td][td]Set user's right for specifical database. First parameter is user name, second parameter is database name[/td][/tr][tr][td]SP_ResetCache[/td][td]Reset query cache and data cache for the specific table. Parameter 1 is table name.[/td][/tr][tr][td]SP_SchemaList[/td][td]List all task schemas![/td][/tr][tr][td]SP_SetBigTable[/td][td]Set bigtable. Parameter 1 is table name, parameter 2 is xml string of bigtable.[/td][/tr][tr][td]SP_SetDatabaseAttribute[/td][td]Set database attribute. Parameter 1 is Database name. Parameter 2 is Attribute name, Parameter 3 is Attribute value[/td][/tr][tr][td]SP_SetTableAttribute[/td][td]Set table attribute. First parameter is table name. Second parameter is attribute name. Third is value[/td][/tr][tr][td]SP_SetUserRight[/td][td]Set user's right for specifical database. First parameter is user name, second parameter is database name, third is right[/td][/tr][tr][td]SP_StopSynchronizeTable[/td][td]Stop synchronize with database. Parameter 1 is table name, Parameter 1 is table name, Parameter 2 is step, Parameter 3 is merge mode.[/td][/tr][tr][td]SP_SynchronizeTable[/td][td]Synchronize from database. Parameter 1 is table name, Parameter 1 is table name, Parameter 2 is step, Parameter 3 is merge mode, Parameter 4 is fastest mode, true or false.[/td][/tr][tr][td]SP_TableIndexOnly[/td][td]Set or get table index only. First parameter is table name. Second parameter is 'True' or 'False' if set[/td][/tr][tr][td]SP_TableList[/td][td]List all tables[/td][/tr][tr][td]SP_TableQueryCache[/td][td]Get or set table query cache. First parameter is table name and second is 'True' or 'False', third is QueryCacheTimeout. If get, only need first parameter[/td][/tr][tr][td]SP_Test[/td][td]This store procedure is used to test. Parameter 1 is table name.[/td][/tr][tr][td]SP_TestAnalyzer[/td][td]Test analyzer. The number of parameters must be 2. Parameter 1 is Analyzer name, Parameter 2 is a text for test.[/td][/tr][tr][td]SP_TestConnectionString[/td][td]Test database connection string. The number of parameters must be 2. Parameter 1 is DBAdapter name, Parameter 2 is connection string.[/td][/tr][tr][td]SP_TruncateTable[/td][td]Truncate table. The number of parameters must be 1. Parameter 1 is table name.[/td][/tr][tr][td]SP_UpdateDatabase[/td][td]Update the attribute of database. Parameter 1 is Database name. Parameter 2 is DefaultPath, Parameter 3 is DefaultDBAdapter, Parameter 4 is DefaultConnectionString[/td][/tr][tr][td]SP_UserList[/td][td]List all user accounts[/td][/tr][tr][td]SP_Version[/td][td]Get hubble.net service version[/td][/tr][/table]