Copy Table using SELECT INTO
Example: Use the following to create a copy of the original table data in the database.
Import Data from Excel
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
Enable Failure Email for SQL Agent Jobs
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.
Linked server was unable to begin a distributed transaction.
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
Unable to send email from SQL Server
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.
Linked Server Login Failed
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
Create Alert from Script
Script created by SSMS. Severity Alert Error Alert
Create Operator
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
SQL Server Autogrowth
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