The sql-query tag has no wiki summary.
1
vote
1answer
495 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
4k 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 ...
0
votes
0answers
55 views
Sharepoint list access via SQL query
I need to provide list data to an external system. Once the data has been accessed, we need to write a flag to the list as accessed.
The external system will probably be another SQL Server query. ...
0
votes
1answer
26 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
75 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
220 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
765 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
169 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
457 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
155 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
850 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 ...
