I can't think of a good reason for it.  Technically, it should not be a problem (except for extra overhead for SQL to maintain 2 indexes).  You might try comparing...

Just for kicks, here's an alternate method using JOINS:

SELECT n.*

FROM @tblNumbers n

LEFT JOIN @tblNumA a

 ON n.ID = a.ID

LEFT JOIN @tblNumB b

 ON n.ID = b.ID

WHERE a.ID Is Null

  AND b.ID Is...

I think it is in sysdtspackages.  Also try

SELECT *

FROM msdb..sysobjects

WHERE Name like '%dts%'

  AND xtype in ('u', 's')

This site has excellent DTS documentation.  http://www.sqldts.com/default.aspx?204.

Good luck.

I don't know your answer, but I experienced being in your shoes once before.  I ended up speaking with the company which made the ODBC driver.  In that case (it...

Prakash,

In regard to your last question, as Richard mentioned, various operations use tempdb.  What determines if tempdb grows in size is not so much that you are doing these operations,...

Also, don't forget about FULL OUTER JOIN.  A discussion on outer joins would not be complete without that. 

Hi Homero,

Everyone has given you good advice.  Here's what I suggest:

Start up QueryAnalyzer.  Make sure the drop down at the top shows the "master" database.  Tye in sp_who2, and click...