Script to Read Error Log, Scroll Cursors and ADF Script Activity (MSSQLTips 10/14/2022)

[Scroll Cursors in SQL Server]( A SQL Server cursor is T-SQL logic to loop through a finite number of rows which are determined by the query that is used to load the cursor. Cursors are mainly used to perform sequential operations on the rows. The cursor can be viewed as a data set or a list of data which can be looped through for logical operations. In SQL Server, cursors are generally used to iterate through the entire loop sequentially, but with a scroll cursor there is the ability to access specific rows from the cursor which we will discuss in this article. [continue reading]( [Leveraging the Script Activity within Azure Data Factory]( Azure Data Factory (ADF) is a popular extract, load, and translate tool (ELT). This same engine is part of the Azure Synapse suite of tools. However, using this technology to deploy and populate a standard SQL database is not possible. Two popular ways to call Transact SQL (T-SQL) are the lookup and stored procedure activities. The lookup activity returns the result set from a given query, and the stored procedure activity only works with an existing SQL Server database. Learn how to execute data manipulation language (DML), data definition language (DDL), or data control language (DCL) statements within a standard ADF pipeline. [continue reading]( Script to Find Errors in Error Log USE master GO DROP TABLE IF EXISTS #errorLog; -- above is new syntax in SQL 2016 and later --IF OBJECT_ID('tempdb..#errorLog') IS NOT NULL DROP TABLE #errorLog -- above is old syntax prior to SQL 2016 CREATE TABLE #errorLog (LogDate DATETIME, ProcessInfo VARCHAR(64), [Text] VARCHAR(MAX)); INSERT INTO #errorLog EXEC sp_readerrorlog 0 -- specify the log number 0 is active SELECT * FROM #errorLog a WHERE EXISTS (SELECT * FROM #errorLog b WHERE [Text] like 'Error:%' AND a.LogDate = b.LogDate AND a.ProcessInfo = b.ProcessInfo) [Get more details about this script]( More on MSSQLTips: [Tips]( [Tutorials]( [Webcasts]( [tag] You are receiving this email as a subscriber of MSSQLTips.com. [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC | PO Box 682 | Wilton, NH 03086 | [Privacy Statement]( Sent to this e-mail address: {EMAIL}