Did he use a triangular join or a temp table solution??

I guess that even the temp table solution would be very comparable to the cursor if not faster.

 FROM (

        SELECT 1 AS RentID, CAST('2006-01-01' AS

This was triple-posted by error.  Please use this thread to answer :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=336829

This was triple-posted by error.  Please use this thread to answer :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=336829

He is just using your sample data.  He is not hardcoding anything. 

PS Sorry but I haven't had time to resink myself into this one.  I can solve it but it...

Actually many reasons.  Here's the main one :

DECLARE @t1 AS NVARCHAR(4000)

DECLARE @t2 AS NVARCHAR(4000)

SET @t1 = REPLICATE('a', 4000)

SET @t2 = REPLICATE('b', 4000)

SELECT 0 WHERE (@t1 + ISNULL(@t2, '')) like...

3)

Check out INDEXPROPERTY in BOLS, especially the options IsAutoStatistics AND IsStatistics.  And yes they are objects (but not in sysobjects)

4) Creating an index just creates an index. Statistics can be...

One step better.  This should lead you directly to the packages using dtsrun :

Select J.Name As Job_Name, Step_name, * from msdb.dbo.SysJobs J inner join msdb.dbo.sysjobsteps JS ON J.job_id =...

It's good to keep that in mind... However table variables and temp tables are often interchangable.

You can but it must be in the source of the cursor.  The fetch command works only with the cursor... nothing else.

And for using table name you'd have to use a cursor like so :

DECLARE authors_cursor CURSOR   FOR SELECT * FROM @TableVarOPEN authors_cursorFETCH NEXT FROM authors_cursor

BTW You'll then...

Exemple : Select count(*) FROM ALL tables.  I suggest you run this on a small database like pubs or northwind...

CREATE TABLE #Results (TableName VARCHAR(128), Total INT)

INSERT INTO #Results (TableName, Total)

EXEC...

Ya create a new DTS, save it.  Then in EM / Local packages right click on the new package, schedule...  Create any new schedule for the package and save.  You'll...

Why not use SELECT TABLE_NAME

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE = 'BASE TABLE'

ORDER BY TABLE_NAME

 as the source of the trigger?

also you might want to check : EXEC SP_MsForEachTable 'PRINT ''?'''

No I'd assume that there's a job linked to that dts.

Check out the jobs and try to find the string dtsrun with a whole bunch of numbers... that'll be the...