Hi,

I am using the data format as below.

DECLARE @table TABLE (number nvarchar(max))

INSERT INTO @table VALUES (4.5267489711934158E-2)

INSERT INTO @table VALUES (8.8356729975227088E-2)

INSERT INTO @table VALUES (9.9356025758969638E-2)

SELECT CONVERT(VARCHAR(4),CONVERT(INT,ROUND(CAST(number AS DECIMAL(4,2)), 0))) + '%'...

Reattached the exec plan.

got any resolution for this..i am also facing this issue from long time back pls suggest resolution.

Hi,

My concern here is to have when ever insert has done i need to insert that record to History table" also when updated i need to track old values and...

Thank you much for your comments here.

I will set the source server connection timed out to 0 and monitor for some more few days for good.Anyhow thanks for your help.

But...

Hi

Thanks for your valuable comments here.

Also have a look at the target and the originating server properties concerning "Remote server connection" have the remote query timeout set to 0...

yes web user is having an access to linked server as this SSAS is hosted on the same server.

If web user don't have access then it should failed always...

Hi All,

Today again my linked server drops out and thrown with an error:

Error: Cannot create an instance of OLE DB provider "MSOLAP" for linked server "Expense_Cube".

Post restart of SQL server...

Hi,

If that is the case it should't connect always sometime it will connect and work properly but for some other time it won't work what should be the cause for...

again i am getting the error

Msg 7399, Level 16, State 1, Line 2 The OLE DB provider "MSOLAP" for linked server "" reported an error. The provider did not...

Hi,

This error will not come always i have refreshed database and executed i ran successfully with out any issue.

What could be the reason for this ?

How do i check why...

Here is my part of the query:

CREATE PROCEDURE [dbo].[get_interaction_list_account] (

@account_id INT = 0,

@period INT = 0

)

AS BEGIN

...

Hi,

1.The example data which i have given for only one record you may be consider for multiple records similar to that only if you want.there is no issue with data.

2.Yes...

Hi Below are the values from sys.configuration

name |value | minimum | configuration_id |maximumvalue_in_use...

Hi Adi,

I used the same query and get the result and pasted in notepad and saved file as .xml,when i opened with the IE i could see <safetyreport> as child...