Thanks for the question, I learned something. (However I hope I don't have to deal with multiple collations very often.)

One last question, which version of SQL Server 2008 were you trying to install?

Have you slip-streamed SP1, SP2 and/or any CUs into your installation source? (I know Microsoft has fixed...

John Roy Ellis (3/22/2011)

---

Look. My point is that others have run into the same issue that the guy at the beginning of the post ran into. As I...

As I read it that post is only about cleaning up the failed install so you can try again, nothing about identifying the reason the install failed in the first...

Thanks for looking at this. I would vote for all of the forums to be viewable by anonymous users either by web browser or RSS reader.

John Roy Ellis (3/22/2011)

---

Apparently, you can't do an in-place upgrade, a side-by-side upgrade, or even a new install of SQL 2008 on a box that already has SQL 2005 on...

There has to be more in the log files that state what went wrong, you have to find and correct that before doing anything else. At what point in the...

I don't understand what you are trying to do, can you maybe take one or two of the rows of the results you want and walk us through how you...

Have you by chance renamed or deleted the SA account?

Have you looked in the setup logs yet to see why it failed?

As an FYI I recently did a SQL Server 2005 to SQL Server 2008 R2 upgrade in place...

Are...

WasimAli (3/22/2011)

---

Keeping in mind the possibility that the user may be setup differently in DEV, i gave the user 'sa' access (as it is DEV env.) but that didn't help...

Bradley Deem (3/22/2011)

---

UMG Developer (3/21/2011)

---

Interesting question, thanks, and a good reason you should always specify the data type for hardcoded items in the first set of values or in the...

Then how do you define MAX?

You could always pad the values with 0:

select max(RIGHT('000000000000000' + ID, 15)) from phys

That may get you closer to what you are looking for. (Of...

Steve,

I think it is related to being logged in. If I am not logged in to SSC then I can only see a subset of the forums when I click...