I think the article has a typo. I replaced (@outage_weekday_mask & DATEPART(dw, GETDATE ()) > 0) with (@outage_weekday_mask & POWER(2, DATEPART(dw,...
A while back I ran across something peculiar in BOL for the UPDATE grammar 'SET ... @variable = column = expression'. It's in there check it...
Another workaround is to create a job which would execute under the credentials of the sql agent or sql agent proxy account (if enabled). As long as...
How about just grouping by year and month? use pubs select year(ord_date), month(ord_date), count(*) from sales group by year(ord_date),...
Check out SQLPing. It allows you to scan a range of IP addresses and determine sql version. Best of all the C# Source is available for download....
I've created two methods based on 'pubs' database 'authors' table. Method #1 is a stored procedure with 'order by' driven by a scalar function...
Viral - During testing, we've discovered another bug in the Log Shipping Alert suppression process. <br /><br />In the proc...
Viral - We're having problems suppressing log shipping alerts as well. Some research has led us to identify a bug in the procs...
Separate names with a comma.
