.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Saving and opening files is slow

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Hi - hope someone can answer my question. I'm using SSMS 2008 on Windows 7.  When I go to open or save a file, it is unbelievably slow when I go to navigate folders using the pull-down in the top of the Open or Save File dialog.  It goes completely unresponsive for about 30 seconds. Has anybody seen this or know how to fix it?Jeff Balcerzak

View Complete Post

More Related Resource Links

Not always prompted for read-only or EDIT mode, when opening files with IE7, Sharepoint 3.0

Hello Everyone,   We use Sharepoint 3.0 and when I click on a document I get a pop up prompt that asks me whether I want to open the file in READ-ONLY or EDIT mode.   I use a machine with XP Pro that is running IE7.   A user called me today, also running IE7, and when he clicks to open a Sharepoint file he gets a different prompt - a simpler one that just offers OPEN or SAVE.   I don't care that his prompt looks different - the problem is that he is able to open the file, make edits, but then when he closes the file (using Excel) he isn't able to save his changes.   Excel only provides a save-as option for him.   This isn't a permission problem with his ID.   When I login to our Sharepoint 3.0 system as him, with his password (from my machine), I get the usual Read-Only / Edit prompt and when I open a file in EDIT mode I am able to save my changes with no problem.   Any thoughts on this?   Chris

Problem Saving Files to A Sharepoint 2010 Site from Office 2010: Saves locally by default rather tha

Hi we are starting to use sharepoint 2010 / word 2010 and have found an interesting bug/problem. Sometimes when a user tries to save a file (by clicking on the save button in the quick access toolbar for word 2010) the save dialog comes up with the users local "Documents" folder as the path (not the correct sharepoint path where the document should be saved).  (I should say that we are creating the file from sharepoint by using a toolbar on the document library, with the new button)  We are using a content type and a template attached to the document library when we create the file.  This is really annoying because the user might not notice that the document is saving locally and not to sharepoint.  I have found a strange workaround which involves clicking the [File] tab on the ribbon in word 2010, then clicking "Save and Send" and then clicking the save button again.  At this point word 2010 seems to "remember" that it is trying to save document to sharepoint and shows the sharepoint document library. This is a real nuisance which could lead to documents being lost/misfiled if people don't realize that this is happening.  Can anyone help me? Thanks Kevin krd

wss2.0 and opening office 2007 files directly from site


When opening a office 2007 file directly from a wss2.0 link, eg. http://sharepointsite/document.docx, I am prompted with the 'Open|Save|Cancel' dialog.

On selecting Open, the file does not open (as it does for an office 2003 file) but prompts me to Save the file.

When opening the file from the document library, it opens directly, just not through a direct link to the file.

Any solutions on how to open the file directly?


Opening non-Microsoft files in SharePoint


Hi, I wonder if anyone has any idea on this...? My guess is it's something quite simple.

We're using SharePoint 2007 to store shared documents. Some of the documents are Acrobat PDFs. When I click on them, they open up in Acrobat Reader, when another user clicks on them (from his workstation), they open in a web-page. If he opens up other Office document types (Word, Excel), they open in the application as expected.

If he opens Acrobat on his desktop, and then selects the file from the SharePoint folder, it opens up in Acrobat as normal. Any ideas on what could be the cause of this?

Sorry if this question is rather unsophisticated, I'm not all that technical....

Thanks in advance for any assistance.


Error opening excel files stored in SharePoint 3.0 from VS2010 (TFS2010 setup)



First I hope this is the correct forum for te below question, and if not, please excuse and if possible divert me to the correct place.

We have a TFS2010 setup with (what I managed to identify) Sharepoint Services 3.0.
We have 2 users working in the same collection, and also share some of the projects in it with the below problems:

1. User A has Office 2007. She is unable to "edit workbook" on an excel file directly from VS2010, and gets an error of 'Unknown error trying to lock file'. I searched this around and didn't find a solution, but did find a workaround - If she checks out the file directly from the SharePoint site, she is able to edit the file, and in fact is able to later "edit workbook" directly from VS2010 (as long as she once checked it out through SharePoint).

2. User B has Office 2010. When he tries to "edit workbook", he gets an error of 'A problem occurred while connecting to the server. If the problem continues, contact your administrator'. When he goes directly to the SharePoint, he is able to check out the file, open it in Excel 2010, but is not able to check it back in (gets an error that the file cannot be located or so, I don't have the exact error). This means that this user cannot work with the SharePpoint stored files at all, and currently works on local copies on hi

Saving PDF files seamlessly back to Sharepoint


We're running Sharepoint 2007 Enterprise. We have a document library which contains soft copies of faxes receved from customers in PDF format. Staff in our Service Centre need to be able to:

- open a PDF file
- make edits to it (e.g. in Adobe Acrobat Professional)
- save the file back to Sharepoint.

I know there's a workaround to save the PDF to the local PC and then go back into Sharepoint and load it back into Sharepoint - but this is too time-consuming and error-prone. While it's a very straighforward and seamless user experience for MS Office files type such as Word or Excel, we have spent literally months trying to figure out how to do this for PDF files and have still not come up with a workable solution. The closest we got was to use some software called SwiftWriter from Omtool, but unfortunately it doesn't work on folders containing more than 366 files.

Does anyone have a solution for this?

Uploading .pdf files with FIle Upload control and then saving to database


Hi everyone!

I'd like to allow users to upload a .pdf file via the file upload control (if that's the best method), save the file to the db and then retrieve it so they can click on a link and open the .pdf they've uploaded.

I've been looking for a tutorial on how to do this but keep running into methods of saving the file directly on the server in a directory, not in SQL server  (using Linq and VB by the way)

Can someone please point me in the right direction on how to do this?   Thanks!

Error saving Office 2010 files opened from SharePoint Server 2007


I have recently started testing Office 2010 and have found only 1 major issue - I cannot save any Office 2010 files opened from a SharePoint Server 2007 location.  Upon save I receive an error message saying "Upload Failed. This file wan not uploaded because the specified path was not found on the server." and the file is captured in the Microsoft Upload Center.  Using the Upload Center action 'Open Web Site' opens the site without problem; however, a all subsequent resolve actions fail.  Any ideas?


  * MS Windows Server 2003 R2
  * MS SQL Server 2008 R2
  *Office SharePoint Server 2007
  *MS Office 2010 Premium

sharepoint site is opening slow



We are running sharepoint 2007 and my users says the site is taking 30 to 50 seconds to open a site. And when they open a site first time in the morning it takes minimum 60 seconds to open the site. is there any way to check why it is taking long time, please help me i am new to sharepoint.


Thanks in advance

Visual Studio 2010 crashes when opening XAML files


I'm having a problem opening XAML files in Visual Studio 2010.  When I open a XAML file, Visual Studio become very slow and the XAML file never produces an outline or a rendered version of the XAML.  When I click in the text of the XAML, it can take several minutes for the cursor to appear where I clicked.  The XAML file is rather small - just a grid with some basic controls on it (a grid, stack panel, radio buttons, date pickers, etc).  The problem occurs if I open any XAML file in the project, though.

When I watch devenv.exe in the task manager, as soon as I open a XAML file, the process is consuming 100% of one of the CPUs and begins eating chunks of memory at the rate of about 5MB/second and creating a new thread about every two seconds.    The memory use grows until it's about 700MB and the number of threads climbs to between 450-470 before it levels off.  Even after it stops producing new threads and consuming more memory, the XAML file is still unresponsive and it's still using 100% of one of the CPUs.  Even after a half hour, the CPU is still at 100% with 452 threads.

I have completely uninstalled and reinstalled Visual Studio but I'm still having the same problem.

I'm running XP sp3 32-bit with VS 2010 Ultimate on a dual core machine with 4GB RAM.  At this point I simply can't edit XAML

Sharepoint seeking authentication when opening Word / Excel files from website


The company I work for is using SharePoint as a CMS for it's public facing website. I recently enabled FBA (Forms Based Authentication) for the site in order to provide some user specific functionality, but this has caused a side effect with Word / Excel files when opened from the site using Office 2007 / 2010.

Some users are challenged for authentication when opening a Word / Excel document from IE (but not when they're select "save file" instead of "open file"). A window pops up behind IE / Word / Excel (so you often don't realise it's there) showing the sites login page. If the window is dismissed then the document continues to open normally.

It seems to be environmental. Most Office 2007 / 2010 users internally experience this and we've had one report externally of this happening.

Anyone know how to prevent this behaviour?

In case it's relevant: The company also has an internal SharePoint site using NTML authentication allowing internal users to edit the same content visible externally.

I originally suspected the SharePoint header added to responses may be alerting Office to check for authentication to allow extended functionality, but I remove the response header in IIS and it didn't make any difference.


Opening sql files opens new instance of SQL Management Studio


Hi Folks,

I'm sure this has been answered before but all my searches for this problem don't find what I need. It's a quirk but driving me nuts.

If I have sql management studio open and I view a sql file from Vault, or double-click it in explorer, it always opens a new instance of mgmt studio. I open 5 sql files, 5 instances of mgmt studio.

How do I tell my system to reuse mgmt studio to open sql files if it's open?

Thanks in Advance,


Clean Web.Config Files (VS 2010 and .NET 4.0 Series)

.NET 4 includes a new version of the CLR, and a new .NET 4 specific machine.config file (which is installed side-by-side with the one used by .NET 2, .NET 3 and .NET 3.5).

The new .NET 4 machine.config file now automatically registers all of the ASP.NET tag sections, handlers and modules that we've added over the years, including the functionality for:

.ASP.NET Dynamic Data
.ASP.NET Routing (which can now be used for both ASP.NET WebForms and ASP.NET MVC)
.ASP.NET Chart Control (which now ships built-into ASP.NET V4)
What this means is that when you create a new "Empty ASP.NET application" project in VS 2010, you'll find that the new default application-level web.config file is now clean and simple:

SharePoint document migration challenges when migrating files and folders

There are several challenges when migrating documents to Microsoft SharePoint. While these challenges can be overcome, they are a real pain if the migration source, content and file systems are not SharePoint friendly.

Combine, minify and compress JavaScript files to load ASP.NET pages faster

Websites are getting more interactive these days and most of this interactivity comes from JavaScript. People are using different JavaScript libraries and frameworks to make their websites more interactive and user friendly.

PrintPocketCE Print Pocket Excel, Pocket Word and email files

Version 3.560 (May 15, 2009):

Important bug fix: a slight difference in how some devices create fonts was causing a few devices to have significantly longer print times for large print jobs.

Adjusted PocketJet printer paper feed commands

Other minor fixes and enhancements.

Version 3.559 (Mar 5, 2009):

Added support for Martel MCP78xx printers

Version 3.558 (Aug 20, 2008):

Added support for Martel MCP78xx printers

Version 3.557 (June 27, 2008):

Fixed error in Canon printer support

Fixed COM0 port selection

Version 3.556 (June 15, 2008):

Added support for Brother MW-260

Added support for Sato MB400

Version 3.555 (Aug 8, 2007):

Added support for Pentax RuggedJet 3 and RuggedJet 4 printers

Changed Epson TM-P60 support to maximum page width of 1200 dots

Version 3.551 (Aug 1, 2006):

Added Peripheral Nomad printer support

Version 3.550 (Mar 23, 2006):

Added Panasonic JT-H200PR printer support

Added Pocket Spectrum printer support

Fixed problem with WM5.0 "inverted image" problem

Conversion of text files from ANSI to UTF-8

reading and writing text files in ANSI format and
writing html-files in Charset ISO-8859-1 (Western Europe).
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend