SQL or Structured Query Language is a special-purpose programming language designed for managing data in relational database management systems (RDBMS).
2
votes
0answers
12 views
Context Aware BCS Model for Search Crawling in SharePoint 2013
I have an external SQL data source that I would like to include in SharePoint search crawling with a BCS/BDC model. As it stands, SharePoint sees this data independently of the SharePoint site ...
-1
votes
0answers
14 views
Get elements from Sharepoint list to MSSQL
I do the Data Warehause and I must take only from one Sharepoint list all elements to the Microsoft Serwer 2008 R2.
How could I read elements from Sharepoint List via MSSQL language. I can't use ...
0
votes
1answer
8 views
SQL Select of SharePoint Dates off ? MOSS 2007
Does anybody know what this is about? They seem to be off by a bunch of hours and they look right in SharePoint but not SQL
I also see the problem in my Data view Webpart, but it's clearly coming ...
0
votes
0answers
8 views
changing SQLDATASOURCE SelectCommand in codeblock on SharePoint 2007 page?
I need to pass current user (in domain\user format) to a SQLDATASOURCE on a sharePoint 2007 page. Options? Is something like this possible? Cant seem to get it to work.
<script runat="server"> ...
0
votes
0answers
12 views
SPServices Search - select first x items using sql type query?
I am using the SPServices library to make search requests in Sharepoint 2010 using this code:
queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'>";
queryText += ...
0
votes
2answers
29 views
How to describe all content from the list in SQL
I must do Data Warehouse from my lists in Sharepoint.
I need to connect to the Sharepoint and get all elements from the list and Show them in MS SQL Serwer 2008 R2. I need to show them in another ...
0
votes
0answers
22 views
Where in MS SQL Server 2008 R2 are list content [duplicate]
Where in MS SQL Server 2008 R2 could I find out a content from all lists which I have got in my Site Colection. If I oppen MS SQL Serwer 2008 R2 I see a lot of data bases, but I don't know in which ...
1
vote
2answers
46 views
HELP URGENT. Out of disk space. Search DB huge. Over 270gb
MOSS 2007.
Disk full on Data drive of SQL Cluster. Search DB over 270gb. DBs are set to simple mode so no transaction logs.
Seeing these event errors:
Event Type: Error
Event Source: Office ...
0
votes
0answers
8 views
Question on KBSQL data extraction [migrated]
I am working on KBS and I am new to it. I have a question on how to extract data from a column,in a table based on a condition and create a new column with that data.
For example : I have columns ...
0
votes
0answers
25 views
WebParts and SQL Server Tables
My new project requires me to create some 12 SQL tables and build some web parts in SharePoint 2010, to perform CRUD operation on the tables. One main table has around 25 columns and the rest of the ...
2
votes
1answer
30 views
Accessing data from another web application throws an SQLInvalidException
The scenario is:
A MySiteHost site collection (example name: MY SITE). Web application's application pool account is spmysite.
A TeamSite site collection (example name: TEAM SITE). Web application's ...
0
votes
0answers
8 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 ...
1
vote
2answers
51 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
2answers
35 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 ...
1
vote
2answers
93 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 ...
0
votes
1answer
30 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
24 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:
...
1
vote
1answer
56 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 ...
0
votes
3answers
59 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 ...
1
vote
1answer
39 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 ...
0
votes
0answers
108 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
130 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 ...
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" ...
2
votes
2answers
123 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 ...
0
votes
0answers
53 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 ...
1
vote
2answers
333 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
120 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 ...
0
votes
0answers
109 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 ...
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
18 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 ...
3
votes
4answers
335 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 ...
1
vote
4answers
975 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 ...
7
votes
3answers
190 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 ...
0
votes
1answer
392 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
3answers
603 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
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
1answer
115 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:
...
4
votes
3answers
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 ...
0
votes
2answers
643 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?
1
vote
1answer
418 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
3answers
568 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, ...
0
votes
2answers
656 views
SQL 2008 R2 standard vs enterprise
From a SharePoint Enterprise perspective what do you miss If you use SQL Standard?
2
votes
3answers
490 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. ...
0
votes
1answer
900 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.
3
votes
3answers
169 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?
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 ...
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 ...
1
vote
3answers
791 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: ...
