Viewing 15 posts - 436 through 450 (of 469 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...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
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...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
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...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
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 OUTPUT ,
@FreeBytes...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
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 ...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
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...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
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...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
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...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
September 5, 2008 at 10:39 pm
If not the exact solution, I would appreciate any views on it..Thanks!!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
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...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
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....
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
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...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
September 4, 2008 at 6:03 pm
Do you hold admin rights on this domain? If not try doing that...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
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.
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
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...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
August 23, 2008 at 9:32 am
Viewing 15 posts - 436 through 450 (of 469 total)