943,708 Members | Top Members by Rank

Ad:
  • MS SQL Discussion Thread
  • Unsolved
  • Views: 643
  • MS SQL RSS
Jan 22nd, 2009
0

Find out why a transaction (DTS) failed

Expand Post »
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.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
DBGuy007 is offline Offline
3 posts
since Jan 2009
Jan 22nd, 2009
0

Re: Find out why a transaction (DTS) failed

Catch the transaction code, and show me the error raised!
Featured Poster
Reputation Points: 480
Solved Threads: 276
Postaholic
Ramy Mahrous is offline Offline
2,189 posts
since Aug 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: User Defined Functions
Next Thread in MS SQL Forum Timeline: How to get the previous row for a selection criteria





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC