SQL or Structured Query Language is a special-purpose programming language designed for managing data in relational database management systems (RDBMS).
7
votes
3answers
176 views
Is it recommended to store high volume transaction data in SharePoint Lists?
I need to devise a solution strategy for an internal application that will take inputs from rfid tags and those records will to be stored "somewhere". Now this somewhere needs to be choice a between a ...
5
votes
2answers
186 views
How to move SQL user database to SharePoint?
I have a SQL and a Access database which I need to import to SharePoint. These database contains information collected from my Internet site like registration info, usernames etc.
Is this possible ...
4
votes
2answers
2k views
CAML vs LINQ vs SQL
So
LINQ is a front end to CAML so of course CAML is faster, and CAML is a front end to SQL so of course SQL is faster.
However what would be a good test to see where and when to use each of these on ...
4
votes
2answers
595 views
WSS_Logging Database Recovery Model
I'm looking for best practice advice when setting the SQL recovery model for the WSS_Logging database in SharePoint Foundation 2010. We currently have this database set to use the "Simple" recovery ...
3
votes
4answers
334 views
Simple SQL Query Problem
When performing a FullTextSQLQuery against my SharePoint site's document library and retrieving field 'Path', I occasionally get the likes of "Forms/DispForm.aspx?ID=45" returned at the end of a ...
3
votes
4answers
710 views
What is the recommended way to query data on a Sharepoint site?
Say if I need to retrieve list items for batch processing, how would I be recommended to retrieve the data? Maybe Powershell or a SQL Server query?
3
votes
1answer
216 views
SqlException when trying to access sharepoint site
I have a local sharepoint server 2010. I'm able to browse through the pages, go to the backend etc. But when it comes to the point that something needs to be written into the SQL-DB (e.g. upload a ...
3
votes
3answers
164 views
Can I use EntityFramework and sql azure with Sharepoint Online?
I would like to connect to an entity model from a sandboxed webpart in sharepoint online. Is this possible?
Is it possible to connect to sql azure from a sandboxed webpart?
3
votes
2answers
170 views
View SQL Queries/times for page request
SharePoint 2010 has the fancy new developer dashboard where you can view the SQL queries made and how long they took to determine bottlenecks etc.
I am not a SQL Sysadmin so I cannot use SQL profiler ...
2
votes
2answers
110 views
Use sharepoint 2007 as database for an ASP.NET MVC 4 application
I have built an ASP.NET MVC 4 C# application that has Many to One relationships. The application currently uses SQL as data provider. The following is the data connection string I use:
<add ...
2
votes
3answers
467 views
Programmatically adding SharePoint Lists to external SQL database
I need to export a SharePoint list to an external SQL database. My initial idea is to open the list as a datatable and bulk update. I created a console app I can run anytime I need to sync the data. ...
2
votes
0answers
182 views
Business Data Connector List Column not working BDC XML Definition
I have a BDC connected to a SQL Table with 2500 Rows. I'm able to add a Business Data List WP to a page and point it to the BDC source and it look fine except for limited number of Rows.
However, if I ...
1
vote
4answers
900 views
Find Database Column Names for List Columns
I am attempting to create a Database View derived from Sharepoint List Data in Sharepoint 2010.
Currently to do this I have simply added a new List Item with Unique values, and manually mapped the ...
1
vote
2answers
365 views
Update a list via SQL with MOSS2007?
How can I go about applying an update statement to a on MOSS2007 deployment?
Essentially I'd like to write something similar to the following across it:
update <list_name>
set ...
1
vote
3answers
490 views
SharePoint 2010 - Generate reports from SharePoint Database?
It is possible to generate reports from the SharePoint Database with informations like current users, teamsites, websites etc. ?
I heard maybe it is possible with the WSS-Logging Database.
Are there ...
1
vote
2answers
66 views
IBM DB2 database connect to Sharepoint
We have an IBM DB2 database which stores our documents as BLOBS in binary format.
I've read about Remote Blob Storage(RBS) and FILESTREAM but I'm still puzzled if its possible to hook up our IBM DB2 ...
1
vote
3answers
516 views
Locked Row in database for key on Infopath Submission for Contribute Permission + below w/ Custom Event Reciever (ItemUpdating)
Basic Rundown of Process: I am creating a Process wherein an InfoPath form is Submitted to a Library, certain managers will then have the ability to change a drop-down to either Approved or Rejected, ...
1
vote
2answers
231 views
Sharepoint - Changing Database Server Name
Our Sharepoint Database Server will be moved to a new server, can someone please advise where we need to make the changes so that it points to the new server?
Any help will be highly appreciated as ...
1
vote
1answer
410 views
Searching Pages Library using FullTextSqlQuery
Can anybody please point me in the right direction of searching the Pages library using FullTextSqlQuery? I've successfully instanced a new FullTextSqlQuery and have dealt with all of the necessary ...
1
vote
1answer
48 views
SharePoint 2010 backup: differential size almost as big as full
My question is similar to this one except my full and differentials do not happen as often. I do a full once a week and a differential on weekday evenings. My differential backups at the beginning ...
1
vote
1answer
38 views
Filling an SP column with SQL data
As part of an internship assignment, I'm working with SharePoint 2013. I'm completely new to SharePoint in general.
Part of this assignment is a labeling system. The idea is that users can add labels ...
1
vote
1answer
187 views
Bind 2 External Content Types (2 tables in SQL database) to 2 drop down lists and have 1 update the contents of the other?
I have 2 tables in my database called "Meetings" and "Items", items belong to a meeting.
I've created the external content types with sharepoint designer and bound them to drop down lists ("Meetings" ...
1
vote
1answer
116 views
SharePoint list updation using powershell script from sql trigger
I need to update a SharePoint list whenever a datachange happens in the sql cuastom table. I am trying achieve this by writting a trigger in the sqltable and calling PowerShell script to update list ...
1
vote
0answers
43 views
Display and update data column of type time in sharepoint
I have an sql server data table with a column of type time(0). I need to display columns of this table on a sharepoint page, including the time-column. Users must be able to read and update rows.
What ...
1
vote
3answers
758 views
Site Collection Not Selectable in Central Administration After Moving Site Using SQL .bak File
I've inherited a SharePoint site as sql .bak file. I took the following steps to create the site:
Create a Web Application
Create a root site (no template)
Delete the default database: ...
1
vote
1answer
366 views
Error with credentials installing SQL 2008 R2 PowerPivot on SharePoint 2010 Front End
Scenario: We have a server farm that consists of (2) back-end servers, (2) web front-ends that are accessed via the internal network, and (2) web front-ends that are accessed from outside the network ...
1
vote
2answers
2k views
Moving Sharepoint Foundation 2010 from SQL Express 2008 R2 to SQL Server 2008 R2
We have a very small Sharepoint Foundation 2010 farm with a library and some workflows. We want to build this originally on one server using SQL Server Express 2008 R2.
However, there is a chance ...
1
vote
1answer
113 views
Getting information from different lists (SQL Style)
Is it possible to do something like an SQL query within SP Designer workflows?
e.g I want to do something like "SELECT * FROM list-a WHERE client-id = current-clients-id".
or can someone suggest a ...
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
3answers
52 views
Caching expensive query to use in a Web Part
I have a Web Part that connects to a SQL server and pulls summary data for the current user. (Think "dashboard".) Unfortunately this query is expensive to run so I'd like to cache the results to ...
0
votes
2answers
639 views
SQL 2008 R2 standard vs enterprise
From a SharePoint Enterprise perspective what do you miss If you use SQL Standard?
0
votes
2answers
32 views
Help embedding asp.net page in a Sharepoint Web Part
First off, I do not have access to designer, so I'm attempting this through my SharePoint site's on-page edit tools. I realize that this may not be possible, but I'll ask the question anyway. :)
I ...
0
votes
3answers
553 views
Live-sync MSSQL DB <--> Sharepoint List
My experience with SharePoint is not really sophisticated so please bear with me.
What I want to do is setting up a live-sync between a SharePoint list and a database table.
This live-sync should be ...
0
votes
2answers
573 views
Recommended SQL Server 2008 R2 instance features for Sharepoint Foundation 2010
Are there any recommended SQL Server 2008 R2 instance features for Sharepoint Foundation 2010 please? Is there any specific SQL feature that should be enabled please?
0
votes
2answers
34 views
Workflows and SQL Server Databases
Is it possible to create a workflow that is started by activity in a SQL Server database that is outside of SharePoint?
Using a WebPart to put and modify data in a database isn't a problem. ...
0
votes
1answer
19 views
Set SPBuiltInFieldId.WorkflowInstanceID value
I start worklfow programmaticaly on SPListItem (custom ContentType).
When i try to save all fields but "WorkflowInstanceID", its ok. But,
item[SPBuiltInFieldId.WorkflowInstanceID] = ...
0
votes
1answer
19 views
Remove entries from dbo.EventReceivers
Can I safely remove Entries in dbo.EventReceivers ?
The Problem is that when i'm deploying a Solution i get on the Feature Activation many Errors in the SharePoint Logs like:
...
0
votes
0answers
90 views
SharePoint Foundation, SQL Server Express & Forms Based Authentication
Are there any limitations to use SharePoint Foundation with a SQL Server Express and using Forms Based Authentication to log in?
0
votes
1answer
107 views
The index entry exceeds the maximum length
I have been receiving this error:
The index entry of length <> bytes for the index '<>' exceeds the maximum length of <> bytes. The index entry of length for the index exceeds maximum length ...
0
votes
0answers
51 views
BCS and SQL Server error messages
I'm using the BCS for reading/writing to a database. It all works well but a problem I have is that the DB uses various constraints to enforce data integrity.
If someone e.g., tries to insert some ...
0
votes
0answers
98 views
Moved SQL databases for SharePoint 2010 and now have a 3351 error
I moved the SQL databases from a local instance to a remote SQL server. All permissions are the same. Everything seems to work but now I'm getting a 3351 SQL error every 30 minutes from the local ...
0
votes
0answers
17 views
Simple SQL field query
Is it possible to get the guid of the web in which a 'record' from a sql query belongs to? So for example, say I bring back a document in my sql query - is there a field available against this record ...
0
votes
1answer
311 views
How to stop SQL time out issue
I keep getting "System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." 9 out of 10 times when I try to ...
0
votes
0answers
54 views
Basic breakdown for use of SQL Reporting Services
I would like to utilize SQL Reporting Services (SQL Server 2008 R2) to generate charts based on list information within my site collection. I am looking for a basic guide on how to configure an ...
0
votes
0answers
249 views
SharePoint 2010 configured for Windows and Forms Based Authentication issue with SQL Report Builder
I have a report library in a SharePoint 2010 (SP1) site configured for both Windows and Forms Based Authentication. SQL Report Services 2008 R2 is configured on the same machine using SharePoint ...
0
votes
1answer
107 views
Error 5214 only when trying to add a Web Part Page from “More Options”
I can add anything else, new site, new library, etc.
When I try to add a new webpart page I get an error.
Event log is 5214 insufficient SQL permissions.
The EXECUTE permission was denied on the ...
0
votes
2answers
1k views
Emptying SharePoint Recycle Bin
Our SharePoint 2007 installation has a particularily immense First-Stage Recycle Bin. I wrote a PowerShell script a while back that deletes old items. Just for fun, that's posted below.
UPDATE2:
...
0
votes
0answers
147 views
Export attachment from SP 2010 list to SQL Server 2008 R2
CAVEAT: This was all done by an external party before I started with the company.
We have a sharepoint list (source) that is exported to a sql server database table (destination) in order to perform ...
0
votes
1answer
859 views
How to link two tables from SQL Server Database to a SharePoint List?
How can I link two tables from an External SQL server database to a SharePoint list and also send emails from it.
