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 |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2006-11-13 : 08:01:33
|
Hi all,I've recently stumbled across quite a few DTS-packages with sql-tasks that fire off stored procedures. Most of them are working fine but I just came across one that failed with the error message "lack of resources". The sql-task looks like this:begin transactionexecute myprocedurecommit Personally I would remove the implicit transaction around the procedure call but that doesn't seem to be the problem. The procedure only do stuff on the local database (no DTC involved) and when I run the statement from SSMS it runs great. But when I execute the task manually from the DTS designer the execution fails because of "lack of resources". I have other sql-tasks both before and after within the same DTS and they seem to be working fine. Have anybody experienced anything like this before?--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-11-13 : 08:55:37
|
| Hmm...seems I was wrong...DTC is involved after all. I overlooked a view that queries a linked server. Now what if I remove the implicit transaction...hm...I have had numerous problems with DTC before so maybe that'll do it.--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
 |
|
|
|
|
|
DTS/SP's and lack of resources