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
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
46 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
392 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
3k 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
257 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
304 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
568 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
1answer
38 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
30 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
36 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
87 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
50 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
79 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
304 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
184 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
100 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
22 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
323 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
303 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
70 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
343 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
85 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
34 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
33 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
132 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
597 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
434 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
140 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
47 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 ...
0
votes
1answer
203 views

Export(or map) List data to external MSSQL table

There are many references about External Lists, where you make a Sharepoint list from SQL database table. In my case, I need to do the opposite - I have SharePoint list, and I want to map it to an ...
0
votes
2answers
112 views

Conceptually, how are lists different from SQL tables?

Total noob question here, but I've just started learning Sharepoint, having only had .NET experience in the past and I'm trying to understand conceptually the difference between a list and just an SQL ...
0
votes
1answer
755 views

Restore content database 2013

I am trying to restore a SharePoint site with a backed up content database. I restored the backup of the content database to Sql server, then when i created the web application i entered the restored ...
0
votes
1answer
69 views

Mapping a different SQL server to a SP farm

I want to map a new SQL server and content DBs to my SP farm. What are the steps to achieve this and what are the things i have to take care off?
0
votes
2answers
473 views

How to deploy an EventReceiver which writes to SQL Server correctly

following scenario. I have a client machine on which I have all the permissions for: SQL-databases (db_owner) Full access to a Sharepoint Application. Created a Sql-account (db_owner) and included ...
0
votes
1answer
122 views

SharePoint DB Server - CPU usage 1 to 5%. RAM is almost 100% at all the time [closed]

On the SQL server box. I bumped the RAM to 24 GB and allocated 20GB for SQL Server. Now the performance looks like attached print shot. I see there is barely 1 GB RAM available and only 31 Free. Is ...
0
votes
1answer
530 views

Give users access to BDC using SQL Authentication

I have a web part using an external list through an external content type which uses Business Data Connectivity with SQL Server Authentication through the use of a Secure Store Service key. ...
0
votes
2answers
190 views

Creating a search box in SharePoint that will search an external database

Is there a way to create a search box in SharePoint that searches an external SQL database that is connected to SharePoint?
0
votes
1answer
496 views

Export all of Sharepoint 2010 data (list, webapp data, etc. )

I need to export all of Sharepoint 2010 data (list, webapp data, etc.) in to a easy to import file. Meaning I have "SiteName" with lists and webapp data, and I need all the information of that site in ...