Hello,

There isn't much help for that error message.  I once had a problem with merge replication where the case sensitive publisher database had data that would have violated a uniqueness...

Peter,

That's where I was thinking of going next.  Like most of the sysinternals tools, filemon is a stand-alone executable that doesn't require "installation".  I've tested it and it has no ill...

Does the DTS package access a file as either a data source or destination?  If so, is that file on a UNC path?

I think if this were the case that...

When I recieved a similar error message, the problem was with the JOB configuration for the step that runs the DTS package.

In EM:  expand the server, and then expand SQL...

I've seen this problem with an MSA1000 SAN on SQL SP3.  In my case, the "corruption" went away when I issued a DBCC DROPCLEANBUFFERS.   Kind of a buzz-kill solution, but it...

Just a point of clarification:  each step can have its own log file, so you need to check this for each job step.

JG

I think I recall seeing this before.  I believe that you might need to check the location that the job step's log file is pointing to.  If the directory doesn't...

One thing worthy of note:

It is almost never always right to use the exact same method for every situation.

If your query works the way it is, and it gets executed...

You can install Developer edition on your XP workstation.

jg

Paging would be caused by the need for data in memory (from vm space on disk), not by the inability to get it off of disk quickly.  Elevated Queue lengths...

Scott:  Good call on the SQRT.  Comparing the square of the distance to the square of the desired distance is a great way to speed up the query.  I...

"Make"  --  Can't you just MAKE a report that will let me see whatever data I want, sorted and grouped however I want?

The packages are stored in a table called msdb..sysdtspackages.  There will be a row in that table for each version of the package.  

Opening and saving to a new location...

Here's some useful information:

http://www.sql-server-performance.com/ck_database_encryption.asp

Unfortunately, physical access will trump this protection method.  As long as I can log in as the same user that runs the SQL service, I can...

If you need a file checksum, there is a win32 console app that will calculate MD5 thumbprints for you:

http://www.fourmilab.ch/md5/

hth jg