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.

As stated earlier... the most likely problem is the data cache. Unless having a 2000 lines proc with only 1-2 queries inside, the plan generation time will be futile...

Craig Farrell (1/21/2011)

---

Brandie Tarvin (1/21/2011)

---

Hey, Craig, even us non-employer types are learning a lot from this discourse. I've learned a lot about job descriptions just by reading your responses (and...

SSMS

open your server with windows account

security

logins

double-click on sa

general

type in the new password, confirm and hit ok