Change the location of the Auto Recovery information in SQL Server Management Studio.

Posted by Scott Chamberlain on Stack Overflow See other posts from Stack Overflow or by Scott Chamberlain
Published on 2010-01-20T19:24:29Z Indexed on 2010/03/30 20:23 UTC
Read the original article Hit count: 293

Filed under:

sql-server-management-stu

|

default

|

ide

Our local IT has our My Documents folder on a network path. This causes a problem from MSQL Server management studio as it saves it auto recovery information every 10 min it will lock up as its doing its save.

I found where VS2008 saved its setting but I can not find out how to change it out of My Documents for this. Does anyone know where that setting is located?

© Stack Overflow or respective owner

Related posts about sql-server-management-stu

Why is SQL Server Compact Edition missing from the list of server types in SQL Server Management Stu

as seen on Stack Overflow - Search for 'Stack Overflow'
I have both 'SQL Server Compact 3.5 Service Pack 1' and 'SQL Server Management Studio 2008' (SSMS) installed on my PC. In the past, I was able to select 'SQL Server Compact Edition' from the list of 'Server Types' in the 'Connect to Server' dialog within SSMS. This entry is now missing and I have… >>> More
SQL SERVER – Generate Report for Index Physical Statistics – SSMS

as seen on SQL Authority - Search for 'SQL Authority'
Few days ago, I wrote about SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS (Link). A user asked me a question regarding if we can use similar reports to get the detail about Indexes. Yes, it is possible to do the same. There are similar type of reports are available at Database… >>> More
SQL SERVER – Out of the Box – Activty and Performance Reports from SSSMS

as seen on SQL Authority - Search for 'SQL Authority'
SQL Server management Studio 2008 is wonderful tool and has many different features. Many times, an average user does not use them as they are not aware about these features. Today, we will learn one such feature. SSMS comes with many inbuilt performance and activity reports, but we do not use it… >>> More
SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

as seen on SQL Authority - Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL… >>> More
SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video

as seen on SQL Authority - Search for 'SQL Authority'
SQL Server management Studio 2012 is wonderful tool and has many different features. Many times, an average user does not use them as they are not aware about these features. Today, we will learn one such feature. SSMS comes with many inbuilt performance and activity reports, but we do not use it… >>> More

Related posts about default

MySQL Database Query Problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I need your help!!!. I need to query a table in my database that has record of goods sold. I want the query to detect a particular product and also calculate the quantity sold. The product are 300 now, but it would increase in the future. Below is a sample of my DB Table #---------------------------- #… >>> More
vagrant up command very slow on OS X Lion

as seen on Server Fault - Search for 'Server Fault'
When I run vagrant up to provision a new VM on Lion it takes an extremely long time, during which the entire Mac is very laggy and unresponsive. The output is as follows, the key point being the "notice: Finished catalog run in 754.28 seconds" > vagrant up [default] Importing base box 'lucid64'… >>> More
Why won't xattr PECL extension build on 12.10?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I was using the xattr pecl extension in 12.04 (in fact, I think since 10.04) without problem. Not surprisingly, I had to reinstall it after upgrading to 12.10 because of the new version of PHP. But now it fails to build, and I can't figure out why. Other PECL extensions have built fine. And I have… >>> More
converting mysql database to sql server

as seen on Stack Overflow - Search for 'Stack Overflow'
i have a mysql database: /* MySQL Data Transfer Source Host: 10.0.0.5 Source Database: jnetdata Target Host: 10.0.0.5 Target Database: jnetdata Date: 5/26/2009 12:27:33 PM */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for chavrusas -- ---------------------------- CREATE… >>> More
What's the differnce between "Set as Default Device" and "Set as Default Communications Device" in

as seen on Super User - Search for 'Super User'
I noticed that there are two similar options in the "Sound" (Soundcard Configuration window-playback tab in the context menu) window in Windows 7. What is the difference between these two options? "Set as Default Communications Device" "Set as Default Device" >>> More