Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.
--This runs from PubDB USE PubDB select top 1 lastupdate from TABLE1 (NOLOCK) order by lastupdate desc /* The next does the same in the replicated ReplDB via Linked Server.Wouldn't it be it be better here to use OPENQUERY, so I can use the (NOLOCK) hint ? */ select top 1 lastupdate from [REM_SERVER].[ReplDB].dbo.TABLE1 order by lastupdate desc --now the two results will look like that (just an example) --PubDB 2010-08-21 03:30:000 --ReplDB 2010-08-21 01:30:000 --Now the comparison should follow, and if PubDB minus --ReplDB >90 min. an email should notify DBAONCALL@ACME.com
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|i am unable to add data to mysql database||6||55|
|Ideas on migrating very large system from SQL 2005 to SQL 2014||3||33|
|Finding Where Clause Value in SQL Views and SP||21||42|