Other SQL Server Blogs around the Web

Browse by Tags

• .mdf
• .net
• 137
• 1418
• 15029
• 2000
• 2005
• 2008
• 4014
• 4616
• 80004005
• 9003
• access
• access denied
• ado.net
• analysis
• asp page
• aspfaq
• assembly
• assertion
• attach
• authorization
• backup
• bcp
• best practices
• buffers
• build
• cluster
• collation
• connection
• copy
• crash
• create
• ctp
• cube
• damaged
• dashboard
• data
• data files
• data type
• database
• database mirroring
• declare
• designer
• destination
• detach
• developer
• device
• diagram
• downgrade
• download
• dtaengine
• encryption
• environment
• error 6549
• error log
• exception
• execute
• export
• failover
• fatal error
• file
• framework
• FRUNCM
• function
• fuzzy
• general network error
• hardware
• high availability
• hresult
• images
• import
• information
• install
• installation
• instances
• insufficient
• integration
• integration services
• kba
• log file
• memory
• Microsoft
• named instance
• netmon
• performance
• replication
• reporting services
• security
• snapshot
• sql express
• sql server
• ssis
• ssms
• stored procedure
• timeout
• trace
• upgrade
• wizard
• X64

• SQL Server 2005 .NET Framework execution was aborted by escalation policy because of out of memory on 32 bit system

  The above error was returned on a SQL Server 32 bit system that is used for an inventory application, the initial though on out of memory was to see what is the resource usage at that moment as the SQL Server memory settings are set to DYNAMIC and all... Posted Dec 05 2008, 07:23 AM by SqlServer-QA.net Filed under: sql server, performance, memory, clr, error, component, .net, out of memory

• SQL Server 2008 Cluster environment based KBAs

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications How to change SQL Server parameters in a clustered environment when SQL Server is not online... Posted Nov 04 2008, 01:55 AM by SqlServer-QA.net Filed under: sql server, error, cluster, environment, parameter, failover

• SQL Server 2008 crashes when the Sqlservr.exe program is configured to use large pages

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications SQL Server 2008 crashes when the Sqlservr.exe program is configured to use large pages... Posted Jul 31 2008, 03:10 AM by SSQA.net Filed under: sql server, 2008, error, kba, configuration, setup, crash

• FIX: Error message when you run a long stored procedure that is encrypted in SQL Server 2005: "A stack overflow occurred in the server while compiling the query"

  Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New FIX: Error message when you run a long stored procedure that is encrypted... Posted Jun 24 2008, 08:33 AM by SSQA.net Filed under: sql server, stored procedure, error, kba, stack, overflow, compilation

• Error: SQL Server not found or Access Denied, General network errors & Timeout expired: Find the root cause with a trace?

  The following error is a frequent-faced issue by any SQL Server user : SQL Server is unavailable or does not exist or SQL Server does not exist or access denied In this regard we have already relevant post PotentialCauses_Resolution here, but still I... Posted Jun 24 2008, 03:02 AM by SSQA.net Filed under: sql server, trace, error, access denied, netmon, general network error, timeout expired

• FIX: Error message when you use the BULK INSERT statement to import data of the timestamp data type in SQL Server 2005: "An invalid datetime value was encountered"

  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 FIX: Error message when you use the BULK... Posted May 07 2008, 03:28 PM by SSQA.net Filed under: sql server, error, kba, bulk insert, data type, timestamp

• Error: 'There is insufficient system memory to run this query' and 'Downgrading backup buffers from 960K to 64K"?

  Have you ever observed the error specified above? Do you need to worry for this issue, yes! First task to check what are the memory settings on SQL Server, by default they will be DYNAMIC and quite common that they might have set with MIN & MAX settings... Posted Mar 28 2008, 04:31 AM by SSQA.net Filed under: sql server, memory, error, update statistics, buffers, downgrade, memtoleave, insufficient

• SQL Server 2005 error while importing images using ASP page: “ASP Error ‘ASP 0104: 80004005′”

  One of the web application user complained about the above error during the upload process of images to SQL Server database! Most of the web applications have a lot of images used in it. Its not a best practice to store the Image/BLOB type data on the... Posted Feb 26 2008, 02:33 AM by SSQA.net Filed under: sql server, ado.net, error, images, users, best practices, upload, web page, asp page, 80004005

• SQL Server Upgrade Advisor Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

  One of the client referred about the error during the execution of Upgrade Advisor: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Initial thoughts lead to checking the SQL Server timeout... Posted Feb 13 2008, 05:02 AM by SSQA.net Filed under: sql server, error log, error, replication, tools, timeout, upgrade, servers

• SQL Server error - The linked server has been created but failed a connection test. Do you want to keep the linked server?

  Linked Server errors, such as between SQL Server 2000 and 2005 versions are quite common in DBA-day life. When it goes wrong I would always refer (myself) and others to review HowDoI-PreventLinkedServerIssues resource from ASPFAQ site. Also the usual... Posted Jan 16 2008, 01:40 AM by SSQA.net Filed under: sql server, Microsoft, error log, stored procedure, error, 2000, 2005, kba, linked server, aspfaq, issues

• Tabular Data Stream (TDS) version 0x73090003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.

  Very confusing error when trying to connect to a Database Engine (SQL Server 2008) using 'usual' windows authentication getting the following error: A connection was successfully established with the server, but then an error occurred during the... Posted Jan 15 2008, 02:09 AM by SSQA.net Filed under: sql server, Microsoft, system state, 2008, ctp, visual studio, error, protocol, download, .net, framework, connection

• Unable to install SQL Server 2008 fails with error code 1603

  SQL Server 2008 CTP5 is failed to install on Windows Server 2008 core, have no problem in Windows Server 2003. So whenever you have a problem in installing any edition of SQL Server it is better to refer to the log file that is used to log all the activities... Posted Jan 11 2008, 08:32 AM by SSQA.net Filed under: sql server, Microsoft, error log, 2008, connect, community, error, install, unable, network share

• How to find subscriber is not getting upto date data?

  Run the following TSQL to get details of troubled subscribers that are not getting upto date data: select agent_id from msdistribution_status group by agent_id having sum(undelivCmdsInDistDB) >1000 order by sum(undelivCmdsInDistDB) desc...( read more... Posted Dec 14 2007, 07:18 PM by SSQA.net Filed under: sql server, error, replication, data, subscriptions

• SQL Server Error 4616 - You cannot perform this operation for the restore database

  You may be aware default 4 SQL Server system databases master, model, msdb & tempdb are created automatically when the SQL Server is installed. Those databases files can be located under default directory assuming C:\Program Files\Microsoft SQL Server... Posted Dec 11 2007, 02:47 AM by SSQA.net Filed under: sql server, database, error log, error, resource, attach, 4616, .mdf

• Error message when you try to replicate a table from SQL Server 2005 to SQL Server 2005 Mobile Edition: "HRESULT 0x80004005 (0)"

  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 Error message when you try to replicate... Posted Nov 21 2007, 04:25 PM by SSQA.net Filed under: sql server, error, kba, replication, hresult, mobile edition