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 |
|
rupertsantos
Starting Member
1 Post |
 Posted - 2007-10-04 : 12:13:19
|
| When I execute my stored procedure via a sql task in a DTS, it takes me almost 30 minutes. However, if I execute that exact same stored procedure in query analyzer, it finishes under a second. Why is this happening. Help please... THe strange thing also is if I copy the content of the stored procedure into the sql task in the DTS instead of executing the stored procedure, it finishes under a second.Any help would be appreciated. |
|
|
|
|
|
Execute Store Procedure in DTS extremely slow