because the product was not developed for a 64 bit environment

is this a production environment?

if so I would not risk running 2000 on 64 bit operating systems, I would leave it 32bit always.

I was just saying it could be done,...

I know Spotlight on SQL Server Enterprise from Quest has a "configuration" tab, but you have to look at it at sever level you cannot compare side by side (unless...

river1 (11/15/2011)

---

So, you are saying that i can install SQL Server 2000 (with sp4) on an windows 2k8 64 bits but, because SQL Server 2000 exists only in 32 bits...

you can install 2000 on 2008 x64, but as 2000 is 32bit only it uses WoW, need to ensure your running a minimum of SP4 for 2000

I only found this...

good question, but in my morning daze i forgot to click @qoda is created, doh, epic fail on my part

do you have any group policies which applied once the server was in the domain?

it seems like for some reason the accounts are no longer part of the admin group...

I would of said that if the account in SQL is set as disabled then even if you do boot into safemode that it wouldnt make much of a difference...

Dev (11/14/2011)

---

If you have disabled the built-in Administrator account, booting into

Safe Mode will automatically enable it again (temporarily, for that

Safe Mode session).

Disclaimer: NOT TESTED. Post...

when you installed sql and got to the authentication mode page, what account did you add, was it your own windows account or was it the administrators account or a...

answered my own point

you cannot impersonate NT AUTHORITY

http://msdn.microsoft.com/en-us/library/ms181362.aspx

name must be a singleton account, and cannot be a group, role, certificate, key, or built-in account, such as NT AUTHORITY\LocalService, NT AUTHORITY\NetworkService,...

from my understanding you CANNOT login as the SYSTEM account as this is the computer itself and you cannot login as a computer

you could try impersonation but I am not...

is the windows cluster service started, without that you dont have a cluster and no cluster resources will start

Thanks Gail

I will remove the recompile from the proc, thats another thing I have learned today.

Think that has come from the company not having a DBA until two months ago when I started and myself for not completly understanding dynamic sql and execution plans, I...