Great article Craig,

It was really put well, I now know where to focus more as a developer now and how to steer myself to the next level. I just got...

Guys,

Thanks for the help, Both of your techniques worked. I really appreciate it.

regards,

Bala

Hello,

I ran into the same problem, by mistake copied all the tables of Adventureworks database into the master db, I also tried to run this query but was not in...

You are right. try to run the sp2 upgrade. This post answers your question.

update.

Best,

Bala

Then, there shouldn't be any changes to the code. Those post of mine are only for SQL Server 2008 I don't have SQL Server 2005 to test the code. Sorry...

OK, I am not sure about your error, but assuming that this might be error you are getting..

Msg 207, Level 16, State 1, Procedure usp_Main_GetCPUHistory, Line 6

Invalid column name 'cpu_ticks_in_ms'.

Msg...

Matt,

I had the same error too, after spending few mins in Google I found this article which solved the issue. Hope this helps.

http://sqlblogcasts.com/blogs/neilhambly/archive/2010/08/27/sql-2005-reports-using-the-dmv-dm-os-sys-info-tweaks-for-2008.aspx

Let me know if this solved...