What is a high Page Splits/sec? There is no simple answer, as it somewhat depends on your system's I/O subsystem. But if you are having disk I/O performance problems on...

Check the below mentioned link

http://ftp.anadolu.edu.tr/Service_Packs/Microsoft_SQL_2000_sp4/ReadmeSql2k64sp4.htm#_installing_on_a_failover_cluster

MJ

Did you run "Run DBCC CHECKTABLE on sysobjects" with all_errormsgs,no_infomsgs?

MJ

Its useful and safe if you test it in separate test environment before you attack production. Don't ever forget to take system and user databases backup prior to SP installation.

MJ

Once password is changed in AD just use SQL Server configuration manager and change the passwords there.

MJ

Check BOL for bcp(make use of queryout parameter).

MJ

Check Microsoft License Advisor

http://www.microsoft.com/licensing/mlahome.mspx

MJ

First:

DECLARE @account varchar(100)

EXECUTE master.dbo.xp_instance_regread

N'HKEY_LOCAL_MACHINE',

N'SYSTEM\CurrentControlSet\Services\MSSQLSERVER',

N'ObjectName',

@account OUTPUT,

N'no_output'

SELECT @account as SQLServer_ServiceAccount

Second:

declare @reg_srv varchar(256),

@reg_agent varchar(256)

if serverproperty('instancename') is null

...

Better to leave it ON.

http://www.sqlskills.com/blogs/kimberly/post/Auto-update-statistics-and-auto-create-statistics-should-you-leave-them-on-andor-turn-them-on.aspx

MJ

What do you see(path) under error log file path when you right click SQL Server Agent in SSMS?

MJ

Hope attached do help you in this.

MJ

Check here-->http://www.sqlservercentral.com/Forums/Topic625430-146-1.aspx

MJ

Detecting the framework versions installed is even easier than reading the registry: It's in the file system. Check for the existence of those directories:

.NET 1.0: %windir%\Microsoft.NET\Framework\v1.0.3705

.NET 1.1: %windir%\Microsoft.NET\Framework\v1.1.4322

.NET...

What do you see under

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoftet framework setupdp

MJ

Please try starting sql server from command prmopt and see what message it pops up.

To start the default instance of SQL Server

From a command prompt, enter one of...