ISTwatch SQL Server 2000 SDK
ISTwatch comes with Microsoft SQL-Server Software Developer’s
Kit that includes a specialized dynamic link library and several examples
on creating Transact-SQL (T-SQL) wrapper scripts that reference SQL Server
extended stored procedures.
ISTwatch functions can be called from any T-SQL scripts as soon
as corresponding extended stored procedures are registered with
SQL-Server. Here is a simple example of registering such a procedure
with the dynamic link library provided.
• Open Microsoft SQL Server Enterprise
Manager
• Connect to the server that you will be using
•
Open DATABASES folder and go to the ‘master’ database
• Right-click on EXTENDED STORED PROCEDURES
• Click on NEW EXTENDED STORED PROCEDURE
•
In the ‘Name’ field, type xp_TSearch
•
In the ‘Path’ field, type the path to your ISTwatch
DLL
•
Click ‘OK’
• ISTwatch functionality can now be utilized underneath SQL-Server
EXAMPLE OF CALLING ISTwatch FROM MS-SQL:
exec dbo.xp_TSearch @input ,@results OUTPUT, @maxNumRes, @ekeys_ON,
@alfacompSwitch, @rangetype, @threshold, @errcode OUTPUT, @retcode
OUTPUT
SAMPLE OUTPUT:
THRESHOLD: 85 %
MAX NUMBER OF RESULTS: 10
---------------------------------------------------
RESULTS RETURNED: 4
SEARCHTYPE: 80
RESULTS: (truncated for simplicity of this example)
"
BIN LADEN, Osama",6365, "100"
"
BIN LADIN, Osama",6365, "93 "
"
BIN LADEN, Usama",6365,"92 "
"
BIN LADIN, Usama",6365, “85”
IST Watch General Information
|
