Tag Archives: sql server 2005

Excel X64 driver and SQL Server 2008 R2 on cluster node [Fix]

As we continued with the execution of our migration plans from SQL Server 2005 to 2008 R2 X64, we found challenges than needed to be resolved pretty quickly. The latest issue we encountered was the Microsoft.ACE.OLEDB.12.0 provider in SQL Server 2008 R2 X64. With that same provider, we were able… Read more »

SQL Trace causing error “The client was unable to reuse a session with SPID XXX”

We will open traces whenever a slow performing process needs to be pinpointed. We never experienced a high overhead until today. A couple of our production sites and services started to time out and SQL Server started login this errror: From: SQLAlerts [mailto:SQLAlerts@xyz.com] Sent: Monday, October 04, 2010 10:13 AM… Read more »