I would just apply 2005 SP4 as a part of the process then go to 2012.

This way you avoid any 'potential' licensing issues.

the "sc" command does work remotely on 'other' servers - it is just a permissions issue.

below is the first part of the command 'sc /?'

DESCRIPTION:

...

what ??? no test server ???

did I understand correctly that you want to do a production upgrade without testing it ?

this is about as simple as it can get ...

reorg wins over reindex for concurrency. reorg locks only 1-2 pages or 1-2 extents at a time as it executes as...

Our volume price is for SQL 2014 (down-gradablke to SQL 2012) with SA.

CPU cores are licensed in 2 packs.

You have 16 cores so you need 8 - 2 packs.

So your...

Let me guess ... the CU ran for longer than normal.

If this is the case look at the SQL errorlog and you will see a series of messages in...

So I assume the entire error is: Error: 18456, Severity: 14, State: 11

One other thing to check in AD is to see if the Domain Administrator group members are in...

Short of restoring from a known good backup you could try:

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

even though these steps are for SQL Server 2008 and are reallly meant for application databases...

I would avoid using the public group. Try the following instead:

use your_target_database

go

create role db_view_schema authorization [dbo]

grant view definition on schema::[dbo] to [db_view_schema]

go

exec sp_addrolemember @rolename='db_view_schema', membername='security_account'

go

Yes it is possible however I do not recommendd it.

The reasons for not are:

- SCCM downloads and schedule and executes the SP or CU, but the timing is not...

IMHO any PLE value smaller than 1,000, let alone 300, is a serious issue if it stays there and never increases. We try and maintain 10,000 or better on all...

One additional note when dumping to devices in v6.5.

You can specify a UNC (i.e. \\servrename\share\etc) when you create the dump device.

However unless your network is as fast as lightening it...

Google is your friend.

http://support.microsoft.com/kb/956032

SQL Mail on SQL 2000 - what a headache.

Before you engage your Exchange folks I would suggest the 2 following actions:

- reboot your server

- drop and recreate your...

Hyperthreading and its recommendation to turn it on or off has flip-flopped a number of times since the first Pentium Xeon chipset. We turn it off by default and have...