Disk space alert per drive
This script validates the sufficient disk space per drive.
When you'll reach a minimum on a diskdrive, the script will mail all recipients.
2011-12-07 (first published: 2011-10-28)
3,858 reads
warning
RE: Stored Proc and Master DB
I don't know how are you using the parameter but this sholud helpyou going Declare @str varchar(200) SET @str = DB_NAME()--Assuming is going to be runned from other databases only --otherwise use dbname as a parameter +'.dbo.sp_helprolemember ' + '''' + 'RoleName' + '''' --print @str exec (@str) I don't know why can't the "plus" […]
2003-11-13
2003-11-12
2 reads
RE: Export to Excel without DTS. Possible?
Thanks for the tip of using Tab delimted, renamed to XLS. It works great! Using xp_sendmail, do any of you know a way to change the default attached message from .txt to .XLS?
2003-08-28
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers