Hi ,
Any Body can help in knowing, How i can migrate the Extended Stored Procedure from one server to another.
Hi,
sure you can simply copy the dll which contains the logic for the xp to the new server in the BINN directory and run the command:
exec sp_addextendedproc 'xp_proc_Name', 'xplibrary.dll'
That′s it.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment