Objective: Import the content of the excel to a table in the production database. First, import the content of the excel file to a staging database, massage the data, and then export the data as a data script. Steps 1. Create new excel file and copy the content to the new excel file. Original excel... » read more
How to Enable Failure Emails for SQL Agent Jobs Expand SQL Server Agent. Expand Jobs. Right click on a Job > Properties. Go to the Notifications tab. Click to enable Email. Select the correct Operator. Choose “When the job fails” Hit OK. Note: Make sure the SQL Server Mail Account and Profile has been setup correctly.
Error: The operation could not be performed because OLE DB provider “SQLNCLI11” for linked server “xxxx” was unable to begin a distributed transaction. Fix: The default settings were not configured correctly to allow communication with the other servers. These configuration settings are found under the Component Services snapin which can be launched by typing dcomcnfg.msc at a run/command... » read more
Error: Message The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2020-07-23T17:27:13). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay). ) Fix: Make sure the SQL Server Mail Account and Profile are setup correctly.
Error: Msg 18456, Level 14, State 1, Line 3 Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. Fix: Change the login to be… “Be made using this security content:“ Remote login: xxxxxx With password: xxxxx
Script created by SSMS. Severity Alert Error Alert
Create Operator From Script No Pager schedule. Multiple Email Addresses: Add multiple email addresses separate by semi colon “;” E-mail name: address01@test.com;address02@test.com You could create a new operator with the semi colon delimited list of email addresses. Looking at the definition of sysoperators this is good for strings that can fit in nvarchar(100) If you need to exceed... » read more
Auto-growth What exactly are auto-growth events? An auto-growth event is the process by which the SQL Server engine expands the size of a database file when it runs out of space. The amount by which a database file grows is based on the settings that you have for the file growth options for your database.... » read more
Error: Availability group xxxx is not joined on the secondary replica xxxx. (Microsoft.SqlServer.Management.HadrModel) Program Location: at Microsoft.SqlServer.Management.HadrModel.HadrTask.Perform(IExecutionPolicy policy, CancellationToken token, ScenarioTaskHandler taskDelegate) at Microsoft.SqlServer.Management.Hadr.JoinDatabaseToAvailabilityGroupWorkItem.DoWork() at Microsoft.SqlServer.Management.TaskForms.SimpleWorkItem.Run() Failed to join local availability replica to availability group <ag1>. The operation encountered SQL Server error 47106 and has been rolled back. Check the SQL Server error log for... » read more