We had same issue on a sql 2008 Sp1 box.

The Analysis Service was pointing to folder "d:\program files\microsoft sql server\msas10.mssqlserver\olap\config" for the msmdsrv.ini file. However the config folder was at...

Nice to see comments after long three years..:)

Oh finaly its done..

changed regional setting to US (english) and went to custom setting and opted for SQL collation 1252..;)

Thanks you all for ur valuable comments..

binu john

Thaks..But any ways I can change the SQL Server 2000 collation to SQL_Latin1_General_CP1_CI_AS(which is default to SQL7)..I have tried to re install and opted for custom setting--collation--sql collation..still No luck;)

How...

Just try this also

SELECT

'EXEC sp_change_users_login ''Update_One'', ''' + su.name + ''', ''' + su.name + ''''

FROM

sysusers su

LEFT JOIN master.dbo.syslogins sl ON su.sid = sl.sid

WHERE

uid > 3-- exclude public, dbo, guest,...

Generate Script?:cool:

Do you give computerName\userName or DomainName\userName?

Just a workaround..just activate your builtin administrator..let us see how it works.

binu john

Probably this would be appending the backup to same file.:D

binu john

That is it Matt.

If we can maintain an index with proper fill factor and reorgs, identity or non identity coulmn wudnt be a performance bottleneck...;)

But I dont think I can't...

Jeff can you please tell me If I creates a Clustered index on a Primary (Not a indentity) column on table that has good amount of writes how it...

Hi rudy

Can you please tell me how this effect performance..

--------Got clustered primary keys on big transactional tables?

binu john

Thanks Arun..that too doesnt suit to my requirement.:hehe:

I have a script which does dbcc index defrag and if required reindexing but can do for one database and need to run...

Lovely

Thanks Arun..

The given script does a index defrag, but my requirement is slightly different. :hehe:

If the fragmentation level is low (eg ~30) then opt for index defrag or if...

Thanks Lowell..

It doesn’t help me either.:w00t:

This script reindexes all user and system indexes in the database using the original fill factor allocated to that index.

I am looking for something...