Showing 2 results for the tag: SQL Server.

Determining what a SQL Server connection is doing

Quick note here describing how to find out what a connection to a Microsoft SQL Server is doing.  First you need to find the connection. Display current connections Use the sp_who2 stored procedure to find the current connections.  Use the following information to determine the connection of interest. SPID – The ID of the connection.  […]

Configuring SQL Server after a rename

I’m in the process of moving to a two-machine development environment so my SQL Server processing will occur on one machine and my application will run on another machine.  I’m making this change since I’ve found that a single machine with 4GB can’t handle both processing 4 million records AND running an application that processes […]