Welcome to MSDN Blogs Sign in | Join | Help

La bodeguita de Nacho

SQL Server Troubleshooting Stories - "y una ración de bravas"

Browse by Tags

All Tags » Management Studio   (RSS)
TMP/TEMP/USERPROFILE environment variables: the closer they point to, the better
One recent discovery I wanted to eventually share here. Many more programs than you would expect, store information in temporary files. If you configure your environment so that those temporary files get created in a remote location, you will suffer the Read More...
SQL Server Import and Export Wizard blowing up due to an unexpected error
  Somebody was trying to run the SQL Server Import and Export Wizard (DTSWizard.exe) in one of his machines, but when he clicked Next on the first (welcome) dialog, it showed the following error:     =================================== Read More...
Decreasing the size of a database file through the Management Studio GUI?
Somebody told me today that he was using SQL Server Management Studio Database Properties (Files Page) to try to set the Initial Size property of a database file to a value lower than the one currently set for that file on the server. And even though Read More...
"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 (modified a bit to leave relevant information only): From: <Removed_Intentionally> Sent: <Removed_Intentionally> To: <Removed_Intentionally> Read More...
Page view tracker