SQL Server Agent might take long time to start because of slow communications with Certificate Authorities.   If you enable verbose logging for SQL Server agent (-v) and look at the SQL Server agent log you will notice that 'ANALYSISQUERY...

SQL-Server resource fails to come online with Error: [sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 35; message = [Microsoft][SQL Server Native Client 10 .0]A network-related or instance-specific error has occurred while establishing...

My “c:\” Drive gets full when I open the profiler trace System stored procedures like sp_addsrvrolemember or sp_addserver may fail because of McAfee Host Intrusion Prevention Beyond XP_READERRORLOG (parameters of XP_readerrorlog) ...

When you use SQLDMO ??? Install SQL Server2005 Backward compatibility http://download.microsoft.com/download/3/1/6/316FADB2-E703-4351-8E9C-E0B36D9D697E/SQLServer2005_BC.msi Also remember if you have installed 32-Bit SQL Server on 64-Bit you have...

Problem Description : v Unable to start SQL Server 2005 default instance on a standalone server. v We notice below Error message in the SQL Server Error Log 2009-07-15 19:03:25.74 spid5s Error: 15466, Severity: 16, State: 1. 2009-07...

Error The database 'model' is marked RESTORING and is in a state that does not allow recovery to be run. Error: 927, Severity: 14, State: 2. Database 'model' cannot be opened. It is in the middle of a restore. Could not create tempdb. You...

SQLServer2008: Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 574, state 0, severity 16 SQL Server 2008 instance fails to start or hangs after service pack or Cumulative update...

Configuring SSL for SQL Server using Microsoft Certificate Authority Server Refer attached document for detailed steps 1. Install IIS Server from ADD/Remove Windows Components (if it is not installed already) 2. Install Certificate Server...

SQL-Server 2008 Fails to come online on cluster after upgrade. Reason : Server is in script upgrade mode . Only administrator can connect at this time . Login failed for user ‘ccccc\xxxxx. Reason : Server is in script upgrade mode ....

How to Analyze "Deadlocked Schedulers" Dumps? Do you see "Deadlocked Schedulers" errors similar to one below and stuck? From SQLServer Errorlog **Dump thread - spid = 0, PSS = 0x0000000000000000, EC = 0x0000000000000000 ***Stack Dump being...

From management studio we do not see the SQL server and SQL Agent status. When we right click the instance, start, stop and resume options is disabled. WMI Permission could be a cause. Enable below permission in WMI. 1) --Open Dcomcnfg...

DBCC CheckDB may with fail with error Error Msg 5030, Level 16, State 12, Line 1 The database could not be exclusively locked to perform the operation. Msg 7926, Level 16, State 1, Line 1 Check statement aborted. The database could not be checked...

How to Trouble Shoot T-Log file Growth ============================ Enable the following TF for checkpoint:- TRACEFLAG 3512 Description ='Write info on log space used at checkpoint time to errorlog' TRACEFLAG 3502 Description ='Send checkpoint state...

Unable to run SQLAgent job's in SQLServer 2000 Service Pack 4 In SQL Server 2000 Service pack 4. When we try to run a job, the job doesn’t run. We won’t see any failure messages either. When we click the job properties and then click...

What is Trivial Plan? A trivial plan results when the query optimizer determines that given tables referenced in the query and the indexes existing on them, only one plan is possible. Obviously, a recompilation would be futile in such a case. A query...

The only possible way to add an IP to SQLServer2005 after adding new NIC to the node where SQLServer2005 is installed (or) After adding second ip address to existing NIC is to either manually edit the registry or run Service pack/Hotfix setup again. ...

Sysdatabases.status and sysdatabases.status2 Bit of Sysdatabases in SQLServer ======================================================================== <Script1> declare @status int; declare @status2 int; Set @status='65544' --Replace your DB status...

Installation of SQLServer2008 might fail with below error Detailed results: Feature: Database Engine Services Status: Failed: see logs for details MSI status: Passed Configuration status: Failed: see details below Configuration error code: 0xCD263ADC...

The total space used by tempdb equal to the User Objects plus the Internal Objects plus the Version Store plus the Free Space. Use the Below Quer to Track what is consuming Space in Temp Db. ========================================================...

Installation of SQLserver2008 cluster might fail on windows2008 with error mentioned below The cluster resource 'SQL Server' could not be brought online. Error: The group or resource is not in the correct state to perform the requested operation. ...

When you choose to update statistics in your Maintenance Plan, and you have index on "computed column" in that database, the maintenance plan will fail with the following error: [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL...

SQLserver 2005 ships with a set of DMVs that can help you identify the missing indexes for your workload, Analyze the effectiveness of the existing ones and help find out index fragmentation. Using DMVs to find out the index usage history Over a...

Installation of SQLServer2005/2008 on Windows2008 Cluster might fail with error mentioned below ERR [RES] Network Name <SQL Network Name (VSServerName)>: Computer account VSServerName couldn't be re-enabled. status 5 INFO [NM] Received request...

There are two authentication scheme which can be used by SQLserver when connecting to SQLserver using TCP/IP Protocol and windows authentication. 1. NTLM 2. Kerberos When we use Kerberos we get ability to delegate a principal's identity and it...

Unable to connect to SQLServer listening on Non-Default Port? If you connect to SQLServer using the "hostname" it connects to the instance which is listening on 1433. If you make named instance listen on 1433 and connect using "hostname" it connects...