SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• Change name of a particular step in an existing SQL Agent Job

  What is the easiest way to change name of a particular step in an Agent Job? SSMS does not seem to …

  VoldemarG

  2 replies

  5 years ago

  By: @SQLNumpty

• How to upgrade to 2016 AlwaysON from SQL Server 2012 ?.

  Hello, I'm looking for the best way to go from existing 2012 Enterprise AlwaysON Cluster to SQL 201…

  alexsunny123

  1 replies

  5 years ago

  By: Jeffrey Williams

• Can I change my active transactional replication subscriber name to use HA

  Hello, I have transactional replication setup with several databases. The publisher and subscriber …

  C-M-A

  3 replies

  5 years ago

  By: Arner725

• Help with Actual execution Plan

  Please advise on the attached execution plan. If they open as XML then please rename them as .sqlpl…

  sizal0234

  3 replies

  5 years ago

  By: Johan Bijnens

• always on sql server

  Hi Guys, I have a question to configure always on sql server same subnet vs multi subnet. It is thr…

  Saran

  4 replies

  5 years ago

  By: Mike Good

• Updating SQL Server 2016

  We are currently running SQL Server version: Microsoft SQL Server 2016 (SP2-CU12) (KB4536648) - 13.…

  thunter 5669

  2 replies

  5 years ago

  By: Jo Pattyn

• Could not find a login matching... when access granted via AD group

  Hello experts, A client just reported the following puzzling error. There is a user ABC\user1 that …

  webrunner

  1 replies

  5 years ago

  By: webrunner

• Change reference

  I need to restore the database from one server to another with different name and need to add the d…

  ramyours2003

  6 replies

  5 years, 1 months ago

  By: ramyours2003

• Collation Error: 468 when trying to view login properties in SSMS

  Hello experts, I was recently confronted with a dev SQL Server that had been installed with the SQL…

  webrunner

  7 replies

  5 years, 1 months ago

  By: Solomon Rutzky

• how to capture login 'sa' begin used ot not

  Hi As per my subject line i would like to how  to capture whether login account 'sa' is begin used …

  anoop.mig29

  3 replies

  5 years, 1 months ago

  By: Jeff Moden

• extended events rpc_completed duration does not matching with rpc_starting

  Does rpc_completed duration (micro_sec) = rpc_starting.timestamp - rpc_completed.timestamp? In my c…

  jandrewan

  2 replies

  5 years, 1 months ago

  By: Grant Fritchey

• Firewall access for Availability Group listeners

  Hello experts, I have a noob question as I never feel like I understand enough about networking. Su…

  webrunner

  1 replies

  5 years, 1 months ago

  By: webrunner

• Database, RAM and processor Information

  Hi, I need to find the size of all db's and server's processor and RAM info etc. Please share if yo…

  sizal0234

  1 replies

  5 years, 1 months ago

  By: Eirikur Eiriksson

• Error

  can  any one help on ho wto solve the issue [Microsoft][ODBC SQL Server Driver][SQL Server]The conv…

  ramyours2003

  5 replies

  5 years, 1 months ago

  By: Lynn Pettis

• SQL Server Load

  Hi, The application team is pushing more than 7 lakhs records per day to SQL Server. The SQL Server…

  narayanamoorthy.a

  3 replies

  5 years, 1 months ago

  By: Sergiy