Administering

• Topics

  Started by

  Posts

  Last post

• Step fails, but job reports success.

  I have a job that has multiple steps. Each step is set to 'Go to next step' on success or failure,…

  Erin.

  5 replies

  1 day, 13 hours ago

  By: kdslate

• SQL performance counter shows 0 as values

  Environment: sql server 2005 enterprise edition on windows server 2003. Perfmon counters fro sql wa…

  SQLshifu

  10 replies

  1 month, 1 week ago

  By: david.gugg

• SQL Profiler

  Hello I am trying to run sql profiler on a remote server, but I keep getting error messages relatin…

  b_boy

  8 replies

  3 months, 2 weeks ago

  By: mikeandanne

• Speed up a database shrink

  Dear Friend Master SQL Guru, 😀 Ok - before you flame me, I have a legitimate (I think) reason to…

  Chad Crawford

  36 replies

  5 months ago

  By: jelongpark

• Agent message code 20084. The process could not connect to Distributor

  Hi I am getting the following error message while running a transactional replication: Agent messag…

  jeet_personal

  6 replies

  1 year, 2 months ago

  By: dave-e-hill

• How I can know last maintenance job date and status(Success or Failed) by Sql Server Management Object

  Hi, How I can get the last maintenance action information for a database instance programmaticall b…

  compass_ms

  8 replies

  1 year, 3 months ago

  By: dollygill

• WMI CREATE QUEUE permission denied

  I'm attempting to setup a WMI based mirroring alert, but I get an error when I attempt to set it up…

  Jon.Morisi

  1 replies

  1 year, 6 months ago

  By: apollino

• Log Shipping Error

  Hi all, I am trying to configure remote log shipping and getting following error. I have checked ev…

  apat

  32 replies

  1 year, 8 months ago

  By: mmustafa8@gmail.com

• Reindexing and huge T log backup file

  How do you manage reindexing on large databases where there is log shipping? We're doing in…

  Indianrock

  7 replies

  1 year, 9 months ago

  By: willspurgeon

• ISO TSQL to Delete User IF EXISTS from DB only (not SQL Login)

  In Search Of... T-SQL to DELETE a User from a database ONLY IF the User Exists. I do NOT want to …

  Express12

  5 replies

  1 year, 11 months ago

  By: AnthonyNilsson

• How to check the value of database property TRUSTWORTHY?

  Didn't figour out how to check the value of database property TRUSTWORTHY ? Anyone could light me…

  awu

  6 replies

  2 years ago

  By: Jeff Moden

• How to use store procedure sp_send_dbmail to send out a SECURE e-mail?

  How to use store procedure sp_send_dbmail to send out a SECURE e-mail? Mary Ming Wang

  mary.wang

  7 replies

  2 years ago

  By: jy9230

• sysJobActivity showing jobs from years ago that never ended

  I've noticed that sysJobActivity shows a number of jobs where the stop_execution_date is NULL, but …

  RossRoss

  32 replies

  2 years, 1 month ago

  By: sqlsamwise

• Linked Server

  I am having error on my linked server. from x to y. OLE DB provider "SQLNCLI" for linked server "x…

  binu.m a

  24 replies

  2 years, 3 months ago

  By: mtrudel337

• Remove a Filegroup

  I want to remove a filegroup like this: "ALTER DATABASE MyDBName REMOVE FILEGROUP MyFileGroupName" …

  Sunny Liu

  25 replies

  2 years, 4 months ago

  By: Jeff Moden