I agree with Jason. But don't take our word for it. Try them both, and compare the execution plans.

John

You're right - you can't do it like that. Here's what I would do. It's from memory, so forgive me if the details aren't 100% accurate.

(1) Create a...

If Column1 is bit, it won't be an empty string. It'll either be 1 or 0 or NULL.

John

One alternative is to use the Execute SQL task instead to run sp_send_dbmail, which allows multiple attachments.

John

Having two nested WHILE loops is likely to be a performance killer. See if you can rewrite them into a set-based operation. As Bhuvnesh mentions, please post table...

The your first statement should start IF NOT EXISTS, should it not? In any case, please post the results of the following query:

SELECT * FROM tempdb.INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME LIKE '#temp%'

John

The error is occurring in the stored procedure itself. Do you get the same error if you run just the EXEC line?

John

What application are you using to do the inserts? What happens if you run the same insert statements from Management Studio?

John

Brilliant - learned something else! Perhaps I should have used the word "gracefully"? Anyway, I've edited my first post by striking out the word "cleanly".

John

GilaMonster (1/8/2013)

---

Files that are copied when SQL is stopped or when the DB is offline or detached are static. Files that are copied while the database is active are not,...

GilaMonster (1/8/2013)

---

That's attaching without the log...

There shouldn't be a problem with the version difference. Have you tried it, though? That's the best way of finding out. It will depend on whether the...

Does this[/url] help?

John

Have you tried Full Text Indexing?

John

If this is an ad hoc query you wish to run against multiple servers, you might consider setting up a Central Management Server.

John