SQL or Structured Query Language is a special-purpose programming language designed for managing data in relational database management systems (RDBMS).
1
vote
1answer
53 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
188 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" ...
0
votes
1answer
116 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
1answer
337 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
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 ...
2
votes
0answers
184 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
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 ...
0
votes
0answers
7 views
Re-using SQL instance for multiple farms
During a transition phase of indeterminate length, I will be hosting the databases for a SP2012 farm and an unrelated SP2013 farm on the same physical hardware. I know that the guidance for mixing SP ...
0
votes
0answers
100 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
0answers
52 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
104 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
0answers
55 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
0answers
148 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 ...
