Thank you for your help and response. Happy learning.

Have great weekend.

Thank you Lowell. It is working good.

I just have few doubts.

Is there any difference to use this, both are returning same date and format.

"SET @dt=CONVERT(CHAR(8),DATEADD(HH,-24,GETDATE()),112) " . Since...

Thank you Lowell. I got similar kind of code from some website. But, I do not know, how to remove next run success job from the result.

Ex: job_A runs every...

• This reply was modified 3 years, 5 months ago by  Saran.

Thanks, that does not working.

Thank you, I never know, date filed can accept zero and default start date is 1900-01-01 00:00:00.000.

select DATEDIFF(mm,0,getdate()) -- DATEDIFF ( datepart , startdate , enddate )

select DATEADD(mm,DATEDIFF(mm,0,getdate()),0)

select DATEADD(mm,0,0)-- DATEADD...

I have tried and run each separately, the middle part DATEDIFF, I could not get it.

 select top 3 [Date] from #tbl_monthly_get_data
 select top 3 DATEDIFF(mm,0,[Date]) from...

• This reply was modified 4 years, 5 months ago by  Saran.
• This reply was modified 4 years, 5 months ago by  Saran.

Thank you Sir! This works what I expected.

Happy learning.

Thank u.

Sorry that was typo \\.

Just used other option -Credential $psCred -Verbose

[Update-DbaInstance] Explicit -Credential might be required when running agains remote hosts and -Path is a network folder

WARNING: [20:57:22][Update-DbaInstance] Failed to enumerate files in -Path |...

Thanks, I have admin access to the remote server, do I need to add in any particular group of local policy.

One option with Powershell is to use dbatools and the cmdlet Update-DbaInstance. You can find more information on that cmdlet in this link: Update-DbaInstance

An example of how to...

Thanks Sue.

Yes Jeff, the same I have asked our management, they want all in zero cost. We are small 3 person team.

Msg 468, Level 16, State 9, Line 49

Cannot resolve the collation conflict between "Latin1_General_CI_AS_KS_WS" and "Latin1_General_CI_AS" in the concat operation.

Thanks Chris for script.