The only thing I can think of is that there's some anomaly in your Numbers table. What does this return?

select MIN(number), MAX(number), COUNT(number)

FROM Utility.numbers where number <= 96

John

Does this help, or is there something in particular you don't understand about sp_send_dbmail?

John

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...