Browse by Tags

• 1204
• area
• assertion
• components
• configuration
• databases
• dbmail
• deadlock
• destination
• error
• file
• jobs
• kba
• knowledgebase
• message
• notification
• operations
• performance
• recovery
• scheduled
• security
• source
• SQL Server
• sqlagent
• ssis
• surface
• suspect
• trace flag
• truncated
• x64

• Recovery of database 'dbname' (10) is 17% complete (approximately 31602 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.

  Though the message specifies as an informational message only and no user action is required, you should take some action to avoid current behaviour of databases within your environment. Also check whether you have enabled the AUTO_CLOSE property for Read More... Posted Wednesday, September 05, 2007 6:13 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, databases, error log, recovery, suspect, message, sqlagent

• Some or all SQL Server 2005 services are not listed in SQL Server Configuration Manager, or you receive a "No SQL Server 2005 components were found" error message when you perform operations in SQL Server 2005 Surface Area Configuration

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications Some or all SQL Server 2005 services are Read More... Posted Wednesday, September 05, 2007 2:41 AM from SSQA.net | (Comments Off) Filed under: security, SQL Server, error log, kba, surface, configuration, area, components, operations

• SSIS Error: Text was truncated or one or more characters had no match in the target code page

  This error started generating since last 2 days on a scheduled job that uses SSIS to import content from a flat file. Eventually we found that a derived column within the table and the flat file flow where dates in YYYYMMDD are changed to MM/DD/YYYY format. Read More... Posted Wednesday, August 29, 2007 5:54 PM from SSQA.net | (Comments Off) Filed under: SQL Server, error, error log, jobs, ssis, truncated, destination, source, file, scheduled

• FIX: Error message when you run a query that is associated with a parallel execution plan in SQL Server 2005: "SQL Server Assertion: File: <lckmgr.cpp>, line=10850 Failed Assertion = 'GetLocalLockPartition () == xactLockInfo->GetLocalLockPart

  Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Error message when you run a query that is Read More... Posted Monday, August 20, 2007 7:37 AM from SSQA.net | (Comments Off) Filed under: SQL Server, x64, error, error log, kba, assertion

• List of Knowledge Base articles (modified/added) for SQL Server 2005 Enterprise Edition

  Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications FIX: Error message when you run a query in SQL Server 2005: "Cannot insert duplicate key row in object <TableName> with Read More... Posted Friday, August 10, 2007 11:03 PM from SSQA.net | (Comments Off) Filed under: SQL Server, error log, knowledgebase, kba

• Deadlock not logged even though using relevant trace flag?

  To my surprise a deadlock information is not logged on SQL Server log, after a struggle for half-day I found that the startup parameters were messed up! It may be usual practice by adopting [ ; -T1204; -T1222 (with blank after semicolon) ] that is what Read More... Posted Monday, August 06, 2007 2:12 AM from SSQA.net | (Comments Off) Filed under: SQL Server, error log, deadlock, trace flag, 1204

• Error: An attempt was made to send an email when no email session has been established.

  What to do when you get the error specified on the subject above? You might get this error message from a job which will send email to an operator when it is completed. First thing to check whether a valid email has been mentioned in the operator. Also Read More... Posted Tuesday, July 31, 2007 7:51 PM from SSQA.net | (Comments Off) Filed under: SQL Server, notification, error log, dbmail, jobs