Nice script, although I prefer Perfmon logging CPU usage over periods of time to get averages, highs, lows.

If you read the documentation on the link I sent, you will see the upgrade procedure and possible issues you might encounter, and how to avoid them.

I dont want to...

Please don't cross post.

al replies here: http://www.sqlservercentral.com/Forums/Topic1275562-1633-1.aspx

I am not a licensing...

Yes it does.

1. Yes

2. Yes - Links below on help

http://technet.microsoft.com/en-us/library/ms143724.aspx

http://technet.microsoft.com/en-us/library/ms143747(v=sql.105).aspx

http://www.sqlservercentral.com/Forums/Topic708977-147-2.aspx#bm1173228

Not happy that it worked, that was the worst advise I've ever given.

But, I have had to use it on non-production systems once or twice as well.

Never, ever, ever, use...

Quick, dirty and ugly way (if you are desperate).

Stop SQL Service, drop the mdf and ldf files manually.

Start SQL, note the corrupt DB, right click delete.

OR:

sp_who2

Check who/what is connected to...

Already tried different media for RTM...no difference.

I'm also surprised that RC0 works, but RTM fails on same setup......

Not sure if it's worth sending to MS ?

Update:

RC0 installed without any issues. RTM still failing.

Now I'm confused :hehe:

Do you understand Data Warehousing concepts?

Does the Kimball Methodology ring a bell?

What's the difference between MDX/DMX/DAX?

Differences between MOLAP/ROLAP

How do you schedule an automatic cube processing task?

Can you define time...

Sqlchicken (3/27/2012)

---

We're you trying to install Analysis Services? There was nasty bug in CTP releases around choosing to install AS and it crashing install when trying select default admins. Wonder...

And the excel ?

Which platforms are your SQL and Excel, 32 or 64 bit or mixture?

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\test\test.xls;',

'SELECT FirstName, LastName FROM [Sheet1$]')

SELECT FirstName,LastName FROM Users

GO

Your reference to 'Excel 8.0' indicates Excel 1997, not 2007, which is 12.