Hello,



I'm trying to programmically update/erase properties in a MSOLAP/MS
SQL Server 2000 sp3 using MDX. Updating text fields works with the
code below, but the fields with DateTime and SmallDateTime do not
accept the format returned by a Calendar object under C#. I use the
following example to writeback the property to my cube but it doesn't
work, I get the error message: 'One or more errors occurred during
processing of command'



ALTER CUBE [Cube_Attributes] UPDATE DIMENSION MEMBER
[Attributes_Dim].[All Attributes_Dim].[Westphal], [Datetime Type] = '1998-05-
02 01:23:56.123'



* Where [Datetime Type] is of DateTime type.



My question is: in which format must the date time string be in order to
be accepted by the MS Sql Server?



Any help would be greatly appreciated,



rohuezo


--
Posted via http://dbforums.com