My problem ended up being with the SMTP Configuration as well. As soon as we got that ironed out, SQL Server started sending messages immediately.

Essentially, all of the messages...

OK, It looks like this issue has come back again today.

The last email went in at 8:23 AM this morning, and is showing as unsent. When I run...

It works most of the time, so I don't think it is a permission thing. I've double checked with our Network and Mail admins, and they have confirmed that...

Iain, Thank you for the information.  I'll be sure to post back if I run into any issues, and contact if I really hit a wall.

Todd, That could very well...

Yes.  I could get to all of the other nodes in the cluster.  The machines were still hot even though nothing was actively running on them.

If you just want to use the default providers in SQL Express you can just run the web app.  The Provider will take care of creating the database on the...

Unfortunately that is going the wrong direction.  I don't want to take out the white space.  I need to 'add' it to the HTML version.

After a large amount of searching,...

I'd probably format it a little differently.  I'd also use Scope_Identity instead of @@Identity.  That's just to make sure that two different people don't get mixed up.

myAtomCmd.CommandText =...

Here's one option:

SELECT a.*

FROM myTable a

  JOIN ( SELECT cust_id, Max(app_id) As MaxID

    FROM myTable

    GROUP BY cust_id ) b ON a.app_id = b.MaxID

Why don't you create a Stored Procedure that does all of this at once?  Then within the Procedure you can use Scope_Identity() instead of @@Identity to make sure that you...

If you create a parameter named Test.  You can get it's value by using the following expresion:

=Parameters!Test.Value

If you pass it in on the query string SSRS...

You shouldn't need to parse the variable out.  SSRS should do it for you.  As long as the Parameter exists, it will be populated from the Query String.

You shouldn't need...

I think SP1 contains the fix for this particular issue.  I haven't noticed any significant delays since the install.  I'm going to keep monitoring it just to make sure I'm...

I can use either Contains or ContainsTable.  It shouldn't  make a difference for my current needs.

Looking at the Execution Plan for either query I get essentially the same thing.  Running...

Try giving the Variables sizes:

declare @temp1 varchar(10), @temp2 varchar(10), @temp3 varchar(10)