Browse by Tags

• 1
• 17832
• 2005
• access
• account
• administrator
• agent
• analysis
• application
• area
• assertion
• auto
• Backup
• backups
• bcp
• binary
• biztalk
• buffer pool
• business
• calendar
• child package
• client
• clustering
• collation
• column
• components
• configuration
• connections
• copy
• cpu
• cubes
• cumulative
• cursor
• data
• data source
• database
• database mirroring
• datareader
• developer
• device
• display
• dll
• dmv
• dtaengine
• dts
• dump
• duplicate
• dynamics
• enterprise
• error
• error log
• exception
• failover
• failure
• file
• ftp
• fulltext
• gp
• grey
• high availability
• hotfix
• incorrect
• index
• Integration
• memory
• network
• performance
• plan
• process
• processor
• query
• replication
• Reporting Services
• security
• server
• service pack
• service pack2
• services
• servicing model
• slow
• sp2
• SQL Server
• sqlnative
• ssis
• SSMS
• statistics
• stops
• stored procedure
• string
• subscriber
• surface
• sys.dm
• table
• tape
• tcp/ip
• timeout
• transaction
• unhandled
• update
• x64

• 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

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

  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.microsoft.com/kb/912914/en-US...( Read More... Posted Wednesday, September 05, 2007 2:39 AM from SSQA.net | (Comments Off) Filed under: SQL Server, profiler, trace, process, stored procedure, kba

• FIX: The calendar control in a SQL Server 2005 Reporting Services report may display incorrect values

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: The calendar control in a SQL Server 2005 Reporting Services report Read More... Posted Wednesday, September 05, 2007 2:38 AM from SSQA.net | (Comments Off) Filed under: Reporting Services, SQL Server, kba, calendar, display

• FIX: An application that is included in SQL Server 2005 may stop responding when you specify a network protocol that is not valid in the application

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: Read More... Posted Saturday, September 01, 2007 2:41 AM from SSQA.net | (Comments Off) Filed under: SQL Server, kba, network, application, protocol, stops

• FIX: Error message when you display a report that uses SAP Business Information Warehouse 3.5 as the data source in SQL Server 2005 Service Pack 2 Reporting Services: “Can't find object <Object ID>”

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: Error message when you display a report that uses SAP Business Information Read More... Posted Saturday, September 01, 2007 2:25 AM from SSQA.net | (Comments Off) Filed under: Reporting Services, SQL Server, kba, service pack2, information, data source, business, sap

• How to enable the SQL Server 2005 Integration Services process to generate a dump file when the process experiences exceptions

  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 How to enable the SQL Server 2005 Integration Read More... Posted Friday, August 31, 2007 5:56 AM from SSQA.net | (Comments Off) Filed under: SQL Server, Integration, services, process, ssis, kba, exception, file, dump

• FIX: In SQL Server 2005 Service Pack 2, the toolbar of a Reporting Services report turns gray when you click "View Report"

  Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: In SQL Server 2005 Service Pack 2, the toolbar of a Reporting Services report turns gray when you click "View Report" Read More... Posted Friday, August 31, 2007 4:48 AM from SSQA.net | (Comments Off) Filed under: Reporting Services, SQL Server, kba, grey, toolbar, view report

• FIX: Error message when you use the Bcp.exe utility together with the queryout option in Microsoft SQL Server 2005: “BCP host-files must contain at least one column”

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Read More... Posted Friday, August 31, 2007 4:45 AM from SSQA.net | (Comments Off) Filed under: SQL Server, kba, column, service pack2, bcp, queryout

• FIX: Error message when you run a query that selects many columns and that joins many tables in SQL Server 2005 Service Pack 2: "The query processor could not produce a query plan"

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Read More... Posted Friday, August 31, 2007 4:42 AM from SSQA.net | (Comments Off) Filed under: SQL Server, query, kba, processor, service pack2, plan

• FIX: The performance of a query that performs an insert operation or an update operation is much slower in SQL Server 2005 SP2 than in earlier versions of SQL Server 2005

  The following pages were recently modified. 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: Read More... Posted Thursday, August 30, 2007 8:00 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, query, service pack, kba, update, operation

• FIX: Error message when you use Database Engine Tuning Advisor to tune a database in SQL Server 2005 Service Pack 2: "An unhandled win32 exception occurred in dtaengine90.exe [4308]"

  The following pages were recently modified. 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: Read More... Posted Thursday, August 30, 2007 5:38 AM from SSQA.net | (Comments Off) Filed under: SQL Server, error, service pack, kba, exception, unhandled, dtaengine

• How to reduce paging of buffer pool memory in the 64-bit version of SQL Server 2005

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications How to reduce paging of buffer pool memory in the 64-bit version of SQL Server Read More... Posted Thursday, August 30, 2007 4:09 AM from SSQA.net | (Comments Off) Filed under: SQL Server, x64, memory, kba, buffer pool, paging

• FIX: You receive an error message when you try to install the original release version of SQL Server 2005 or SQL Server 2005 Service Pack 1 on a computer that is running Windows Vista

  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 Read More... Posted Thursday, August 30, 2007 3:31 AM from SSQA.net | (Comments Off) Filed under: vista, SQL Server, windows, service pack, kba, 1

• How to change the network IP addresses of SQL Server failover cluster instances

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications How to change the network IP addresses of SQL Server failover cluster instances http://support.microsoft.com/kb/244980/en-US...( Read More... Posted Wednesday, August 29, 2007 5:56 PM from SSQA.net | (Comments Off) Filed under: SQL Server, connections, kba, network, clustering, failover

• FIX: You receive an incorrect result when you use a SQL Native Client provider to read the data on the client computer in SQL Server 2005

  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 Read More... Posted Tuesday, August 28, 2007 5:03 AM from SSQA.net | (Comments Off) Filed under: SQL Server, kba, 2005, client, sqlnative