Re: Extended Stored Procedures
From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 11/04/04
- Next message: Darren Green: "Re: SQLDTS Date Offset function"
- Previous message: Toney: "Re: Drop & Create Table - DTS Export to Excel"
- In reply to: vandermeiden: "Extended Stored Procedures"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 4 Nov 2004 23:23:07 +0000
In message <A1F9550F-BADF-4543-AFF5-4E1F05147FE6@microsoft.com>,
vandermeiden <vandermeiden@discussions.microsoft.com> writes
>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
- Next message: Darren Green: "Re: SQLDTS Date Offset function"
- Previous message: Toney: "Re: Drop & Create Table - DTS Export to Excel"
- In reply to: vandermeiden: "Extended Stored Procedures"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
