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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-18 : 17:56:43
|
| Rajesh writes "I have a stored procedure to insert and update a table with Transactions (Begin, Commit and Rollback) specified in it. I have created a SQL Task in a DTS package and executing that stored procedure with two parameters given as global variables. It is running for one minute and but doing nothing. If I execute the same stored procedure through SQL Query Analyzer it works fine,it runs for 7 minutes and does its job. What might be the problem?" |
|
|
|
|
|
DTS and Stored procedure