Administering

• Topics

  Started by

  Posts

  Last post

• 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

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

  3 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 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, 1 month 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, 4 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, 6 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, 7 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, 9 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

  1 year, 10 months 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

  1 year, 10 months 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

  1 year, 12 months 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, 1 month 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, 2 months ago

  By: Jeff Moden

• Maintenance Plans Failing with "Failed to acquire connection "Local server connection""

  I had a massive outage a couple weeks ago on SQL 2005 x64 sp2 running on 64 bit Clustered SQL 2005 …

  Chris Mackin-166947

  10 replies

  2 years, 4 months ago

  By: FlorinManea

• Difference between inner join and cross join?

  Can anybody tell me the Difference between inner join and cross join. how and when we have to use t…

  Paresh Prajapati

  12 replies

  2 years, 11 months ago

  By: Jeff Moden