Unfortunately, SQL Server doesn't like to have concatenated stuff passed to parameters. So, you could do something like this:

declare @strBody varchar(255);

select @strBody = 'This is to test that today...

I cannot tell you how many times I've been busted for forgetting to alias things. 😀

Much better than my suggestion - I didn't even consider that. I love it! Thanks.

Is this what you're looking for?

insert into different_table(computername, auditid, auditdate)

select computername, auditid, auditdate

from original_table a1

where auditdate = (select max(auditdate)

...

Did you resolve why you get the names of your variables and not the values? When you set @message_body, you shouldn't quote your variable names because they're treated as...

I'm not entire sure what you're asking, but it looks like you want to semi-automate some SQL creation scripts. If this is the case, then you might want to...

Is LINQ what generated a query that looks like that? I don't use it myself, since it seems like just another layer of obfuscation around using SQL and I...

My question for you is about timing. If the query is run from the .NET application and takes 30 seconds, when it's run again right away, does it drop...

There's several different avenues of approach here and I'm sure I won't see them all without having the DDL to play around with.

The first thing I notice is that a...

I agree with SQLRNNR - SQL Sentry Plan Explorer is a good product. There's a free version and a paid version, which is pretty cheap. It gives you...

So you probably have a deadlock situation - both pieces of code are waiting on a lock to the same object. I believe the X in the last part...

Whenever I have a wait stats question, I look up Paul Randall's list: http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/

According to this page:

This is simply the thread waiting for a lock to be granted and indicates...

Anthony is right - please look at the MSDN page for how to execute the sp_send_dbmail procedure. He gave you a link to the page. This is one...

You shouldn't be using QUOTENAME on the disk location. Just enclose it in single quotes.

You aren't passing any of your parameters to the EXECUTE sp_send_dbmail statement.