Windows SharePoint Services > SharePoint Products and Technologies Forums > SharePoint - Enterprise Content Management > Can't save SQL Server Management Studio sql file back into Sharepoint Document Library
Ask a questionAsk a question
 

AnswerCan't save SQL Server Management Studio sql file back into Sharepoint Document Library

  • Tuesday, June 23, 2009 6:43 PMsudermatt Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I created an sql query file in SQL Server Management Studio and saved it onto my hard drive. 
    I then moved that file into a Sharepoint Document Library so others on my team could use that query.
    I opened the file from within sharepoint, it launched SSMS.
    I made a change to the file and pressed save.
    here is the error message that comes up.
    "The operation could not be completed.  The process cannot access the file because it is being used by another process"

    Am I doing something wrong?

Answers

  • Wednesday, June 24, 2009 9:27 AMSerge Luca [MVP]MVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    The reason is SSMS doesn't support webdav; you must save the file locally and upload the new version to Sharepoint manually

    Serge Luca; blog: http://www.redwood.be
    • Marked As Answer bysudermatt Wednesday, June 24, 2009 10:48 PM
    •  

All Replies

  • Wednesday, June 24, 2009 9:27 AMSerge Luca [MVP]MVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    The reason is SSMS doesn't support webdav; you must save the file locally and upload the new version to Sharepoint manually

    Serge Luca; blog: http://www.redwood.be
    • Marked As Answer bysudermatt Wednesday, June 24, 2009 10:48 PM
    •