0
votes
0answers
7 views

SQL Union of two task lists in Access - how to get the correct “Assigned to”?

As you all probably know, a Sharepoint task list has an "Assigned To" column. When I import a task list, I get a table for the list and another table, "UserInfo" with the users for that list. When I ...
0
votes
1answer
306 views

Will this query return ALL files modified today?

I'm running SharePoint 2010 and SQL Server 2008 R2. It's hugely important that I create a list of every file within a given content database that has been modified today, 10/31. Will this query do ...
0
votes
1answer
2k views

Datasheet View and Slow Query StackTrace-Managed

I have a list with 20000 items when I'm trying to open it in Datasheet View it shows me 100 records and then alert on the screen. Cannot connect to the server at this time. You can continue ...
0
votes
2answers
777 views

How do I use a SQL query to check-in a document?

Yesterday I started looking at the tables in my SharePoint 2010's Content databases for the first time and I noticed something a little unnerving: There were files that were checked out and the web ...