In message <A1F9550F-BADF-4543-AFF5-4E1F05147FE6 (AT) microsoft (DOT) com>,
vandermeiden <vandermeiden (AT) discussions (DOT) microsoft.com> writes
Quote:
I have extended stored procedures in the master database that were created by
an application. we are looking to replicate the server. How do I replicate
the extended stored procedures or even just transfer them over to the new
server. |
I don't think the Dts group is an appropriate place for this question.
You cannot replicate master, so you will need to copy the file into the
binn directory on the server, and add the proc to SQL, e.g.
exec sp_addextendedproc 'xp_proc_name', 'dllfile.dll'
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org