Are you really using SQL Server 2000? Works for me on SQL Server 2008. Could be something to do with the way your dates are being interpreted. ...

SSIS is probably the way to go here. Otherwise, create a table with the same columns and data types as the DBCC output, and do INSERT INTO MyTable ('EXEC...

If you're using the query you just put into your original post, that's an INNER JOIN, and it will only show you the similarities, in the same way that INTERSECT...

Yes, I think you just need to lose those parentheses. You can actually shorten it even further, like this:

CASE Fruit

WHEN 1 THEN 'Apple'

WHEN 2 THEN 'Banana'

ELSE 'Cherry'

END AS Word

You...

You can use INTERSECT to find the similarities, or EXCEPT to find the differences. Or you can use a FULL OUTER JOIN if you want to see the differences...

By enumerating...

In that case, please will you post everything you've done so far,...

Ritesh

The package name is just the path and the filename - something like x:\MyDir\MyPackage.dtsx. There are no command line switches. If you need to configure your package you'll...

Ritesh

Just use an expression to set the name of the package in the Execute Package task. That's equivalent to passing in a parameter.

John

As far as I know, that isn't possible, since it would compromise the inherent security of Windows authentication by exposing the password. You could have a look in connectionstrings.com...

Those decimals at the ends of the rows don't convert into datetime values, I'm afraid. But seriously, I really think full-text indexing is the way to go on this....

That's closer, but we need the actual values in the insert statements. Do you see why? Somebody can just run your CREATE TABLE statements, then run your INSERT...

Andrew

I was being facetious - pointing out that it's always better to do your backups and restores through the command line than go through the fiddly GUI wizard. That...

No, INSERT statements. Many people won't bother to open a spreadsheet (may contain viruses), and of those that do, most won't have the time or inclination to import all...

Iain

Is it possible that SQL Server (or SQL Server Agent) wasn't running at the time the job was scheduled? Maybe somebody restarted the server, or perhaps if you have...