 |
|
SQL Server Tips by Burleson |
Registering an XP from
Enterprise Manager
All the examples from this book register XP’s with TSQL but it is
possible to do it from Enterprise Manager, using its nice GUI. The
reason for not using the GUI in the examples is that the files with
the sample code should be ready to run without assumptions of
whether the user registered the XP before or not. Another reason is
that it is easier to test an XP from SQL Query Analyzer by
registering and de-registering over and over again by selecting the
code and clicking on the run button (to execute only that portion of
code) rather than using the GUI.
The XP node is under the master database and this database is
visible only if the permissions for SQL Server allow system
databases and objects. By right clicking on the selected SQL Server,
a menu will show up with an option to edit the properties:
The option “Show system databases and system objects” must be set,
obviously.
Before trying to register an XP it is necessary to copy the DLL file
to the binn folder under the SQL Server folder, which is created
during the installation. All the XP’s must be physically located
there.
The node “Extended Stored Procedures” on the master database has all
the system and registered XP’s. To add a new XP takes only two quick
steps, the first one is to right click on the “Extended Stored
Procedures” node and, from the menu, select “New Extended Stored
Procedure”:
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 |
