Viewing 15 posts - 436 through 450 (of 468 total)
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...
September 10, 2008 at 7:12 pm
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...
September 10, 2008 at 7:08 pm
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...
September 7, 2008 at 1:47 pm
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...
September 7, 2008 at 1:35 pm
The settings I have for the MSDTC are as follows:
Network DTC Access
Allow Remote Clients
Allow Remote Admin
Allow Inbound ...
September 7, 2008 at 11:56 am
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...
September 7, 2008 at 11:54 am
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...
September 7, 2008 at 11:18 am
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...
September 5, 2008 at 10:39 pm
If not the exact solution, I would appreciate any views on it..Thanks!!!
September 5, 2008 at 11:18 am
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...
September 5, 2008 at 11:17 am
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....
September 4, 2008 at 6:54 pm
Advanced editor changes are not saved.Instead I tried doing the source as unicode but there was no output data, just the column names...
September 4, 2008 at 6:03 pm
Do you hold admin rights on this domain? If not try doing that...
August 30, 2008 at 7:57 am
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.
August 28, 2008 at 6:51 pm
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...
August 23, 2008 at 9:32 am
Viewing 15 posts - 436 through 450 (of 468 total)