Browse by Tags

All Tags » error (RSS)
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"
Published 24 June 8 8:33 AM | SSQA.net
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...
Filed under: , , , , , ,
Error: SQL Server not found or Access Denied, General network errors & Timeout expired: Find the root cause with a trace?
Published 24 June 8 3:2 AM | SSQA.net
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...
Filed under: , , , , , ,
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"
Published 7 May 8 3:28 PM | SSQA.net
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...
Filed under: , , , , ,
Error: 'There is insufficient system memory to run this query' and 'Downgrading backup buffers from 960K to 64K"?
Published 28 March 8 4:31 AM | SSQA.net
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...
Filed under: , , , , , , ,
SQL Server 2005 error while importing images using ASP page: “ASP Error ‘ASP 0104: 80004005′”
Published 26 February 8 2:33 AM | SSQA.net
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...
Filed under: , , , , , , , , ,
SQL Server Upgrade Advisor Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Published 13 February 8 5:2 AM | SSQA.net
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...
Filed under: , , , , , , ,
SQL Server error - The linked server has been created but failed a connection test. Do you want to keep the linked server?
Published 16 January 8 1:40 AM | SSQA.net
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...
Filed under: , , , , , , , , , ,
Tabular Data Stream (TDS) version 0x73090003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.
Published 15 January 8 2:9 AM | SSQA.net
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...
Filed under: , , , , , , , , , , ,
Unable to install SQL Server 2008 fails with error code 1603
Published 11 January 8 8:32 AM | SSQA.net
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...
Filed under: , , , , , , , , ,
How to find subscriber is not getting upto date data?
Published 14 December 7 7:18 PM | SSQA.net
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...
Filed under: , , , ,
SQL Server Error 4616 - You cannot perform this operation for the restore database
Published 11 December 7 2:47 AM | SSQA.net
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...
Filed under: , , , , , , ,
Error message when you try to replicate a table from SQL Server 2005 to SQL Server 2005 Mobile Edition: "HRESULT 0x80004005 (0)"
Published 21 November 7 4:25 PM | SSQA.net
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...
Filed under: , , , , ,
You may receive an error message when you try to export a table by using the SQL Server Import and Export Wizard
Published 18 November 7 3:15 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...
Filed under: , , , , , , ,
Error message when you connect to a named instance of SQL Server on a client computer that is running Windows Vista or Windows Server 2008: "Specified SQL server not found" or "Error Locating Server/Instance Specified"
Published 16 November 7 12:18 AM | SSQA.net
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 connect to a named...
Filed under: , , , , , , ,
FIX: You receive an error message when you use Microsoft OLE DB Provider for Visual FoxPro in SQL Server
Published 15 November 7 3:2 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: You receive an error message when you use Microsoft OLE DB Provider for Visual...
Filed under: , , , , ,
Unable to install SQL Server Express - Error SQL Server service failed to start?
Published 7 November 7 1:33 PM | SSQA.net
Imagine a simple installation of SQL Server Express 2005 edition fails with an error "SQL Server service failed to start?" Whether it may be on a X64 based operating system or on a simple desktop with XP PRO, as usual you would go with default...
Filed under: , , , , , , , , ,
How to suppress SQLSTATE messages when executing scripts using SQLCMD?
Published 6 November 7 11:48 AM | SSQA.net
Say you are executing a scheduled job using a batch file and output is stored to a file, then in that output file you will see Warning messages such as SQLSTATE. So how to suppress these messages on the output file. Simply using -i option in SQLCMD as...
Filed under: , , , , , ,
FIX: Error messages when you run a SQL Server 2005 Integration Services package after you install Cumulative Update 2 for SQL Server 2005 Service Pack 2: "Data conversion failed" and "SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR&
Published 31 October 7 9:7 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition,SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX...
Filed under: , , , , ,
FIX: SQL Server 2005 may send error information for the same problem many times when a fatal error occurs
Published 31 October 7 2:11 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications FIX: SQL Server 2005 may send error information for the same problem many times...
Filed under: , , , , ,
You receive an error message when you try to uninstall the second named instance of SQL Server 2005
Published 31 October 7 9:4 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications You receive an error message when you try to uninstall the second named instance of...
Filed under: , , , , ,
More Posts Next page »