Using the query pietlinden recommended, I received the result I was looking for:.

SELECT DATEDIFF(day, [ExpiredDate], GETDATE() ) FROM MyTable

I just needed to reverse the 2 columns as:

SELECT DATEDIFF(day, GETDATE(), [ExpiredDate])...

thx for the quick replies..  My table has several thousand rows, so I cannot hard code dates as list in the example above.  This SQL gets me kind of close:

SELECT...

thx Scott.. yep, I now understand the location for the SQL “Error Logs” -- which is established at SQL install time (99% of the time we use the default location...

this is valuable feedback.  thanks a million, very much appreciated!

thx for the suggestin Jeff.  I'd really prefer NOT to free the cache..  Looking for the command to mark the procs for RECOMPILE -- across all DB's..

I agree.  Our SQL Replications (Log reader agents, Distributor agents, Snapshot agents) are all running clean with no issue.  It's just when we start up Repl Monitor that the RED...

I found these via a GOOGLE search:

- TeamViewer

- Splashtop (Advertising)

- Chrome Remote Desktop

- Microsoft Remote Desktop

- TightVNC

- Mikogo

- LogMeIn

- pcAnywhere

Again, just looking for feedback from those who highly recommend a...

ERROR: The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine

Thoughts on how to configure our Windows 10 laptop running SSMS 2017 v18.3 on SQL 2017 Developer Edition to allow...

Andrey, thanks.  This is very helpful.  I was hoping there was a 1 line, auto-magical script which could perform much of this but I understand it is a multi-step process.. ...

thanks!  that worked perfectly.   My test results:

To decompress/uncompress a table, I simply changed the DATA_COMPRESSION attribute from PAGE back to NONE:

-- to Compress:

--

USE [my_dbname]

ALTER TABLE [dbo].[my_tablename] REBUILD PARTITION = ALL...

this worked:  EXEC master.dbo.sp_serveroption @server=N'ServerLINKEDServer', @optname=N'name', @optvalue=N'Server_NEW_LINKEDServer'

( I did not need to specify my ServerABC name which is the SQL Server housing the original Linked Server name:...

excellent feedback Steve.  fyi, I've deployed Ola's backup, IndexOptimize and Integrity Check solution on every server so we're good w/ the system & application DB backups (FULLs, DIFFs and T-logs)...

So, based on your feedback -- w/ master and msdb restored to the same-named, remote server name (assuming the original server was destroyed). we'd get the following objects restored:

Jeff - thanks for your reply.  Question - in a D/R recovery scenario, once I restore all my system DB's & application DB's (including SSISDB and Distribution DB) onto my...