Browse by Tags

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

Published 2 May 8 4:32 AM | SSQA.net

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...

Filed under: sql server, dmv, transaction, connections, tsql, sysprocesses, active

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

Published 10 October 7 3:24 PM | SSQA.net

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 ) Read More...

Filed under: sql server, ssis, database, 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"

Published 7 October 7 8:33 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 an application connects...

Filed under: sql server, server, kba, connections, failure, general network error, transport-level, link, windows 2003, communication

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

Published 26 September 7 5:27 AM | SSQA.net

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...

Filed under: sql server, anti-virus, connections, service, recovery, tcp, restart, maximum, sp_configure

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"

Published 21 September 7 9:53 AM | SSQA.net

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...

Filed under: sql server, instance, kba, connections, database mirroring, principal, native

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

Published 29 August 7 2:56 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 How to change the network IP addresses of SQL Server failover cluster instances http...

Filed under: sql server, kba, connections, clustering, network, 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

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

SQL Server logs 17832 with multiple TCP\IP connection requests

Published 22 August 7 2:6 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 SQL Server logs 17832 with multiple TCP...

Filed under: sql server, kba, connections, 17832, tcp/ip

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

Published 31 July 7 12:27 PM | SSQA.net

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...

Filed under: sql server, msdn, ado.net, community, event, sharepoint, connections, asp.net, visual studio

FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections

Published 4 June 7 7:23 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections http://support.microsoft.com/kb...

Filed under: sql server, kba, enterprise, concurrent, connections