Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• sql agent issue

  getting this error. could not find the procedure msdb.dbo.sp_get_sqlagent_properties and also this …

  mtz676

  14 replies

  2 weeks, 6 days ago

  By: Tav29

• sqlagent issue

  could not find the procedure msdb.dbo.sp_get_sqlagent_properties agent not visible   T…

  mtz676

  1 replies

  3 weeks ago

  By: Ant-Green

• 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

  1 month, 3 weeks 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

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

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

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

  4 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, 4 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

  7 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

  8 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

  8 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

  8 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

  9 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

  9 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

  11 months, 2 weeks ago

  By: Jeff Moden