Other SQL Server Blogs around the Web

Browse by Tags

• 2000
• 2005
• 2008
• access
• access violation
• agent
• analysis
• analysis cubes
• Analysis Services
• application
• backups
• bcp
• blogs
• clustering
• column
• communication
• compact edition
• configuration
• connections
• cubes
• cumulative
• data source
• database
• database mirroring
• download
• dts
• dynamics
• enterprise
• error
• error log
• error message
• errorr
• exception
• export
• failover
• function
• gp
• import
• insert
• installation
• instance
• integration services
• linked server
• longhorn
• maintenance
• management studio
• memory
• Microsoft
• move
• msdn
• msdtc
• multi-processor
• named instance
• native client
• network
• object
• olap
• oledb
• outer join
• package
• performance
• plan
• port
• principal
• process
• processor
• publication
• publisher
• query
• replication
• report
• report builder
• report viewer
• reporting services
• sa
• security
• server
• servers
• service pack
• service pack2
• services
• setup
• slow
• snapshot
• sp2
• sql server
• ssis
• ssms
• stored procedure
• subscriber
• support
• synchronization
• table
• transaction
• update
• vista
• windows
• windows 2003
• windows 2008
• X64

• The cluster setup fails without a clear error message when you install a SQL Server 2008 failover cluster and you select a drive that does not have a drive letter assigned

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications The cluster setup fails without a clear error message when you install a SQL Server 2008... Posted Nov 05 2008, 04:58 AM by SqlServer-QA.net Filed under: sql server, kba, setup, error message, drive letter, failover cluster

• SQL Server 2005 Enterprise & Standard Editions Knowledge Base Notifications

  Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New FIX: A SQL Server Agent job that creates a ServerXMLHTTP object by using an ActiveX script remains in the Executing status and is never completed in... Posted Oct 21 2008, 11:40 AM by SqlServer-QA.net Filed under: sql server, X64, 2005, kba, standard edition, enterprise edition

• FIX: When you call the SQLExecute function to run a query after you set the SQL_ATTR_ROW_ARRAY_SIZE attribute, you may obtain incorrect results in SQL Server 2008

  Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications FIX: When you call the SQLExecute function to run a query after you set the SQL_ATTR_ROW_ARRAY_SIZE attribute, you may obtain incorrect... Posted Oct 21 2008, 09:38 AM by SqlServer-QA.net Filed under: sql server, kba, query, results, function, sqlexecute

• 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

• SQL Server 2005 supportability on virtual environment

  Virtualization and Consolidation is still a hot topic and revising SQL Server consolidation and virtualization - hot topic in the industry related post here that you can easily manage the resources by using virtual machine technology that enables multiple... Posted Jul 30 2008, 03:39 AM by SSQA.net Filed under: kba, environment, support, virtual, sql server

• How to troubleshoot SQL Server 2008 Setup issues

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications How to troubleshoot SQL Server 2008 Setup issues http://support.microsoft.com/kb/955396... Posted Jul 30 2008, 03:09 AM by SSQA.net Filed under: sql server, 2008, kba, setup

• FIX: Error message after you run the DBCC DBREINDEX Transact-SQL statement on a table that does not have a unique clustered index on a SQL Server 2005-based computer: "Msg 2511"

  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 FIX: Error message after... Posted Jul 03 2008, 04:46 PM by SSQA.net Filed under: sql server, tsql, kba, clustered index, dbcc dbreindex, unique, 2511

• You receive a "Creating the partitioned snapshot" message when you create a pull subscription that is configured to receive the precomputed partition of a merge publication 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 Notification Contents: New You receive a "Creating the partitioned snapshot" message... Posted Jun 27 2008, 04:10 AM by SSQA.net Filed under: sql server, kba, publication, merge replication, partition

• 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

• FIX: Error message when you run a DELETE statement from a table that contains a nonclustered primary key in SQL Server 2005: "Internal Query Processor Error: The query processor could not produce a query plan"

  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 FIX: Error message when... Posted Jun 23 2008, 08:30 PM by SSQA.net Filed under: sql server, kba, processor, query, delete, query plan, statement, internal

• KBA: Articles on SQL Server 2005, 2000 & MSDE Installation issues

  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 SQL Server 2005 installers... Posted Jun 12 2008, 10:02 PM by SSQA.net Filed under: sql server, 2000, 2005, kba, installation, instance, msde

• A tape device is not detected by SQL Server Management Studio in SQL Server 2005 or by SQL Server Enterprise Manager in SQL Server 2000

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New A tape device is not detected by SQL Server Management Studio in... Posted Jun 12 2008, 02:01 AM by SSQA.net Filed under: sql server, kba, enterprise manager, tape, backups, management studio

• 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"

  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... Posted Jun 02 2008, 04:01 AM by SSQA.net Filed under: sql server, stored procedure, kba, bcp, dsql, error message, dynamic query

• Changes to a SQL Server Agent job are lost when the job corresponds to a subplan in a maintenance plan that you created in SQL Server 2005 Service Pack 2

  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 X64Edition Notification Contents: New Changes to a SQL Server Agent... Posted May 29 2008, 01:29 PM by SSQA.net Filed under: sql server, kba, service pack2, maintenance plan, subplan

• SQL Server Cumulative Update uninstallation fiasco. Dude, can I remove SQL Server setup files?

  We have been struggling to uninstall the Cumulative Update package 7 on a development SQL Server! As it is an important aspect of installation to rollback or to have a backout plan tested if you are performing any kind of installation against your Production... Posted May 28 2008, 03:10 AM by SSQA.net Filed under: sql server, kba, best practices, setup, cumulative update, installallation