|
|
||||||
|
#1
09-18-03, 10:58 PM
|
|
|
|
|
I have an Execute SQL Task in DTS that runs a simple trucate table
command. If I run it by executing only the single step in the DTS designer, it completes very quick, about a second or two. However often when I try to run the entire package, it will take several minutes to complete. Does anyone know why it would take so much longer when running the entire package instead of just the single task? Phil Kay |
|
|
|
#2
09-19-03, 07:14 AM
|
|
|
|
|
Have a look at Profiler and also sp_who2
Maybe in the context of the whole package it is competing with other processes. Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org |
|
|
| Similar Threads | |
| Grant permission to table for truncate table hi, we have object-level user security. That user need permission for truncate one table. I can't set the user as sysadmin or DBO. any way that I could grant the user to have... |
|
| Truncate a table in use? Can this be done in SQL? Every 30 seconds, 400K recs are imported to a table. At the end of 30 secs, the 400K recs are deleted and another 400K recs are imported. This needs... |
|
| Truncate table I'm trying to use a table type variable in my stored procedure: DECLARE @Temp3 table ( RecordID int IDENTITY (1, 1) Primary key NOT NULL , FAccountID int, [Name]... |
|
| truncate table I need little clarification on truncating tables. Here is what BOL sys: TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and... |
|
| truncate table Hi all, Is there a way to truncate a table from a linked DB? Truncate table server.DB.DBO.tablename produces an error. too many parts. TIA, Joe |
|
|
All times are GMT. The time now is 04:31 PM. | Privacy Policy
|
Truncate table in DTS