Find out why a transaction (DTS) failed

Please support our MS SQL advertiser: Intel Parallel Studio Home
Reply

Join Date: Jan 2009
Posts: 3
Reputation: DBGuy007 is an unknown quantity at this point 
Solved Threads: 0
DBGuy007 DBGuy007 is offline Offline
Newbie Poster

Find out why a transaction (DTS) failed

 
0
  #1
Jan 22nd, 2009
In SQL Server Profiler you see that a transaction starts and one line below it fails but I have no clue why the transaction fails.
The transaction was initiated by a C# program using a table adapter and LINQ. In Visual Studio you see that the transcation fails but not why it fails.

Need help to determine why the transaction fails.

Thanks in advance.
Reply With Quote Quick reply to this message  
Join Date: Aug 2006
Posts: 2,065
Reputation: Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice 
Solved Threads: 256
Featured Poster
Ramy Mahrous's Avatar
Ramy Mahrous Ramy Mahrous is offline Offline
Postaholic

Re: Find out why a transaction (DTS) failed

 
0
  #2
Jan 22nd, 2009
Catch the transaction code, and show me the error raised!
BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Other Threads in the MS SQL Forum


Views: 519 | Replies: 1
Thread Tools Search this Thread



Tag cloud for MS SQL
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC