We've been hit with CryptoLocker 5-6 times already. Each time it's been a network share in one of the branch offices that's been affected.

The Infrastructure guys here have become very...

Probably take this line out of the script 🙂

line 131

and job.name in('Ordina_Backup_Full','Ordina_Backup_Diff','Ordina_Backup_Log')

So a better article would guiding them how to upgrade...

Another Windows Server 2003 Failover Clustering article?

Windows Server 2003 extended support ended on July 14, 2015

http://www.microsoft.com/en-au/server-cloud/products/windows-server-2003/%5B/url%5D

Yes that's right Extended Support ended months ago. Lets not lower the standard of SQL...

Jeff, surely you're forgetting the times when you need a XSL file and namespaces declarations :-D:-D

That looks to have done it. Awesome work thanks.

Knight (10/8/2015)

---

You can monitor network share space very simply. Just use the DIR \\sharename cmd and the last value is free space 🙂

EG.

DECLARE @cmd VARCHAR(2000)

SET @cmd = 'DIR "\\SHARENAME"'

EXEC xp_cmdshell...

Thanks for all the responses so far. Unfortunately all of them don't quite get there :crying:

The tripping point seems to be the [Element4] values. As shown in the desired output,...

Very nice.

Running SQL 2012 11.0.3412 (SP1 + CU9), needed to add this to the sp_send_dbmail execute, otherwise results were in the email body.

,@attach_query_result_as_file = 1

jfogel (6/17/2013)

---

philcart (7/6/2011)

---

Firstly, I'd ask what is behind the requirement to run the subscription using T-SQL? That really defeats the purpose of setting up the subscription in the first place....

Ok, that makes sense now.

So if you select from the #ERRORLOG table, what do you see? I'm going to guess that you'll see "9 lockTimeout=" in the LogDate column. If...

@SQLR45, Are you sure that bit of code is where the...

Couple of suggestions

1) Put the html css into a table (AlertContacts, or AlertSettings maybe). Then it can be more easily customized to a users corporate color scheme.

2) Don't mix use...

Looks nice for a single server, any thoughts on producing a consolidated summary report across multiple servers?

My current repository collects data locally. That data is then aggregated to my management...

mmartin1 (2/15/2013)

---

So in your model, if I got a new cell phone and number , you would need to create a new entry for me. Do you know for a...