Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old June 2nd, 2005, 01:17 PM
Authorized User
 
Join Date: Sep 2004
Location: , , .
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default Linked Server Question

I am attempting to populate a table on a linked server with values
from my local sql server table's trigger. I am able to manually select, insert, update, delete rows from query analyzer the linked db table but when I execute the trigger on my local table the server will hang indefinately. My insert statement within the local table's Update trigger goes like this:

insert linkedserver.linkeddb.owner.linkedtable(OrderTotal , Account)
select OrderTotal, Account
from inserted

Why does the server hang when executing this insert statement?


  #2 (permalink)  
Old June 2nd, 2005, 04:31 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Do you see any entries related to that on event viewer?

_________________________
- Vijay G
Strive for Perfection
  #3 (permalink)  
Old June 3rd, 2005, 08:00 AM
Authorized User
 
Join Date: Sep 2004
Location: , , .
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

No messages in the event viewer regarding this.

  #4 (permalink)  
Old June 3rd, 2005, 02:19 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Then no clue on why it hangs. May be you got to look for other alternates. Check your sql server error log and look for the entries in that around the time when it hanged. There might be some clue on that.

It should be under MSSQL\LOGS folder on the drive in which your sql server is installed.

_________________________
- Vijay G
Strive for Perfection
  #5 (permalink)  
Old December 14th, 2005, 02:48 PM
Registered User
 
Join Date: Dec 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

any answer ?
i get pro same "realgone_"??
F1F1F1




Similar Threads
Thread Thread Starter Forum Replies Last Post
Linked server with Identity_insert on b_amit76 SQL Server 2000 2 February 22nd, 2005 12:35 PM
Linked Server w/ VFPOLEDB pjconrad SQL Server 2000 2 November 17th, 2004 07:27 PM
linked server ginoitalo SQL Server 2000 2 September 30th, 2004 08:16 AM
Update - Linked Server venkatpala SQL Server 2000 3 August 25th, 2003 11:45 AM
Linked Server to Oracle ioates SQL Server 2000 3 June 10th, 2003 02:42 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.