exec xp_cmdshell 'systeminfo|find "Time:"'

This works for me

Just felt I should share the code I used to create my restore alerts

USE [msdb]

GO

/****** Object: Operator [Alert Operator] ******/

EXEC msdb.dbo.sp_add_operator @name=N'Alert Operator',

@enabled=1,

@weekday_pager_start_time=90000,

@weekday_pager_end_time=180000,

@saturday_pager_start_time=90000,

@saturday_pager_end_time=180000,

@sunday_pager_start_time=90000,...

OK has anyone solved this issue?

Server and SQL Services were restarted 4 days ago.

Here is the query I am running:

select job.Name, job.job_ID, job.Originating_Server,

activity.run_requested_Date, datediff(minute, activity.run_requested_Date, getdate()) as Elapsed, start_execution_date,...

Here is the code I use to get mount point information. I'm sure someone has a better way but I couldn't find it

/*

This code will go out...

WORKS GREAT!!!!!!

Here is what I did to fix ALL my linked servers

DECLARE @ServerName SYSNAME

, @Message ...

any update on this?

Worked GREAT !!! THANKS

Hey All,

My task and your mission if you choose to accept it is... Move a named instance (all databases, jobs and users) from a standalone server to a cluster....

got it... Thanks

Hey Ed, what happened to the link? I can not find the SQL Server FineBuild Reference

I hope this is not to late. This code gives me an error

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near ';'.

I know I'm missing something. Can you...

I hope this is not to late. This code gives me an error

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near ';'.

I know I'm missing something. Can you...

OK,  one last time.   Has anybody been able to trace to a table?  Andy, in all these years since your article, were you able to get it working?  I am...