I appreciate your diligence...in the mean time I am trying to understand the Architecture of SSAS 2000/2005.

I am also facing one more problem while migrating my OLAP 2000 DB to...

Any resolution so far...I am also trying to migrate a SSAS 2000 DB to 2005 and I am getting the same error...

I am sorry but I can't share the backup file...

Hello manishankar_83

My first question

Why it is required that the services should be running on the server mentioned in the error message as that was the server from where the backup...

And Moreover its Microsoft sales strategy not to designed any product which can run any operating system other than Windows.

They want to promote windows in the race of operating systems.

The solution seems to be okay for beginner levels or if doing for KB purposes. But I do not see it as an Enterprise level solutions but I rather go...

Hi,

There are some DTS class ommited from SSIS. you can take ref from below:

Incase you are a SQL Administrator it will be better to choose one of your .NET...

Krishna (3/26/2009)

---

koteswara kishore K. (3/26/2009)

---

My table having indexes, normalization and all other statistics are good.

But we are facing a latency when we are using this table in joins....

Although, I believe the REPAIR_ALLOW_DATA_LOSS command itself take the database in the SINGLE USER mode..:-)

If I check a condition for ISNULL would it scan the table till it gets the value..right? and whereever it gets the value null it will update the value with...

Yes but in the above condition, once the first update finish the row will be released for other queries.

But if I mix "IS NULL" the update will go through a...

But I guess I it will have a significant row locks and that can impact other processes if we look on to the bigger picture for a highly busy OLTP...

I ws with the SQL Command only; where it was showing me the error.

Dunno, what to bet but I just dropped and re-create the same objects with exactly same configuration/colums/settings...

Gail seems to be right..I executed this query and it seems to involving only those whos plan is in the cache.

Thanks a lot !! I will just try and let you know..