Everyone,

Thanks for the reply's here is the end result, maybe someone can use it somehow 🙂

SET DATEFORMAT mdy;

GO

DECLARE @datevar date = getdate();

DECLARE @subjectCheck AS NVARCHAR(MAX);

IF EXISTS (SELECT CurrentDate from LOG_SHIP_CHECK...

George,

The alert is up and running. I only recently upgraded from SQL 2000 to SQL 2008 R2. Now the problem is that log shipping SQL 2000 is not...

george sibbald (6/15/2011)

---

last log restored information should be good enough, but you could add your own table to the primary, update on a regular interval and check the value in...

HI,

script looks greate but when i exec the script i get the the following:

Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'master.dbo.spX_SendDBMailOperator'....

I work from 8 to 16:30 and that's it. I have no problem doing overtime to get things done. nor do i have a problem checking on tasks that are...