USE [msdb]
GO

/****** Object: Job [DBA - Gerar Script de Criação de Todos os Bancos e Objetos] Script Date: 15/10/2023 07:04:19 ******/
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
/******...

I have a code generated by other person, but it does not work. The code follows below:

thanks

Thanks.

With these changes made, am I able to restore the database to 5 hours ago, for example?

But I have many tables, many querys, this is only a short part of code, the code have more than 450 lines, I need to do a report, I belive...

I need to use a variable because I have to do many things before send a message, follow part of code:

DECLARE @saida VARCHAR(MAX), @MSG VARCHAR(MAX)

SET @saida...

I found this Sources from: https://solutioncenter.apexsql.com/multi-server-script-to-automatically-monitor-sql-server-availability/

I run this script in power shell

Thank you so much. I change all columns size. It's solved.

I will check if  there is a column on tbl_serveravailability which is not wide enough to accept the data which is being inserted into it.

How to solve this problem ?

Function Get-ServiceInfo {

Param(

[String]$Server,

[String]$SQLInstance,

[String]$SQLService,

[String]$SMTP,

[String]$To

)

# Get the current datetime

$logdate = (Get-Date).ToString('MM/dd/yyyy hh:mm:ss')

#Function created to send email

Function sendEmail

{

param($from,$to,$subject,$smtp,$body)

[string]$receipients="$to"

$body = $body

$body = New-Object System.Net.Mail.MailMessage $from, $receipients, $subject, $body

$smtpServer = $smtp

$smtp = new-object Net.Mail.SmtpClient($smtpServer)

$smtp.Send($body)

}

#Test the...