SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• SSRS email via Subscriptions

  All, Getting this error: Failure sending mail: The remote certificate is invalid according to the v…

  dbigelow123

  4 replies

  1 years, 8 months ago

  By: cyrusbaratt

• DBCC CheckDB errors

  How can I identify automatically(like email alert if error shows up) through code if DBCC check db …

  mtz676

  8 replies

  1 years, 8 months ago

  By: cyrusbaratt

• What is the \"from\" email used for msdb.dbo.sp_notify_operator?

  Hi, folks, I've inherited a couple of 2016 SQL servers, and they both have maintenance plans on the…

  Rich Mechaber

  1 replies

  1 years, 8 months ago

  By: Rich Mechaber

• system_health configuration

  I'm on SQL Server 2016 (SP2-CU11-GDR) (KB4535706) - 13.0.5622.0 (X64) Dec 15 2019 08:03:11 Copyrigh…

  Sailor

  6 replies

  1 years, 8 months ago

  By: Sailor

• Local admin cannot view/launch failover cluster manager

  hi all. I am new to this and hope someone can help me. We have created a failover cluster for our S…

  lhooipg

  3 replies

  1 years, 8 months ago

  By: cyrusbaratt

• Migrate MS SQL Cluster to a New SAN

  Hi, As the title states, I am in the process of moving my sql cluster from an older SAN to a new on…

  dg

  2 replies

  1 years, 9 months ago

  By: dg

• HELP - AG Disk on one replica 90% full.

  Hi! I have not worked with AG groups very much, and I have a disk containing all my .mdf files on m…

  KTLO_DBA

  4 replies

  1 years, 9 months ago

  By: Jeffrey Williams

• SQL DB 2 TB

  I have a SQL database of 2 TB running on production. There is a need to refresh this database on Q …

  SQL_Surfer

  7 replies

  1 years, 9 months ago

  By: Jeff Moden

• Long running open temp_db transaction.Age in seconds = 3456 secs

  Version : Microsoft SQL Server 2016 (SP2-CU17-GDR) (KB5014351) -  Microsoft Corporation Enterprise …

  mtz676

  7 replies

  1 years, 9 months ago

  By: Johan Bijnens

• vulnerability CVE-2004-2761 on SQL server.

  Hi We have got few point of action for vulnerability CVE-2004-2761(SSL Certificate Signed Using Wea…

  prsnn_shetty

  6 replies

  1 years, 9 months ago

  By: Ant-Green

• Import sql objects definiton into individual file

  Hi, I'm trying to put the initial object definition into Azure Devops. My sql servers are on prem 2…

  SQL_Surfer

  2 replies

  1 years, 9 months ago

  By: Ant-Green

• install sp3+

  I have a SQL Server on version 13.0.5622.0 and need to get it up to date security patch wise. It ap…

  Sailor

  1 replies

  1 years, 9 months ago

  By: Ant-Green

• List Procedure That Creates A Table

  I've been trying to develop a process that will take the input of a table name and trace that back …

  RonMexico

  9 replies

  1 years, 10 months ago

  By: Michael L John

• How to write a script that kills a process if it's blocking over 1 minute

  Please enlighten me on how to write a script that kills an event if it's blocking another process o…

  koln

  2 replies

  1 years, 10 months ago

  By: Jeff Moden

• SQLPS (and SQL Agent PowerShell steps) don't work after Windows upgrade to 2019

  We were running SQL2016 on Windows 2012R2 without issues. We've just had an OS upgrade to Windows 2…

  Pete Bishop

  8 replies

  1 years, 10 months ago

  By: sam bryant