GilaMonster (7/2/2009)

---

He's got two different servers. The first one (running SQL 2008 x64) apparently is the Vista box, however Enterprise edition isn't supposed to run on Vista.

Microsoft SQL Server 2008...

I link to an article in my signature that will show you how to post your question and get better answers faster. Please do yourself a favor and review...

MichaelJasson (7/2/2009)

---

Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2...

GilaMonster (7/1/2009)

---

Yes...

Yes, exactly - once you restore or attach a 2000 database to a 2005 instance, that database is converted to 2005. You cannot then later backup/restore that database to...

Lynn Pettis (7/1/2009)

---

Yes, you can leave it in compatibility mode 80, but once the database is attached to SQL Server 2005, you won't be able to take it back to...

I don't think this...

In addition to what Gail has stated, the default for new databases in 2005 is CHECKSUM.

You really need to verify that you can modify SQL Server and still be within your license. I do not believe that you can 'throttle' SQL Server in the...

Gianluca Sartori (6/30/2009)

---

This is one of the reasons why clustering for SQL Server is a useful feature, but not as useful as one would expect, at least one who has...

You are welcome.

When you take a resource group in a cluster offline, all resources in that group are taken offline also. They are not failed over, which means the services are...

I wouldn't think you would want to do that on Vista. If you are running on x86 hardware, then the maximum memory you are going to be able to...

If you are installing on Vista or Server 2008 - you will get a warning message that this program has known compatibility issues. You will be given the option...

Correct - the latest service pack for SQL Server. The RTM version of SQL Server 2005 is not compatible with Windows Vista or Windows Server 2008. You will...