SQL 7/2000 Stored Procedere Help


Well Known Member
I need some help doing a stored Procedure in SQL 7/2000

1) Can a StoredProcedure access 2 different Databases. IE. JDE_Production
and JDE_Crp
2) And if so what would an example look like to insert all records from 1
table into the same table in 2nd database.

I need to be able to write all records from the F47011 table from JDE_Crp
into the F47011 in Production


William "Brian" Wilkinson
Senior Technical Specialist
Quickie Manufacturing
[email protected]
856-829-7900 x143

JDEdwards OneWorld B7332 SP14.1
Microsoft Windows NT 4.0 Server Platform SP6a
Microsoft Windows NT 4.0 Terminal Server
Microsoft SQL Server 7.0 SP2 with hot fix 851
Microsoft Mdac 2.5
Citrix Metaframe 1.8

William “Brian” Wilkinson
Quickie Manufacturing
[email protected]
856-829-7900 x143


Use the table copy tool via the Object Librarian. Select the table and go to
FORM and select the table copy exit.