Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Database refresh from Production DB to Test DB in Sql server 2014

  Hello,I would like to know the what's the best way i can do Database refresh from Production D…

  poratips

  28 replies

  3 weeks, 4 days ago

  By: Srinivas Merugu

• Lost relationships

  This seems kind of weird, and I've never even heard of it happening to anyone, but it happens to me…

  pdanes

  5 replies

  1 month ago

  By: Ahr Aitch

• Configuring SQL Replication using Remote Distributor: Create Publication Error

  Dear Team, I am currently on SQL server 2014 R2 and I have been trying to replicate my LIVE databas…

  seyiisq

  18 replies

  1 month, 1 week ago

  By: mellibo

• Getting below error

  An error occurred during recovery, preventing the database 'XXXXX' (28:0) from restarting. Diagnose…

  sangameshms

  8 replies

  1 month, 2 weeks ago

  By: Jeff Moden

• 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

  3 months, 3 weeks 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

  5 months 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

  6 months, 2 weeks 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

  7 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

  7 months, 2 weeks 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

  7 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

  8 months, 2 weeks 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

  8 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

  10 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

  11 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

  11 months, 1 week ago

  By: Jonathan AC Roberts