No Immediate solution found as yet, the overall conclusion is that intergration services needs to be installed and then unistalled on the server where the problem exsists, so that...

The Version is Sql Server 2005 With sp2 installed. It is a clustered environment. The XML code used to process the cube works find when executed manually from...

The Bosox Have Reloaded And Our Lips Yearn For the Taste of Champagne That We Tasted Two Years Ago. I Think We Will Quench Our Thirst Again This October. V-8...

So in your estimation what are the top 5 transaction log third party applications or tools on the market to assist dbas with all transaction log tasks and error verificationd.  I...

Thanks For Your Help Guys. But I have a problem, the solution of using the update statement which included the case statement has been running for almost 20 hrs with...

A sample of the data would be like this:

Create Table Tracking

SSN Varchar(9),

HBMID_CODE Char(1),

Transaction_Change Char(1),

ENTRY_DATE Datetime,

TERM_DATE Datetime

TIMESTAMP DATETIME

first Transaction

Insert into Tracking

Values('123-34-5678','P','',# 10/01/2003 #,# 10/10/2003 #,TIMESTAMP)

Second Transaction

Insert into Tracking

Values('123-34-5678','R','',# 10/25/2003 #,# 10/29/2003...