Do you get tired of reviewing each SQL Agent notifications nightly to determine which SQL Agent jobs failed? Is there a significant number of SQL Agent job notifications that it takes a while to review each? Here is an alternative that allows you to have a single email report of all job failures.
2002-09-17
11,743 reads
New columnist Gregory Larsen used to not care what his objects were called until recently when he began to become concerned with the system generated constraint names. This short article tells you why.
2002-08-16
7,163 reads
This stored procedure produces a report of record counts for every table on your server. The record count report is organized by database, and table name.
2002-05-16
661 reads
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
You paste a slow Redshift query plan into PlanTrace and one of the tuning...
By Steve Jones
As part of my running the SQL Saturday charitable foundation, I get sponsorship money...
Comments posted to this topic are about the item Displaying Money
Comments posted to this topic are about the item The Slow Growing Problems
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers