Browse by Tags

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: sql server, error, kba, stored procedure, overflow, stack, compilation

Error message when you run the bcp utility to copy a result set of a stored procedure that contains a dynamic query in SQL Server 2005: "BCP host-files must contain at least one column"

Published 2 June 8 4:1 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Error message when you run the bcp utility to copy a result set of a stored procedure that...

Filed under: sql server, kba, stored procedure, bcp, dynamic query, error message, dsql

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: sql server, microsoft, error, kba, 2000, error log, 2005, stored procedure, linked server, aspfaq, issues

Stored Procedures caught me with too many recomplies - way out to avoid it

Published 25 October 7 3:35 AM | SSQA.net

A common scenario in SQL Server environment that often application users complained about slow performance and same time you observe high CPU usage/spikes on the SQL Server instance, so better to follow the methods from HighCPU-whyitis blog and still...

Filed under: sql server, performance, indexes, blogs, kba, stored procedure, high cpu, recompile, too many

FIX: You may receive an error message when you run a CLR stored procedure or CLR function that uses a context connection in SQL Server 2005

Published 12 September 7 12:36 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: You may receive an error message when you run a CLR stored procedure or...

Filed under: sql server, clr, kba, concurrent, error log, stored procedure, context

FIX: SQL Server 2005 does not reclaim the disk space that is allocated to the temporary table if the stored procedure is stopped

Published 12 September 7 12:35 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: SQL Server 2005 does not reclaim the disk space that is allocated to the...

Filed under: sql server, kba, disk space, stored procedure, monitoring, temp, temporary

How to use a stored procedure to monitor traces in SQL Server 2005

Published 4 September 7 11:39 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications How to use a stored procedure to monitor traces in SQL Server 2005 http://support...

Filed under: sql server, profiler, trace, kba, process, stored procedure

FIX: Performance is very slow when the same stored procedure is executed at the same time in many connections on a multiple-processor computer that is running SQL Server 2005

Published 23 August 7 6:29 AM | 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: sql server, performance, kba, connections, stored procedure, slow, multi-processor

FIX: Error message when you run a stored procedure that starts a transaction that contains a Transact-SQL statement in SQL Server 2005: "New request is not allowed to start because it should come with valid transaction descriptor"

Published 23 August 7 6:25 AM | 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: sql server, kba, transaction, enterprise, x64, stored procedure, tsql