May 12, 2008 at 10:50 am
Hi everybody, I have a sql server 2000 with a linked server 2005, so I have a store procedure that execute the follow line code without errors:
insert into server1.table values ('sss',''ssss')
but when I modify the same lines code:
begin
insert intp server1.table values ('sss',''ssss')
end
show the follow error:
[OLE/DB provider returned message: Timeout expired]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returned 0x80040e31: Execution terminated by the provider because a resource limit was reached.].
Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error. Execution terminated by the provider because a resource limit was reached.
Why? Thanks by your help
May 12, 2008 at 1:41 pm
It may be the connection limit, internet traffic jam, or some other reasons. Does it happen all the time or occasionally?
May 12, 2008 at 2:48 pm
All time succeded this.
By example run this:
BEGIN
update server1.table set Comments ='TEST' where adcid=2
END
this execute without problem, but when I execute this, show the same error:
BEGIN TRANSACTION
update server1.table set Comments ='TEST' where adcid=2
COMMIT TRANSACTION
end
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply