The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
15 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
0answers
23 views

Select Max value records group by field

looking for CAML query to select records max value group by filed example: pid name value 1 abc 1 1 xer 2 1 wer 3 2 rer 1 2 wew 2 2 wew 4 I ...
0
votes
1answer
48 views

Show the Results of a SQL Query in SharePoint 2013

I need to display the results of a SQL query within SharePoint 2013. I have written the query, which is saved as a view within SSMS however can't see an obvious way to simply display the results, ...
0
votes
0answers
19 views

List based on SQL Data

I use SP2013, and I have a read-only account on a database in another server. I want to be able to query these data (i'm enough friendly with Select From Where), and put it in a list. Is that ...
0
votes
1answer
265 views

User permission from Content database

I am having copy of content database from client. Now i need to find permission level for particular user using SQL query. Is it possible?
0
votes
2answers
1k views

Infopath querying secondary datasource based on fields in main data connection

So based on a field in my form, i want to execute a sql query when that field changes. Ive set up the data connection, but as far as i can see, the connection is static and there is no way to ...
0
votes
1answer
48 views

MOSS 2007 SqlDataSource

could you please help, where can I find information, how can I set ODBC SqlDataSource on an aspx page, if I cannot edit the Web.Config file probably due to security reasons? Is there any inline-code ...
0
votes
2answers
362 views

Calendar data's storage in SQL

Hi I would like to know in which db and table the datas for sharepoint calendar ? I need to have a reading access to these datas with another application write in php.
0
votes
1answer
319 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
1answer
232 views

Where does sharePoint store Web application information so we can report full site collection URLs in a SQL report?

I know MS does not support SQL commands against SharePoint Databases. But we are just reading data using SQL and SSRS so no harm to be done. I have SQL Syntax that querys every content DB WEBS table ...
0
votes
2answers
822 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 ...
2
votes
3answers
203 views

Custom TimerJob SQL Access?

Im trying to access an SQL database from a custom TimerJob, but it fails. Without hitting the Exception, it just stops. I got the exact line where it get stuck: SqlDataReader sqlReader = ...
1
vote
1answer
807 views

Looking up a value in SQL to set a value on the InfoPath Form

Looking up a value in SQL to set a value on the InfoPath Form. I have a data connection setup in my form. If I use this connection alone, in a control by itself, it pulls in data from my SQL server. ...
0
votes
3answers
7k views

SharePoint 2010 - Database Schema

I´m searching for informations about the SharePoint 2010 Database. Are there infomations about the different tables/views etc.? I don´t found any documents about the SharePoint 2010 Databases on msdn ...
2
votes
1answer
1k views

Creating an external list from SQL query using BCS

I'm developing a visualization application on SharePoint Enterprise 2010. This involves doing some SQL queries I would love to expose as external lists in SharePoint. All interfacing with the database ...