 |
|
SQL Server Tips by Burleson |
Testing the Code
To test the XP support, a simple SQL Script called “test.sql” is
located in the XP_NETSEND directory. We first must register all the
XP’s as per normal. This can be achieved using:
EXEC sp_addextendedproc 'XP_NET_SEND',
'XP_NETSEND.dll'
EXEC sp_addextendedproc 'XP_NET_ADDNAME', 'XP_NETSEND.dll'
EXEC sp_addextendedproc 'XP_NET_DELNAME', 'XP_NETSEND.dll'
The rest of this SQL file contains various tests, which send
messages and exercise the various XP’s. For example to send a
message to “PLUTO” from a user-defined “VENUS” name, we would use
the following TSQL:
EXEC master..XP_NET_ADDNAME
'VENUS'
EXEC master..XP_NET_SEND @To='PLUTO', @Message='Hello there',
@From='VENUS'
EXEC master..XP_NET_DELNAME 'VENUS'
The above book excerpt is from:
Super SQL
Server Systems
Turbocharge Database Performance with C++ External Procedures
ISBN:
0-9761573-2-2
Joseph Gama, P. J. Naughter
http://www.rampant-books.com/book_2005_2_sql_server_external_procedures.htm |
