Tag Info

Hot answers tagged

5

SharePoint Designer will also expose any views or stored procedures you have. You can set those up for use in the external contenttype. If you go into the data source explorer in sharepoint designer you will see views and routines in the tree under your database. If you can add a view or a stored procedure in SQL, then it will show up there and you can take ...


4

All queries against SharePoint data should be done through the SharePoint Object Model or Web Services. Creating solutions that access the database directly will result in an unsupported installation of SharePoint. Though you have nothing preventing you from doing direct SQL queries, you will not get any support on this site for doing anything that will ...


3

You'll likely want the SharePoint Products and Technologies Protocol Documentation. These contain descriptions about the database structure, including table schema, sprocs, and so forth... Along with a lot of other information. And as everyone else has noted, making changes is, for the most part, unsupported. Check out KB841057 for more information on ...


3

You shouldn't expect SharePoint to work well opening any view with more that 2000/5000 items (depending on SQL server version). What may slow it further down is: Lookup columns (including User and Managed Metadata) Many columns of certain type causing SharePoint to use multiple rows in SQL for each item Many is defined as: 64 Single line of text 32 ...


2

YOU SHOULD NOT MODIFY A CONTENT DATABASE USING SQL Even reading from the content databases is not considered good practice, you may cause locks which will cause SharePoint to fail. The moment you change anything in a SharePoint database (except the usage ones) your SharePoint installation becomes unsupported. Loop through the pages/files using PowerShell ...


2

Don't access the data directly in the SharePoint database. The database structure is difficult to workout and also Microsoft will not support your SharePoint environment if you are reading data straight out the database! As TZHX says use the Web Services or even better use the REST interface or the Client Side Object Model instead. They have been built for ...


2

NEVER READ DIRECTLY FROM THE DATABASES (unless there is no other option) This will probably work with the current patches it might, but it's not documented or guaranteed and even thought it might work now it might stop working if a patch is applied. Have you consider using the change log which is meant exactly for getting things like this? See Using the ...


1

Alexandar, I would suggest you to use a separate Web Service for getting data to InfoPath.. In Web Service, use Object Model to connect database and query! Or, if you can do VSTA Code on InfoPath form (needs administrative approval for InfoPath form, each time you publish the form).. Here is an example: Dynamic SQL Data connection in InfoPath EDIT Seems ...


1

EDIT: Didn't see Per's edit in time! I am going to post this as an answer, but you really should select Per Jackobson's as the accepted answer to the question. Here is how you can check in documents in library using PoSh. You can also used the PowerShell shell window to examine these files a little more closely. Test the code as I am posting from memory... ...


1

The short answer is yes, a custom timer job can access sql server. However in order to work out what your problem is, you'll probably need to provide us with more information. For example you may have an issue with your connection string, permissions on the database you are trying to access etc.



Only top voted, non community-wiki answers of a minimum length are eligible