In our production environment, we have two 4-node clusters. One cluster runs at the primary site; the other cluster runs at our disaster recovery site. Each cluster is running 11 SQL Server 2005 instances.
Read more →
Well today has definitely been interesting. I have been working with a co-worker who is responsible for trouble shooting customer problems. This specific customer is running our product with MSDE. We do not have dial-up access to the server, so everything is being done over the phone, plus the customer speaks Spanish, which I do not.
Read more →
I have been asked to look into why a stored procedure is failing. The problem is that the application gets an error that a temp table doesn't exist. Here is the code with the problem (my comments in blue, contents were changed to protect company information):
Read more →