arty 15255 (1/28/2011)

---

I had the same issue.

After some investigation I found that some temp tables (CREATE TABLE #...) are not dropped in some of my procedures.

After adding precisely everywhere...

All of them... always unless you have a specific reason not too like the 1 I mentionned earlier.

SP4 is available for SQL 2005 at this moment.

Makes no difference. You should always apply the latests patches to a new install. The only exception being on a dev machine where you need to match a...

Cool, make sure you reapply the SPs so that you are everything at the same level and avoid weird bugs (rare but it happens).

Have you tried uninstall / reinstall the tools with the ss install file?

What do you mean can't find SSAS?

You need to create a new project, then in the bi category SSAS should be the 1st option.

Hey dude here's the path to rebuild your link!!!!

"C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\devenv.exe"

If it's NOT there, then do a search for devenv.exe and you'll find it.

It's still not an error. That means that the products are already installed. So you just need to find them.

Here's where my shortcut points to for bids :...

Hey I just had a quick look at the query from the .sqlplan.

Here's another idea to see "where it all goes wrong".

I see you have a lot of subqueries. ...

Open the plan, right click on the final select in the plan. Then properties. You'll find that the optimizer stopped the optimisation because of a timeout.

That could explain...

Have you checked if you have some sort a late finishing bakckup or reindex job or anything trashing the disks at that time?

What she...

No because you HAVE TO remake the whole thing from scratch... no backup, no restore. Script everything, rebuild the whole structure and reimport the data manually.

What mistakes are you going to cover?

You can't use backups because they never were and never will be backward compatible. You need to script the whole db and objects. Then reimport the data.