A kind of librarian, working with pages, Indexes & databases ... transforming data in knowledge.

Practically all the questions are answered using a query analyzer and/or a google search, but this isn't the way to answer them ... we aren't at school 😛

declare @timems numeric

select @timems =(cast(datediff (dd,getdate()-28,getdate()) as numeric)* 86400000)

select @timems

--86400000 msxday

Thanks Markus,

An interesting link for explaining the issue. curiously ... The article titled "Use Cube Writeback" and not "Use Partition Writeback" 😉

Hi Hajm

I agree with you, writeback option apply in the partition scope. In any case I was referring to OLAP data and maybe I mixed both concepts without want. :Whistling:

Hello Hugo

The explanation is valid also for AS2005 because I suppose it's a logical question (In any case I can understand the writeback miss for funtions as distinct count, but...

Hello

The problem is the conversion of the xml type to text type. A fast solution way is to increase varchar fields in ddlauditlog and include SET ANSI_PADDING in the trigger.

This...