SQL or Structured Query Language is a special-purpose programming language designed for managing data in relational database management systems (RDBMS).

learn more… | top users | synonyms

1
vote
2answers
181 views

Enabling RBS on more than content database (Different site collection)

I am trying to enable RBS on different content database but first the RBS that I installed was installed by wizards, not using cmd as mentioned in the msdn article about installing and configuring ...
1
vote
3answers
247 views

Sharepoint 2010 and 2013 on same SQL Server

We have a Sharepoint 2013 installed with SQL database Cluster and our old Sharepoint 2010 databases should also be moved to the new SQL database Cluster but not migrated to Sharepoint 2013. I have ...
1
vote
1answer
250 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 ...
1
vote
1answer
43 views

Where do I get started on building an HTML5 form in SharePoint?

Working on a project to build an HTML5 form within SharePoint that will read and write to a SQL database. Can't find much online about how to get this implemented. I am very well versed in HTML and ...
1
vote
1answer
88 views

How to solve error with comments paging on blog site?

We have a news functionality in SP2013 based on the blog site template. The problem occurs when a post receives more than 10 comments: SharePoint adds a paging button (the left and right arrows) in ...
1
vote
2answers
510 views

How to restore SharePoint from SQL backups?

I have been tasked with restoring our SharePoint instance for our Disaster Recovery Procedure. We store our backups of SharePoint onto tape via Netvault, we use the SQL plugin and also backup the ...
1
vote
1answer
29 views

SP 2010 , SP 2013 and SQL Database

Can Sharepoint 2010 and Sharepoint 2013 use the same database (SQL 2012) ?
1
vote
1answer
48 views

Performance: SQL query vs SPListItemCollecion

A project I'm working on has me pulling lots of data from another SQL database (via a c# webpart) and I'm curious about the best approach to make it as speedy as possible. The two thoughts I had were ...
1
vote
2answers
421 views

SP_Admin SQL Permissions

I'm trying to create a web application using powershell and I'm getting a log in error with the SP_Admin account. I'm not sure if I've made a mistake when I was setting up the environment, I might ...
1
vote
2answers
4k 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. ...
1
vote
2answers
266 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
309 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
570 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
1k 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.
1
vote
0answers
32 views

How to resolve SharePoint 2010 Error Event 5586 - Some part of your SQL statement is nested too deeply.

The SharePoint 2010 server is returning some error message on Windows Event Viewer and SharePoint logs. Windows Event Viewer is returning the following error message: Event 5586, SharePoint ...
1
vote
1answer
23 views

Simple Question - Is it possible to Edit SQL Tables from SharePoint form

The title about says it all. I've developed in Access for 20+ years. I've held off learning SharePoint because everything I've read seems to indicate restrictions on true data management. So... here ...
1
vote
1answer
25 views

Workflow farm infrastructure

We are planning on building a Workflow farm to use with an existing SharePoint 2013 farm. We have 7 servers in total split between 2 physical locations: Location 1: Server 1, Server 2, Server 3, ...
1
vote
1answer
57 views

how to import data from sql database to a sharepoint list

i would need to import 2 columns of data from a SQL database into a SharePoint list? is there a way to easily import data from a sql database to a SharePoint list?
1
vote
0answers
27 views

Who is updating my database?

I have a custom solution (FARM level) which is deploying webpart to my site collection. This webpart has a textbox, which is writing to custom database (Nothing to do with content DB) Now, while ...
1
vote
2answers
38 views

Backup from SP 2013 on SQL 2014 to be restored on SP 2013 on SQL 2012

I need to backup a SP 2013 site with SQL 2014 to be restored on SP 2013 with SQL 2012. I currently have a content DB backup but it is not working because of the different versions. Will it work if i ...
1
vote
1answer
38 views

Sharepoint 2010 - frequently freezes

We have serious problem with Sharepoint 2010 - system freezes for some minutes (2, 5, 10, 15..). This may occur once or twice a day, but may be 2 - 3 hours successively. CPU usage on SQL Server drops ...
1
vote
0answers
94 views

I have a list built on external content using bdc with a custom filter, I get the data but not the filter

SPD 2013, SP Enterprise 2013, SQL 2008 So I have a BDC connector setup with a SQL backend, I then built a Exernal Content List off that. I then inserted a content control webpart and inserted some ...
1
vote
1answer
28 views

Is there a good way to connect to a SQL Server using Windows authentication from a Sharepoint 2010 event hander?

Inherited some legacy code that makes use of SQL authentication which I want to eliminate. When I tried using Windows auth, the connection seemed to be getting created using ANONYMOUS LOGIN. is there ...
1
vote
0answers
52 views

Are third party solutions really that superior to BCS?

Let us assume it is my task to establish a bidirectional connection between a SharePoint List and a SQL-database. According to Paolo Pialorsi's Developer Manual for SharePoint 2010, BCS (Business ...
1
vote
0answers
83 views

Mounting content database from 2010 to 2013 murders Views and Indexes in the Database

Well this is fun. I have content database from a SharePoint 2010 and I´m trying to mount it on my SharePoint 2013 SP1 farm. At around 26% I get a the error Mount-SPContentDatabase : Operation ...
1
vote
0answers
331 views

InfoPath 2013 form causes “Server out of memory” error when viewing list item

I have a rather large (200+ field) InfoPath form on a custom list that is full of drop-downs referencing other lists on the same site, along with some textboxes and checkboxes. There's not much in the ...
1
vote
1answer
192 views

Sharepoint 2013 Workflow question (using to publish text in various SQL Data Bases), is possible?

First Question: I Need Create one workflow to publish news, and other texts in other SQL. Is it possible? The workflow is: Step One: The Writer send the text with the sharepoint blog (for ...
1
vote
0answers
101 views

Migrate documents from SQL Server to SharePoint document library with the meta data?

I'm new in SharePoint and I have a requirement to migrate millions of documents stored as BLOB's in SQL Server to a new SharePoint Document library. Can you suggest the best approaches for the same?
1
vote
0answers
23 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
1answer
336 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
307 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
75 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
2k 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
2answers
3k 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
124 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
2answers
87 views

Is it possible to access a MYSQL database table from a sharepoint hosted app?

I'm alittle confused, when I google this all i seem to find is how to connect to sharepoint using a cloud hosted app hosted in windows azure, that's not what I'm looking for. I've been creating Java ...
0
votes
3answers
358 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
103 views

Is it possible to run/ install sharepoint on MySQL

as in the title you can read, I wonder if it is possible to install and run SharePoint (does not matter what version) on an other SQL-Platform than Microsoft? For example: MySQL, Oracle SQL, etc. ...
0
votes
2answers
37 views

Efficiency of SQL updates/queries versus dealing with lists

I'm doing a lot of operations on very large custom lists, comparing them to SQL tables and updating items in the lists based on those tables. Currently this is a pretty slow process because it takes ...
0
votes
2answers
70 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
2answers
1k views

SQL 2008 R2 standard vs enterprise

From a SharePoint Enterprise perspective what do you miss If you use SQL Standard?
0
votes
2answers
117 views

How to grant user DB_Owner on all SharePoint 2013 databases

For many admin tasks for SharePoint 2013 using PowerShell you need to have DB_Owner for all SharePoint databases. The Add-SPShellAdmin command no longer granted DB_Owner to the SharePoint databases, ...
0
votes
1answer
157 views

How to get “.sql” files to be searchable in SharePoint Foundation 2013?

What sort of black magic and secret handshakes do I need to do to get .sql files searchable with SP Foundation 2013? Specifically, how do I get files with the ".sql" extension be both indexed and ...
0
votes
1answer
683 views

Where are List View definitions stored?

Where can I find the raw definition within the Content database of a View on one of my Lists. I've found the list in AllLists and the View, I think, in AllDocs. But from there the trail is cold. I ...
0
votes
1answer
494 views

SQL TempDB size

I've read it on a number of different sources, and saw it presented by multiple people at different events: "Temp DB should be pre-sized to 20% of your biggest content" As I'm doing a 2010 farm ...
0
votes
3answers
145 views

Application pool identity account giving login error for sharepoint search page

I am getting a "Login failed for user " error when try to search on my SharePoint site. The site is loading fine, but its the search page thats throwing the error. Event viewer info Process ...
0
votes
2answers
5k 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
2answers
3k 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
1answer
69 views

import user profile directly from an external source (`SQL database`) without using active directory?

Pertaining to SharePoint 2013, How do I import user profile directly from an external source (SQL database) without using active directory? is it possible to start the User Profile Synchronization ...
0
votes
1answer
20 views

Change sharepoint database in the same machine

I installed sql server 2012 on windows server 2008 R2 and sharepoint server 2013 stand alone, but there was sql server 2008 r2 on the server and it seems that my sharepoint database installed on ...