I'm assuming you are running the DTS package from SQL Server Agent based on the error message you've given. Is the SQLServerAgent service running under the same account on the...

Using COUNT(*) as you have is a typical way to get full intersection when you have a structure similar to the way you do. Is there a reason why you...

Please do not cross-post. This is a topic that does belong in Administration. As a result, I have locked this topic in the General forum.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

You don't have to use TempDB. The poster was using it as an example. One of the advantages of TempDB is it gets rebuilt when SQL Server is restarted. Therefore,...

The version of MDAC with SQL Server 2000 is 2.6. The version that shipped with Windows 2000 is 2.5. So it's failing on the update. What you might try is...

Enterprise Manager and Query Analyzer are both part of the client tools for SQL Server. I'm not up to spec on what typically comes with MSDE, as we don't use...

If I remember right, MSDE doesn't come with the SQL Server Enterprise Manager. I believe we installed Office Server Extensions to give 'em a run and of course it dropped...

If you put in the SQL 7 CD, you have the option to install the client tools.

Enterprise Manager itself is actually a .msc file that requires MMC. For SQL...

A table preceded by ## is a global temporary table. The problem with using a local temporary table is it can only be seen within the stored procedure that seens...

What are you using to do the import? Perhaps the problem is there and not with the table? The reason I say this is because it says there is an...

If you are looking for the # of rows affected by a single SQL statement, there is @@ROWCOUNT. For instance:

DECLARE @Rows int

K. Brian Kelley
@kbriankelley