Stored Procedure not returning when finished

[system]

Search for stored procedure transaction from the DI forum (and include all sub-forums) and you get these additional ones:

120×120 10.4 KB

This is the scenario DI: windows 2003 server, service running under local system admin Repo: Sql Server 2005 Datastore: sql server 2000 on a different server trying to execute a stored procedure from within a script sql(‘datastore’,‘exec stored_proc’); keep getting an error 8532 10184 DBS-070401 10/9/2008 6:42:13 PM ODBC data source error message for operation : <[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB 8532 10184 DBS-070401 10/9/2008 6:42:13 PM error trace [OLE/DB Provider…

120×120 10.4 KB

A stored procedure completed with in 4 minutes in db engine is running more than 20 minutes to finish through DI job. How to tune the stored procedure calls for better performance Raj rajbodi (BOB member since 2008-03-17)

---

dnewton (BOB member since 2004-01-30)