Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• OraOLEDB.Oracle Error - Inconsistent MetaData

  Last week, we moved a database from one test server to a new test server. We're now receiving this …

  david.holley

  2 replies

  7 years, 12 months ago

  By: stevemuller

• Change Data Capture for a Specific User Only

  Morning Guys, I wish to enable change data capture for a handful of tables, though I only want to a…

  alex.sqldba

  5 replies

  7 years, 12 months ago

  By: Jeff Moden

• Mirroring setup with asynchronous mode

  Hello, Was trying to setup DB mirroring w asynchronous mode (sql server 2014 std edition sp2) but i…

  SQL_Hunt

  2 replies

  7 years, 12 months ago

  By: andreas.kreuzberg

• Linked servers on an instance all pointing to the local instance.

  We have around 4 linked servers on an instance, each one of them pointing to a remote instance. The…

  jcourtjrSQL

  12 replies

  7 years, 12 months ago

  By: Sue_H

• Script to make 2 databases consistent

  Hi Experts, Need some help here. Problem Description : Looking for different ways to make 2 databa…

  vsamantha35

  1 replies

  7 years, 12 months ago

  By: Sue_H

• Encrypted connections to the database

  Hello, As part of the requirements for holding identifiable patient data on our network, we have be…

  M Joomun

  3 replies

  7 years, 12 months ago

  By: M Joomun

• The transaction log for database 'database_name' is full due to 'XTP_CHECKPOINT'

  Hi Gurus,  I'm new to SQL Server. We got an issue on our Production Server at this moment and …

  fedora132010

  13 replies

  7 years, 12 months ago

  By: fedora132010

• index maintenance on AlwaysOn

  Is this good solution for index maintenance on 'always-on' where not all databases are primary , or…

  goher2000

  2 replies

  8 years ago

  By: goher2000

• Db design advice

  Hi All, This question is related to database design approach and this needs some system background…

  vsamantha35

  3 replies

  8 years ago

  By: Grant Fritchey

• SSIS Package Failure - Intermittent TCP / Login Error

  SSIS packages are being triggered throughout the day from the SQL Server Agent. We have an ongoing …

  mark.headley

  4 replies

  8 years ago

  By: mark.headley

• The log for database 'msdb' is not available. Check the event log for related error messages. Resolve any errors and restart the database.

  We are observing the event 9001: The log for database msdb is not available. Check the event l…

  ragupta 10363

  2 replies

  8 years ago

  By: Jeff Moden

• Read committed snapshot isolation level

  Hi All, Looking for  advice on READ COMMITTED SNAPSHOT isolation level.How to turn on read co…

  vsamantha35

  2 replies

  8 years ago

  By: Sreekanth B

• OpenRowSet - Arithmetic overflow error converting expression to data type int.

  Hi, just wonder why I recieve the following error message     Msg 8115, Level 16, St…

  gkramer 23701

  2 replies

  8 years ago

  By: gkramer 23701

• Performance Monitoring

  Hi All, Want to get an opinion on monitoring performance of multiple SQL Server instances on differ…

  d_oracle_dba

  2 replies

  8 years ago

  By: d_oracle_dba

• ALWAYS ON Secondary Database Unable to Join

  Hi All,Im trying to join a secondary database to ALWAYS on AG but its getting failure with message …

  narayanamoorthy.a

  6 replies

  8 years ago

  By: Rick-153145