A database query can be either a select query or an action query.

learn more… | top users | synonyms

4
votes
1answer
52 views

How to retrieve all list/library which uses custom content type in a site collection?

How to retrieve all list/library which uses custom content type or a custom column in a site collection? It would be really helpful if you post your answers in C# code or SQL query. Please let me ...
2
votes
1answer
2k 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 ...
2
votes
3answers
216 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 = ...
2
votes
1answer
1k 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. ...
1
vote
4answers
8k 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 ...
1
vote
1answer
42 views

How to retrieve all list/library which uses InfoPath forms in a site collection

How to retrieve all list/library which uses InfoPath forms in a site collection? It would be helpful if you post your answers in C# code or SQL query. Thanks
1
vote
0answers
37 views

Retrieve all customized list/library in a site collection [closed]

Is it possible to retrieve all customized lists/libraries in a site collection (C# / SQL query)? By customized, I mean: New columns have been added InfoPath forms are used
0
votes
2answers
293 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
1answer
3k 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
3answers
1k 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 ...
0
votes
2answers
830 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
439 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
912 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
3k 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
0answers
101 views

COLLATE hint behaviour in sharepoint SQL query stack trace

We are having some performance issues with retrieving large sharepoint lists data from database. While looking through a potentially slow query stack trace we found out that the query uses COLLATE ...
0
votes
2answers
110 views

how to connect infoPath form with SQL server in SharePoint 2013?

i have an BCS/external content type in SPD connected to my InfoPath form. I want to insert the data to the SQL table. Therefore, I just the following rules: R1) Query using a data connection: Main ...
0
votes
1answer
301 views

InfoPath form has connection to SQL server, but form data is not being submitted and stored in db table?

I am created one submit rule which it has the action 1) query using a data connection: Main connection 2) set a field's value @fullname = 1. I need help creating a second rule inserting all the field ...
0
votes
1answer
660 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
1answer
63 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 ...
-1
votes
2answers
39 views

How to know that “EnableVersioning” is enabled in any SharePoint 2013 List/Library using SQL Query

I want to know if below proprieties are enabled or disabled for any SharePoint 2013 List/Library. How we can get using SQL Query from ContentDB (AllLists Table), which column I have to use in my ...