I didnt knew Microsoft came out with Litespeed...

Litespeed is used for backups and has advantages as it is fast and the backups are compresses to 25% of the original file...

As a DBA you may have jobs setup to maintain DB's but the hardware cannot be ignored. In the event of a hardware failure Clustering comes to the rescue. Also...

This is a bizarre situation..I hope NONE of the DBA's end up in this situation. I remember when I was new my seniors asked me to take a backup no...

Create a SP to and schedule it as a job, I use this and works very fast..

CREATE PROCEDURE dbo.usp_DriveStats

@drive char(1) = null,

@ShowOutput int = 1,

@TotalBytes bigint = null OUTPUT ,

@FreeBytes...

The settings I have for the MSDTC are as follows:

Network DTC Access

Allow Remote Clients

Allow Remote Admin

Allow Inbound ...

00008604: Error Message:The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction

This is the error I get when I run the...

Stopping and Restarting would be your best bet to mitigate this issue. Right click on my computer and go to Manage, check for the application logs maybe on of the...

I tried doing a select from the remote database and it actually works.But when I do an update referencing the linked server it says 'MS OLEDB unable to start Distributed...

If not the exact solution, I would appreciate any views on it..Thanks!!!

I have the same issue with an application that uses the JDBC driver to do an update on a database 2 by comparing two databases 1 & 2. Now, I...

Yes they do exist. As you mentioned you are at build 2040 but there is a latest build version 2187 that has all the Post SP4 hoftixes regressed into it....

Advanced editor changes are not saved.Instead I tried doing the source as unicode but there was no output data, just the column names...

Do you hold admin rights on this domain? If not try doing that...

Import export wizard will not serve my purpose of mailing the excel spreadsheet on a sceduled basis that too when I have a script that does the select for me.

Well, the base idea of monitoring is very good but has to be implemented effectively. To begin with identify the core areas that need to be monitored on a daily...