Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


SharePoint Batch File Check In

By:   |   Last Updated: 2010-03-31   |   Comments   |   Related Tips: > Sharepoint


I frequently have large numbers of files in a SharePoint Document Library, that are in a "Checked Out" status for a variety of reasons. Is there a way to check them in all at once?


Yes. By using SharePoint Designer 2007, you can do bulk document check ins. In the SharePoint Designer application, documents that are checked out are visibly noted with a green check mark next to them.

To check them in, right click on the desired files, then select "Check In" from the context sensitive menu. 

The next page of the Check In Wizard, displays the files that will be checked in and optionally gives you a chance to make a global comment in the "Comments on version" field. (Keeping the files checked out, seems to defeat the purpose of this procedure, so leave the checkbox off.) Then click "OK".

Now your documents should appear in the library without the green check marks.

Currently, SharePoint Designer 2007 is a free download from Microsoft. See this tip.

Next Steps
  • Check out MSSQLTips.com for great information about Microsoft SQL Server.

Last Updated: 2010-03-31

get scripts

next tip button

About the author
MSSQLTips author Rob Fisch Rob Fisch has worked with SQL Server since version 6.5 as a dba, developer, report writer and data warehouse designer.

View all my tips

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Learn more about SQL Server tools