La bodeguita de Nacho
SQL Server Troubleshooting Stories - "y una ración de bravas"
Cannot patch an instance of SQL Server 2005 if there is a mounted drive under the Data folder
In the following example, I tried to apply Service Pack 2 on top of an existing instance of SQL...
Author: Nacho Alonso Portillo Date: 12/11/2007
SQL Server 2005 setup fails if network name of the NIC includes a comma
Is your SQL Server 2005 installation blowing out while trying to install a clustered instance? And...
Author: Nacho Alonso Portillo Date: 12/11/2007
SQL Server 2005 hotfix, Cumulative Update or Service Pack installation fails with error 1053
You may be trying to apply one hotfix, one Cumulative Update or one Service Pack on top of your SQL...
Author: Nacho Alonso Portillo Date: 12/10/2007
Conflict Viewer's UI becomes practically unusable when run from a French SQL installation on a French Operating System
When running Conflict Viewer (C:\program files\microsoft sql...
Author: Nacho Alonso Portillo Date: 12/09/2007
Would you like to share with us your experience with Microsoft's Customer Support Services?
Have you had the opportunity to ever use our support services? How would you score the service you...
Author: Nacho Alonso Portillo Date: 12/08/2007
Error 22022: SQLServerAgent Error: Network problems are preventing connection to the Microsoft Exchange Server computer.
Another troubleshooting story to share... Customer was using SQL Server 2000 (build...
Author: Nacho Alonso Portillo Date: 12/07/2007
"SQL Execution Error: Timeout expired. The timeout period elapsed..." while opening view from SSMS
Another recently answered question from a colleague. My colleague posted the following question...
Author: Nacho Alonso Portillo Date: 12/04/2007
Another good reason why I think we should deprecate AutoRun setting from Command Processor
The cause for this nasty to diagnose behavior was that in customer's machine, when you ran...
Author: Nacho Alonso Portillo Date: 12/04/2007
Por acaso voçê nao esta a lêr o meu blog so porque nao esta traduzido ao português?
Se for assim, so tem que me deixar um comentário para eu saber. Desde o início do blog, eu...
Author: Nacho Alonso Portillo Date: 11/30/2007
¿Hay alguien que esté dejando de leer este blog porque no está traducido al español?
Si es así, por favor, házmelo saber mediante un comentario. Desde el principio he barajado...
Author: Nacho Alonso Portillo Date: 11/30/2007
Is it possible to configure SQL Server Agent to connect to SQL Server using SQL Server authentication?
KB Article 943525 (You cannot start the SQL Server Agent service of a failover cluster of SQL Server...
Author: Nacho Alonso Portillo Date: 11/29/2007
Is SQL Agent manipulating the errors raised by SQL Server, before dumping them to the output file?
One customer reported that when he was executing the following batch use master exec sp_updatestats...
Author: Nacho Alonso Portillo Date: 11/29/2007
Multiple Core and Hyper-Threading enabled CPUs and SQL Server 2005
One colleague recently asked me, is the information in this article 914278 (How SQL Server 2005...
Author: Nacho Alonso Portillo Date: 11/26/2007
How much Virtual Address Space can my SQL Server 2000 process see when running under WOW in an x64 OS?
One colleague asked me that question in order to answer one of his customer's multiple questions....
Author: Nacho Alonso Portillo Date: 11/26/2007
ExecuteCaptureLog doesn't work with ErrorConfiguration
One colleague reported to me that the following code snippet (as it was being used by a customer)...
Author: Nacho Alonso Portillo Date: 11/23/2007
Unexpected "Tuning indexed views requires SQL Server 2005 Enterprise Edition"?
One day this week, I received the following query from a colleague. Run ScriptToPrepareRepro.sql in...
Author: Nacho Alonso Portillo Date: 11/21/2007
Flat File Provider and Decimal/Numeric data
Last week I received the following message from a colleague: From:...
Author: Nacho Alonso Portillo Date: 11/15/2007
Order in which DTS Packages are displayed from SQL Server 2005 GUI
Earlier this year somebody raised the following concern: From: <Intentionally_Removed>...
Author: Nacho Alonso Portillo Date: 11/15/2007
Are you suffering from random AdomdConnectionException thrown when trying to connect to a named instance?
This is fixed starting with CU6. More info in this post. I recently analyzed an issue reported by...
Author: Nacho Alonso Portillo Date: 11/14/2007
You cannot alter one table using Visual Database Tools (VDT) unless you are either a member of db_dbowner or sysadmin
Members of db_ddladmin fixed database role or users who have explicitly been granted CREATE TABLE...
Author: Nacho Alonso Portillo Date: 11/14/2007
Unable to connect to the registry on the Server (MyOLAPServer) or you are not a member of OLAP Administrators group
This is the story of a case which took me some time to diagnose, and which I considered worth...
Author: Nacho Alonso Portillo Date: 11/13/2007
I'm logging it!
Yeap! Believe or not, I started blogging here. :-)
Author: Nacho Alonso Portillo Date: 11/13/2007