Skip to content
TheSQLReport.com

TheSQLReport.com

Resolutions found with SQL Server and other types of databases

Primary menu

  • Home
  • SQL Server
  • Oracle
  • Teradata
  • AIX
  • Linux
  • Windows
  • SQL Saturday Presentations
  • About Me

Category: SQL Server

Microsoft SQL Server database system

Which Windows Server is the Clustered Instance is Running On

  • By BlogAdmin
  • 13 March, 2020
  • No Comments

When troubleshooting from SSMS, I need to know which Windows server my clustered instance is running on.   Surprised that this query is not already on the first page of the … Continue Reading →

View List of OLE DB Providers

  • By BlogAdmin
  • 22 February, 2020
  • No Comments

Sadly I have not found a better way to view the available OLE DB Providers on a server.  Even though I am using an out of support Windows Server 2012 … Continue Reading →

Enabling Line Numbers in SSMS v18

  • By BlogAdmin
  • 16 February, 2020
  • No Comments

Working with large sql statements, I find it is easier to have line numbers in the query window. Enabling “Line numbers” process is the same with every version of SQL … Continue Reading →

SQL Server Audit: Error: 25725, Severity: 16, State: 1

  • By BlogAdmin
  • 1 February, 2020
  • No Comments

Recently I received the following error from one of my SQL Servers: Audit: Server Audit: 65536, State changed from: STARTED to: SHUTTING_DOWN Error: 33059, Severity: 16, State: 1. An error … Continue Reading →

Errorlog Configuration Problem When Upgrading SQL Server

  • By BlogAdmin
  • 1 November, 2019
  • No Comments

Problem: This morning when working with one of my SQL Server servers, I went looking for an error log from last August.  After finding that I was only able to … Continue Reading →

Cannot Alter the Schema – Msg 15151, Level 16, State 1, Line 1

  • By BlogAdmin
  • 5 July, 2019
  • No Comments

A rookie developer reached out to me requesting help to move a couple of tables to a new schema.  Thinking the developer did not have permissions to the one of … Continue Reading →

Finding Errorlog File Directory in SQL Server

  • By BlogAdmin
  • 10 June, 2019
  • No Comments

Working with some new monitoring software, I need to locate the directory of the SQL Server’s Errorlog.  This location is not standard and differs by each version of SQL Server.  … Continue Reading →

Quickly Enable the Query Store for a SQL Server Database

  • By BlogAdmin
  • 21 April, 2019
  • No Comments

Probably the fastest way to enable Query Store for a database is run the “ALTER DATABASE” command in a query window. First check that the database is not already have … Continue Reading →

‘fdhost.exe’ Process Is Not Controlled By The Update Wizard

  • By BlogAdmin
  • 2 March, 2019
  • No Comments

When applying a hotfix update to SQL Server 2012, the step where “Check File In Use” produced the following error: The ‘fdhost.exe’ process is not controlled by the update wizard. … Continue Reading →

Error: 9002, Severity: 17, State: 4 – The transaction log for database ‘tempdb’ is full due to ‘ACTIVE_TRANSACTION’

  • By BlogAdmin
  • 2 February, 2019
  • No Comments

Problem: This was a compound problem I had on a production SQL Server 2014 instance.  First was someone who scheduled a couple of load jobs at the same time which … Continue Reading →

Posts navigation

Previous Page 1 Page 2 Page 3 … Page 6 Next

Recommended Blogs

  • James Serra’s Blog Big Data and Data Warehousing
  • TF3604 Blog — Probing the internals of SQL Server
  • SQL Server World
  • Rottengeek?
  • Frugal Fixes
  • Ray Kim’s Blog
  • ClevelandDotNet

Recent Posts

  • Query – Percentage of Physical Memory SQL Server is Currently Using
  • Using Microsoft’s TroubleShootingScript Version 2 (TSSv2) Toolset to Collect Support Information
  • Error: 18452 – login is from an untrusted domain and cannot be used with Windows authentication
  • Excel Error: SSL Provider, error: 0 – The certificate chain was issued…
  • SQL Server – List of All Databases with Compatibility Levels

Archives

  • March 2023
  • February 2023
  • January 2023
  • July 2022
  • February 2022
  • December 2021
  • December 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • March 2014
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013
  • August 2013
  • June 2013
  • April 2013
  • March 2013
  • January 2013
  • December 2012

Categories

  • AIX
  • Linux
  • Oracle
  • SQL Server
  • Teradata
  • Windows
TheSQLReport.com Copyright © 2023 TheSQLReport.com . All Rights Reserved.
Powered by: WordPress | Theme: Simple Catch