Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• SSIS package works in VS but failed in SSMS

  Please help and thanks. Package:Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occu…

  HL

  1 replies

  2 weeks, 5 days ago

  By: Phil Parkin

• Logging from application to SQL server 2014..Using ODBC driver 18 for SQL SERVER

  I'm using the below connection string using providing UserID and password on their respective text …

  SQL_Surfer

  1 replies

  1 month, 3 weeks ago

  By: SQL_Surfer

• The database principal has granted or denied permissions to catalog objects in the database and cannot be dropped

  Dear all, I get the following error message when trying to remove a login on SSISDB even though it …

  tt-615680

  15 replies

  3 months, 1 week ago

  By: tung858

• Event ID 19036 & 10016 from Application and System log at the same time

  The OLE DB initialization service failed to load. Reinstall Microsoft Data Access Components. If th…

  mtz676

  8 replies

  4 months ago

  By: mtz676

• SSAS Cube Processing fail with 'Communication Link Failure' error

  Hello, we have our cubes in Server A and SQL DB resides on Server B (we are on SQL 2014), from last…

  srinivas.akyana

  3 replies

  4 months, 1 week ago

  By: a.adames

• The process could not execute 'sp_repldone/sp_replcounters' on ''

  Gone through google for this error - But our scenario is due to power shutdown. and so replication …

  Meera

  1 replies

  4 months, 3 weeks ago

  By: Steve Jones - SSC Editor

• backup file name null in msdb..backupset table

  I'm transitioning from sql maintenance plan to scripts mainly so I can format the backup file name …

  Snargables

  7 replies

  5 months, 1 week ago

  By: Jeff Moden

• The process could not execute 'sp_replcmds' on 'ServerName\PUBLISHER' generated by the Log Reader

  I'm continuously getting the following errors: The process could not execute 'sp_replcmds' on 'Ser…

  Welsh Corgi

  5 replies

  5 months, 3 weeks ago

  By: Meera

• Add\Modify Index on Large Table.

  I have a very huge table (60GB) used for logging purpose(100 of records logged every second). Now t…

  Rechana Rajan

  12 replies

  7 months, 2 weeks ago

  By: Jeff Moden

• how to catch previous error message

  I have a small problem. I like to catch a detailed Error Message. If a command raise more then one …

  diba 20194

  8 replies

  8 months, 1 week ago

  By: John Trollope

• Query run from SQL agent, not returning same results as from query window

  I am running SQL2012 (don't ask...) and my collation is Latin1_General_CI_AS and my language code i…

  aaron.reese

  9 replies

  8 months, 1 week ago

  By: Jonathan AC Roberts

• Duplicated post, please delete

  I am running SQL2012 (don't ask...) and my collation is Latin1_General_CI_AS and my language code i…

  aaron.reese

  1 replies

  8 months, 1 week ago

  By: Phil Parkin

• Changing Encryption on database from triple des to aes

  We currently have a Windows 2016 server running Sql Server 2014 that uses triple des for field encr…

  northplatteriver

  5 replies

  8 months, 2 weeks ago

  By: Steve Jones - SSC Editor

• SQL server disk block size formatted as 4KB runs slow

  Hello All, One of my SQL server 2014 all the disk are formatted as 4KB. I see Microsoft recommends …

  Saran

  9 replies

  8 months, 3 weeks ago

  By: Ant-Green

• Replication Reinitialization from backup

  I have Reinitialization transactional replication of 950 GB database from backup. It is working fin…

  Saran

  2 replies

  8 months, 3 weeks ago

  By: Saran