Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Stored Procedure across Multiple SQL servers
I have many situations where I have to write stored procedures across multilple servers because our shipping systems is on a different server than our accounting server. For Example Select * From accserver.db1.dbo.Table1 t1 join shpserver.db2.dbo.Table2 t2 on t1.Order = t2.Order This...- ksutphin
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Executing a batchfile with cold fusion
I had the following code running on an old ColdFusion 4.0 server. The code calls a batch file that goes out to our domain, loops through all of our terminal servers, and resets certain application sessions for the user that is running the cfm page. <script language="JavaScript">... -
Great Plains PO Pricing
I'm wondering if it's possible to use a SQL script to update the unit price on a purchase order. I know I could write the script to update the POP10100 table, but does any one if there are other tables that would have to be updated as well? Is this even a possibilty or would I be making a...- ksutphin
- Thread
- Replies: 0
- Forum: Microsoft: Dynamics GP (Great Plains)
