Other SQL Server Blogs around the Web

Browse by Tags

• 17832
• active
• ado.net
• anti-virus
• asp.net
• best practices
• clustering
• code
• communication
• community
• crash
• database
• database mirroring
• distributed transactions
• dmv
• drivers
• dts
• dynamic
• error
• event
• failover
• failure
• general network error
• instance
• java
• kba
• kill
• link
• maximum
• msdn
• msdtc
• multi-processor
• native
• network
• orphan
• performance
• principal
• recovery
• restart
• rollback
• server
• service
• sharepoint
• slow
• sp_configure
• spid
• ssis
• stored procedure
• sysprocesses
• tcp
• tcp/ip
• transaction
• transport-level
• tsql
• visual studio
• windows 2003

• A Java application crashes when it connects to SQL Server 2008 by using Java Database Connectivity Driver 2.0

  Product: Microsoft SQL Server 2008 Standard & Microsoft SQL Server 2008 Enterprise Editions Notification Contents: New and Major Modifications A Java application crashes when it connects to SQL Server 2008 by using Java Database Connectivity Driver... Posted Jan 26 2010, 02:13 AM by <P>SqlServer-QA.net</P> Filed under: sql server, connections, kba, crash, java, drivers

• SQL Server error: Msg 6101, Level 16, State 1, Line 1 Process ID -2 is not a valid process ID. Choose a number between 1 and 2048 - update

  Here is the quirky error that has caused a resources crunch on a SQL instance, Error : Process ID -2 is not a valid process ID . The actual issue occurred during an update to a table that has been used by Online application to update the action log, intially... Posted Jul 27 2009, 02:07 AM by <P>SqlServer-QA.net</P> Filed under: dmv, sql server, connections, error, best practices, msdtc, code, spid, kill, rollback, orphan, distributed transactions

• SQL Server error: Msg 6101, Level 16, State 1, Line 1 Process ID -2 is not a valid process ID. Choose a number between 1 and 2048

  Here is the quirky error that has caused a resources crunch on a SQL instance, Error : Process ID -2 is not a valid process ID . The actual issue occurred during an update to a table that has been used by Online application to update the action log, intially... Posted Jun 11 2009, 03:33 AM by <P>SqlServer-QA.net</P> Filed under: rollback, orphan, distributed transactions, sql server, connections, error, best practices, msdtc, code, spid, kill

• SQL Server: Quick way to find Active & idle connections on a SQL instance

  Using SQL Server 2005 you can take help of DMV - sys.dm_exec_connections that will give server-level information about the connections. In the olden days usage of sysprocesses system table used to be heavy and same approach can be achieved by using system... Posted May 02 2008, 04:32 AM by SSQA.net Filed under: dmv, sql server, tsql, connections, transaction, active, sysprocesses

• SQL Server DTS: Dynamically Change Source and Destination in Transform Data Task

  I found this useful blog SQL Server DTS: Dynamically Change Source and Destination in Transform Data Task that I would like to share the users that are sub-merged with DTS tasks....( read more ) Posted Oct 10 2007, 03:24 PM by SSQA.net Filed under: sql server, database, ssis, dts, connections, dynamic

• Error message when an application connects to SQL Server on a server that is running Windows Server 2003: "General Network error," "Communication link failure," or "A transport-level error"

  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 an application connects... Posted Oct 07 2007, 08:33 AM by SSQA.net Filed under: sql server, connections, server, kba, failure, transport-level, link, windows 2003, communication, general network error

• Could not connect because the maximum number of '1' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed."

  The above error is obvious when you have setup the SQL Server instance to accept only 1 connection. The default setting for number of user connections is '0' which accepts unlimited connections. With similar settings one of my friend have had... Posted Sep 26 2007, 05:27 AM by SSQA.net Filed under: sql server, connections, recovery, tcp, anti-virus, sp_configure, maximum, service, restart

• FIX: Error message when you use SQL Native Client to connect to an instance of a principal server in a database mirroring session: "The connection attempted to fail over to a server that does not have a failover partner"

  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... Posted Sep 21 2007, 09:53 AM by SSQA.net Filed under: sql server, connections, database mirroring, principal, kba, instance, native

• 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... Posted Aug 29 2007, 02:56 AM by SSQA.net Filed under: sql server, connections, kba, network, clustering, failover

• 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

  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... Posted Aug 23 2007, 06:29 AM by SSQA.net Filed under: sql server, performance, stored procedure, connections, kba, multi-processor, slow

• SQL Server logs 17832 with multiple TCP\IP connection requests

  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 SQL Server logs 17832 with multiple TCP... Posted Aug 22 2007, 02:06 PM by SSQA.net Filed under: sql server, connections, kba, 17832, tcp/ip

• Microsoft ASP.NET Connections, Visual Studio Connections, SharePoint Connections, Mobile Connections, Architect Connections, and SQL Server Magazine Connections

  Event: Microsoft ASP.NET Connections, Visual Studio Connections, SharePoint Connections, Mobile Connections, Architect Connections, and SQL Server Magazine Connections When: November 5 - 8, Las Vegas, NV Dive hard into current and future releases from... Posted Jul 31 2007, 12:27 PM by SSQA.net Filed under: sql server, asp.net, msdn, community, event, visual studio, sharepoint, ado.net, connections