SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• Different app behavior when connecting to 2 different SQL Server

  I am troubleshooting one issue and I am wondering if someone can help me. Maybe guide me where and …

  LearningDBA

  1 replies

  1 year, 3 months ago

  By: Mr. Brian Gale

• BCP with ODBC 18?

  Hello all.  My org has identified ODBC driver version 17 as having security vulnerabilities.  It …

  patricio2626

  2 replies

  1 year, 4 months ago

  By: Johan Bijnens

• WSFC - DR question.

  I'm trying to write a DR doc with no test system for someone with no experience of SQL / clustering…

  jessymcjessface

  4 replies

  1 year, 4 months ago

  By: EdVassie

• SQL 2016 Patches and CUs marked "duplicate (do not use)

  What's the story with a lot of SQL 2016 patches being marked "duplicate (do not use)"? It's not jus…

  Leo.Miller

  1 replies

  1 year, 5 months ago

  By: Leo.Miller

• Error while configuring replication on top of AG in SQL server 2016

  All Pub dist and Sub servers are in AG with Sql server 2016 SP3 version and while configuring repli…

  prem.m38

  3 replies

  1 year, 5 months ago

  By: CreateIndexNonclustered

• Suppress Backup Messages In Logs

  I'm trying to get rid of all backup messages in my SQL logs and I was able to successfully suppress…

  RonMexico

  8 replies

  1 year, 5 months ago

  By: Tuan Nguyen

• Continuous lock timeout when trying to exec sp_configure

  Hello experts, I'm seeing a strange issue. Yesterday I noticed that I was getting this error when I…

  webrunner

  4 replies

  1 year, 5 months ago

  By: cyrusbaratt

• Need to read ErrorLog to get the END TIME of last restore?

  is there a stored proc somewhere for sql server 2016 that can return latest restore database durati…

  VoldemarG

  7 replies

  1 year, 5 months ago

  By: VoldemarG

• Date when User was added to server-level role

  How to get (if possible) date when Login was added to any server-level role? Like temporarily- to s…

  Yuri55

  5 replies

  1 year, 6 months ago

  By: Yuri55

• SQL Mirroring with Witness - Workgroup joined computers

  Hi, I am trying to configure mirroring an some old 2016 SQL servers for a client. The PCs have full…

  jszatkowski3

  1 replies

  1 year, 6 months ago

  By: jszatkowski3

• Database copy issue through - COPY DB WIZARD

  I have a production server with SQL server 2016 version (13.0.5026.0) and a database with 25 GB of …

  Kaushik Parui

  10 replies

  1 year, 6 months ago

  By: Andy sql

• System versioned tables permissions

  I have an issue with these permissions which I don't understand. When I add a user to a database co…

  as_1234

  9 replies

  1 year, 6 months ago

  By: as_1234

• Always encryption error

  Hi All, Seeking out help on SQL 2016 Alwayson feature. One of the tables in Always encrypted. When…

  vsamantha35

  4 replies

  1 year, 7 months ago

  By: SQlLogic

• Failed to initialize the Common Language Runtime (CLR) v4.0.30319 with HRESULT 0

  Hi All Hope you can help me with this one as we are pulling our hair out. So a few weeks back we en…

  craigashields

  2 replies

  1 year, 7 months ago

  By: Sparky

• How to view actual execution plan, for long running jobs?

  I have a couple of very long running jobs which are scheduled by SQL Agent. These jobs are doing ar…

  JasonO

  2 replies

  1 year, 7 months ago

  By: Grant Fritchey