Brilliant! This works for me. Thank you!

David

Okay, if someone can at least show me how to parse the string and put the number for each of the possible date parts into variables, that would be most...

I actually don't need the exact date taking into account leap year. I will just assume 1 year is 365 days and 1 month is 30 days. That...

I will have a specific date that I will need to to add this calculated # of days to. For example, 20120612. I will be getting this from...

Here is another version that also gives you the lead blocker when blocking occurs. This is designed to be run in SSMS for SS 2005 thru 2008 r2.

SET NOCOUNT...

You can try this one I published today in SS central:

http://www.sqlservercentral.com/scripts/Administration/88041/

SET NOCOUNT ON

GO

IF OBJECT_ID('tempdb..#curSQL') IS NOT NULL

DROP TABLE #curSQL

GO

CREATE TABLE #curSQL

(spID SMALLINT,

blocked VARCHAR(3),

hostName VARCHAR(2000),

dbName VARCHAR(100),

cmd VARCHAR(100),

sqlText NTEXT,

phyIO...

This works fine on my test data but when I try it on actual data, I get the following message:

Msg 242, Level 16, State 3, Line 1

The conversion of a...

I am all set Jeff. Thank you!

David

Jeff, yes the pipes are in the data. Thank you for the link as well!

I do have an active connection in the object explorer but oddly it does not even give me the option to connect in the query window. The execute query...

Would I be able to install SQL Server 2008 R2 Standard Edition on the same server as the current SQL Server 2008 R2 Express Edition?

Here is the solution:

In SQL server Management Studio -> SQL Server Agent -> properties -> Alert System -> Enable mail profile. Give SQL Server Agent a restart and it works!

Yes. I am seeing these entries in the SQL Server log:

10/13/2011 09:35:38,,Error,[264] An attempt was made to send an email when no email session has been established

10/13/2011 09:34:36,,Warning,[408] SQL...

Yes I have.

This system is somewhat stressed already so with that said, are there any recommendations as to which tools would have the least impact?