Thank you

but i need these translations.

i delete KPIs http://support.microsoft.com/kb/929766/en-us but it doesnt help.

i also check http://social.msdn.microsoft.com/Forums/en/sqlanalysisservices/thread/cea085fe-0d93-4fc5-99b9-6221d64a89cd

and i already installed SP1

thank you again

Hi

Did you find any soluition for that?

Yes that is the question!

SQL server can catch the lots of values like HOSTNAME even if logins with SA.

(SA is just an example.

Ofcourse they have their own SQL...

Thanks but

thats the reason that i need WindowsNt\LoginName, i am also using DDL trigger.

INSERT INTO dbo.tbDropTableLog(EventTime,EventType,ServerName,DatabaseName,ObjectType,ObjectName,LoginName,UserName,HostName,CommandText)

SELECT

REPLACE(CONVERT(VARCHAR(50), @xmlEventData.query('data(/EVENT_INSTANCE/PostTime)')),

'T', ' '),

CONVERT(VARCHAR(15), @xmlEventData.query('data(/EVENT_INSTANCE/EventType)')),

CONVERT(VARCHAR(25), @xmlEventData.query('data(/EVENT_INSTANCE/ServerName)')),

CONVERT(VARCHAR(25), @xmlEventData.query('data(/EVENT_INSTANCE/DatabaseName)')),

CONVERT(VARCHAR(25), @xmlEventData.query('data(/EVENT_INSTANCE/ObjectType)')),

CONVERT(VARCHAR(40), @xmlEventData.query('data(/EVENT_INSTANCE/ObjectName)')),

CONVERT(VARCHAR(100),@xmlEventData.query('data(/EVENT_INSTANCE/LoginName)')),

CONVERT(VARCHAR(30), @xmlEventData.query('data(/EVENT_INSTANCE/UserName)')),

CONVERT(VARCHAR(50), (select hostname from sys.sysprocesses...

No way.

i cannot change the programs connection string.

thanks anyway.

any solutions?

Thanks for nice article.

Also function which returns the Weeks is more usefull for retail programs and like-for-like discussions.

As you now sql server's DATEPART weeknumber function does not return the real...

What happens if there is a ForeignKey which refers this column in another table.

Will there be any problem?

i found  the solution from ranjithain

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=18865

Thanks to all

if you just want to query the cube.

You can use

SqlServer->Analysis Services->MDX Sample application

for your test queries.

Thanks

i will try