Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
neo302
Starting Member
30 Posts |
 Posted - 2006-10-18 : 15:42:40
|
| Hey, I have a Sql 2000 on Server 2003 running an sp that inserts and updates to a 2005 64 bit DB on Server 2003. The SP has worked forever. No code or server changes. Now all of the sudden I randomly get this error. It will work, then fail 3Xs then work, then fail. Very bazaar. Any help is appreciated! I have done the MSDTS, forced TCP/IP. I'm lost.[OLE/DB provider returned message: Unspecified error]Msg 8525, Level 16, State 1, Procedure sp_Util_Calc_DailyInfo, Line 1496Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.Thank you |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-10-18 : 15:58:43
|
| I think that can be translated as - the transaction timed out. Which means that the transaction has started taking longer than it was before, so you could increase the timeout, but you probably also want to do some performance analysis and figure out why things are taking longer than they used to. |
 |
|
|
neo302
Starting Member
30 Posts |
Posted - 2006-10-19 : 09:48:20
|
| Hey, Thanks for the info. I don't believe it's a timeout issue though as the sp doesn't take a long time to run at all. I also have the db set to take as long as it needs.Thanks! |
|
|
|
|
|
|
Weird random error