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
145 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
77 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
20 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
250 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
273 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
63 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
1answer
635 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
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
3answers
7k 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
296 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
28 views

Is it possible to run/ install sharepoint on MySQL

as in the titel you can read, I wonder if it is possible to install and run sharepoint (does not matter what version) on an other SQL-Plattform than Microsoft? For example: MySQL, Oracle SQL, etc. ...
0
votes
2answers
25 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
69 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
1answer
64 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
273 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
196 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
112 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
4k 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
2k 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
25 views

Export(or map) List data to external MSSQL table

There is much information about External Lists - when You make a Sharepoint list from SQL database table. In my case I need reverse operation - I have list, and want to map it to external SQL table, ...
0
votes
2answers
44 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
113 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
51 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
367 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
84 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
350 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
111 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
402 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 ...
0
votes
2answers
83 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
2answers
942 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
1answer
211 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
1answer
24 views

Call SQL procedure from Workflow - Sharepoint 2013

Is there a way to call an procedure stored on SQL server from SharePoint 2013 workflow?
0
votes
1answer
12 views

Copy-SPSite destination database size issue

I am using the Copy-SPSite command to copy a site collection to an other site collection (differente contentDB). The source contentDB is around 50GB, but during the copy the size of the target content ...
0
votes
1answer
14 views

Create Design Package - Access Denied

I need to create a design package for a site collection, but when I try to create it (from Design Manager), I get a 403 Forbidden Error I am site collection administrator.
0
votes
0answers
10 views

InfoPath - SQL as Secondary Datasource - Limit Results

I have limited InfoPath experience, mostly using as SQL table UI. I am now trying to create a SharePoint form that will capture data from a SQL table. In dev environment I have been able to add the ...
0
votes
2answers
26 views

Bind SQL data with SharePoint Gridview

I'm developing a SharePoint solution, In an Application Page, I want to place SPGridView and I have to bind it with SQL server data. Is it possible and if yes, how?
0
votes
0answers
17 views

What happens in the background(sql content db) when a version history is deleted?

i am trying to research a scenario of what is happening in the background (sql) when we delete a version history? i am trying to use an sql profile but Im getting confused with all that logs that ...
0
votes
0answers
16 views

Install the ADOMD.NET setup on SharePoint Database server

One question related to the PerformancePoint feature: If I install the ADOMD.NET 10 setup file on the SQL Server 2012 connected with our SharePoint 2013 farm... it will cause any error in the web ...
0
votes
0answers
20 views

How do we consume Sharepoint API methods in SQL server?

As we know we can access the web service in SQL. But then how to consume the Sharepoint API methods in SQL? Can anyone explain with example? I wanted to access ...
0
votes
0answers
29 views

RBS maintainance job Orphan cleanup not working

the problem are that Orphan cleanup won't start up. He starting up. chekcking pools and always stuck on 5 pool. And can delete other pool data. The command I'm runing: > C: cd "C:\Program ...
0
votes
1answer
62 views

SSRS integrated report refreshes after idle time

I’m experiencing an issue with a SSRS 2012 report integrated with SharePoint 2013 and it’s usage in Chrome and Firefox. The issue presents itself when the following conditions are met. 1. User ...
0
votes
0answers
27 views

SharePoint 2013 external content type query

How can I see the SQL query made by an external content type? From Central Admin in the BCS service application I can see the list of all the external content types but not the query.
0
votes
1answer
46 views

Building a GUI in SharePoint 2013

I’m planning on building some business processes that use SQL as the data source and allow SharePoint 2013 users to interact with the data. I’m not sure how to give the users a GUI inside SharePoint. ...
0
votes
0answers
29 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 ...
0
votes
0answers
12 views

How to retrieve site data from SharePoint on cloud and store them at SQL server

I currently use SharePoint on cloud at Microsoft 365 and need to retrieve few data including site title(name), site URL, site owner and also its parent site and subsite title and owner ...
0
votes
0answers
16 views

RBS Configuration on another content database Fail

I faced a problem while configuring RBS on another content database after installing it on a content database. The problem is that inside the log file I found the expression "Configuration completed ...
0
votes
1answer
18 views

SharePoint reporting services integration

I am using the SharePoint report services integration. I deployed a report to a document library, but when I try to view the report (form SP), I receive this error: login failed for user 'nt ...