Viewing 15 posts - 16 through 30 (of 49 total)
Alex,
Upgrade to latest SP/CU did not fix the issue. The only work around was to stagger the schedule of SSIS package-jobs.
Prakash B
October 7, 2015 at 7:47 am
https://support.microsoft.com/en-us/kb/2699720
Alternate resolutions: For SQL severs with versions lower than SQL 2012 SP2 CU5, staggering the SSIS jobs to run at different schedules helps alleviate the problem.
Prakash B
October 6, 2015 at 1:10 pm
was this issue resolved?
Prakash B
February 17, 2015 at 11:52 am
I am seeing the same error on one of the prod SQL server. Gathered performance stats on disk attached to SAN. The numbers were not alarming (less than 20 ms)....
Prakash B
May 30, 2013 at 7:54 am
Sometimes the Recycle Bin of a partition/volume can become corrupted. When it does it prevents you from deleting files or takes up space that cannot be reclaimed by emptying the...
Prakash B
March 7, 2013 at 8:00 am
Sometimes the Recycle Bin of a partition/volume can become corrupted. When it does it prevents you from deleting files or takes up space that cannot be reclaimed by emptying the...
Prakash B
March 7, 2013 at 8:00 am
Hi chinn,
I am looking for a similar solution that you were looking for. Could you let me know how you were able to accomplish the automation of loading trace files...
Prakash B
January 7, 2013 at 8:34 am
Use below statement... it will work!
ALTER INDEX [IndexName] ON [Schema].[Tablename] REBUILD WITH (ONLINE = ON);
It will also work for Indexes with pages less than 10.
Prakash B
July 12, 2011 at 4:04 pm
HOW TO BUILD TRANSACTIONAL REPLICATION FROM SQL2005 TO DB2
One time tasks per subsystem on the host (DB2)
Use a properly installed Data Access Tool.
We installed Host Integration Services (trial) on Andy's...
Prakash B
March 21, 2011 at 11:05 am
Not sure if your environment is same as ours.
Our DB2 databases reside on shared environments. Also, we are having 64 bit operating system + 64 bit SQL Server Enterprise Edition...
Prakash B
March 18, 2011 at 9:28 am
Hello All,
We have a three node Active-Active-Passive cluster. (Windows 2003 Enterprise x64 Edition and SQL 2005 EE 64 Bit)
MSDTC has been configured as a separate group in cluster admin with...
Prakash B
October 5, 2010 at 2:52 pm
I found out the answer for the above issues. Thought will share it here:
Other than updating the subscriber password on the subscription properties window in SQL Server, password had to...
Prakash B
April 1, 2010 at 3:45 pm
Easy way to give users/developers view permission to Stored Procedures in SQL 2005:
USE AdventureWorks
GO
CREATE PROCEDURE usp_ExecGrantViewDefinition
(@login VARCHAR(30))
AS
/*
Included Object Types are: ...
Prakash B
January 21, 2010 at 10:04 am
Please take a look at the possible workaronds:
1) Create a SQL login with dbo rights to the database where tables and other objects have to be created. Have the users...
Prakash B
September 3, 2009 at 9:14 am
Hello All,
I getting the same error.
"Error: 14151, Severity: 18, State: 1."
with
" TCPIP socket error has occured (10054): An existing connection was forcibly closed by the remote host. SQLSTATE:...
Prakash B
October 16, 2008 at 9:40 am
Viewing 15 posts - 16 through 30 (of 49 total)