Cool Tips‎ > ‎

Connectivity

 

Title

Description

Applicability

 

Kill all DB Connections    

 

Kills all connections to a specified database.

 

2000, 2005, 2008, 2008R2, 2012

 

 

Get IP Address and Port       

 

Retrieves  IP address and port for all endpoints on the current instance.

 

2000, 2005, 2008, 2008R2, 2012

 

Capture Server Logon Events    

 

Capture Server Logon events using a logon trigger and store them in a table.

 

2000, 2005, 2008, 2008R2, 2012

         

 

Compare Settings of 2 Connnections

 

Compares the settings (eg ANSI_NULL) of 2 specified connections.

 

2000, 2005, 2008, 2008R2, 2012

 

Get Connection Summary by IP and Login

Retrieves summary reports of connections to the SQL Server by IP address and login name.

 

2000, 2005, 2008, 2008R2, 2012

 

 

'Unable to Connect' error

 An easy method of determining whether the configuration problem is within SQL Server or in the network infrastructure.

 

2000, 2005, 2008, 2008R2, 2012

 

 

 

 

Comments