SqlServerKudos - Stories tagged with error
1
kudos
spam Kudos Remove

Troubleshoot error messages :: List of modified Knowledge Base (KBA) articles

published 110 days, 12 hours, 49 minutes ago posted by sasa 119 days, 14 hours, 19 minutes ago
Monday, April 12, 2010 7:11:11 AM GMT Saturday, April 03, 2010 5:40:37 AM GMT
Here are the important KBAs that are helpful to troubleshoot the error/warning messages that you get within SQL Server arena. The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications How to troubleshoot Msg 7105 in SQL Server http://support.microsoft.com/kb/2015760/en-US New 4/1/2010 6:20:00 PM GMT How to troubleshoot Msg 5180 in SQL Server http://support.microsoft.com/kb/2015747/en-US New 4/1/2010.... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: enterprise edition, error, kba, memory leak, message, SQL Server
1
kudos
spam Kudos Remove

The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure

published 169 days, 16 hours, 5 minutes ago posted by sasa 179 days, 7 hours, 5 minutes ago
Friday, February 12, 2010 3:54:57 AM GMT Tuesday, February 02, 2010 12:55:21 PM GMT
A typical error occurred when a simple SSIS package has been executed to export 500 rows to another SQL instance, not once atleast 3 times! More information on error text from event viewer that has been generated by the 'service; The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure. 235 buffers were considered and 195 were locked. Either not enough memory is available to the pipeline because not enough are installed,...(r... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: Data, error, export, import, integration services, low memory, Performance, SQL Server, SSIS
1
kudos
spam Kudos Remove

Unable to cast COM object of type 'Microsoft.Office.Interop.Access.Dao.DBEngineClass' to interface type 'Microsoft.Office.Interop.Access.Dao._DBEngine'

published 193 days, 21 hours, 3 minutes ago posted by sasa 200 days, 49 minutes ago
Monday, January 18, 2010 10:56:27 PM GMT Tuesday, January 12, 2010 7:10:48 PM GMT
No doubt that the error on subject line will get no where! This is presented when trying to open a Database Properties using SQL Server Managment Studio, going back to history on the SQL instance where this is presented is an upgraded database instance having upto date service packs (SQL Server 2008 SP1) with no cumulative update packages. Further information on full error text is below: Access Object Collector error: Database Unable to cast COM object of type 'Microsoft.Office.Interop.Access.Dao.DBEngin... (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: access, dll, error, Management Studio, path, registered, sp_configure, SQL Server, SSMS, system
1
kudos
spam Kudos Remove

SQL Server 2005 and SQL Server 2008 reports 701 errors with large batch sizes

published 305 days, 5 hours, 57 minutes ago posted by sasa 308 days, 1 hour, 17 minutes ago
Tuesday, September 29, 2009 2:02:28 PM GMT Saturday, September 26, 2009 6:42:41 PM GMT
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Edition and SQL Server 2008 Enterprise Edition Notification Contents: New and Major Modifications SQL Server 2005 and SQL Server 2008 reports 701 errors with large batch sizes http://support.microsoft.com/kb/2000380/en-US...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: 2005, 2008, 701, batch size, error, Performance, reports, SQL Server
1
kudos
spam Kudos Remove

FIX: Error message when you try to rebuild one partition of an index on an indexed view in SQL Server 2005: "A system assertion check has failed. Check the SQL Server error log for details."

published 305 days, 5 hours, 57 minutes ago posted by sasa 308 days, 13 hours, 37 minutes ago
Tuesday, September 29, 2009 2:02:28 PM GMT Saturday, September 26, 2009 6:22:42 AM GMT
Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New FIX: Error message when you try to rebuild one partition of an index on an indexed view in SQL Server 2005: "A system assertion check has failed. Check the SQL Server error log for details." http://support.microsoft.com/kb/970726/en-US...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: assertion, error, error log, index, kba, parallel queries, SQL Server
1
kudos
spam Kudos Remove

MSG 10314 An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE.

published 306 days, 6 hours, 2 minutes ago posted by sasa 308 days, 17 hours, 47 minutes ago
Monday, September 28, 2009 1:57:32 PM GMT Saturday, September 26, 2009 2:12:43 AM GMT
As it states on the subject line this is an error that would cause when the system is trying to load assembly due to the permissions, the second part of the subject also needs consideration that server may be running out of resources & security issue. Msg 10314, Level 16, State 11, Line 2 An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: .NET, access, Assemblies, BOL, CLR, error, Login, login mapping, privileges, Security, sid, SQL Server, versioncontrol
1
kudos
spam Kudos Remove

FIX: You receive error messages or data is damaged after you run an SSIS package that contains a data flow task in a low memory situation in SQL Server 2005 or in SQL Server 2008

published 306 days, 6 hours, 2 minutes ago posted by sasa 309 days, 14 hours, 8 minutes ago
Monday, September 28, 2009 1:57:32 PM GMT Friday, September 25, 2009 5:51:45 AM GMT
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications FIX: You receive error messages or data is damaged after you run an SSIS package that contains a data flow task in a low memory situation in SQL Server 2005 or in SQL Server 2008 http://support.microsoft.com/kb/972498/en-US...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: agent, data flow, error, fix, kba, low memory, package, SQL Server, SSIS