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

2
votes
1answer
1k views

SP2013 Failed to create the configuration database

When installing SP2013 I got this error: Failed to create the configuration database An exception of type Microsoft.Sharepoint.SPException was thrown. Additional exception information: The ...
1
vote
1answer
27 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 ...
0
votes
1answer
24 views

How to import Sharepoint 2013 list to SQL table

How to import Values from Sharepoint 2013 list to SQL table in MSSQL server ? Please tell in different ways to achieve this. In 2010 I was doing by read WSS_Content tables, but in Sharepoint 2013 ...
0
votes
1answer
12 views

Test clone SharePoint and Project Server2010

I am new to this SharePoint and Project server. I have joined an organisation and my luck the Sharepoint guy has left. Now I have to handle these servers and have to migrate them to newer version. ...
0
votes
1answer
29 views

How can I run REST from batch or powershell?

I want to create an item (Title,ID, description) in Mylist by using REST/batch/powershell/SQL store procedure Any reference or information will be appreciated.
0
votes
1answer
29 views

SharePoint code generating SQL, how can I trace this back to my code?

Looks like my SharePoint code is generating SQL, it runs 3 to 4 times per page request. It all adds up to approximately 4 seconds from what I can see on the developer dashboard. I'm using spmonitored ...
0
votes
1answer
42 views

500 Internal error - Timeout expired

I am getting "500 Internal Server" error while accessing my webapplication in SharePoint 2010. After some tracing I found that the actual error is : "Timeout expired. The timeout period elapsed ...
0
votes
1answer
15 views

SharePoint Workflows and Lists, External Housing Dilemma

So I have a client who has arranged for their SharePoint environment to be housed and managed to by an external entity (not my contracting group) and we have limited access to administrative ...
0
votes
1answer
88 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
133 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
1answer
62 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
1answer
20 views

Move SharePoint 2007 databases

I have a SQL 2008 server I need to migrate the SharePoint databases to a new SQl 2008r2 server. Not heavily used, I believe I want to do the following: 1.Shutdown SharePoint 2.backup the databases ...
3
votes
0answers
5k views

We cannot locate a server to load the workbook data model

This is the error that appears when I try to refresh data. I have been struggling with this issue for a few weeks. Researching in internet but with no luck. My sharepoint site is 2013 and SQL Server ...
2
votes
0answers
20 views

Create a SharePoint Farm using SQL Azure

I have an on-premise installation of SharePoint 2013. I need to create a new farm (Using either SharePoint Configuration Wizard or Powershell) in SQL Azure. Using Configuration Wizard, it keeps ...
2
votes
0answers
85 views

Sharepoint 2013 with SQL Authentication

I'm trying to get Sharepoint 2013 to install correctly with SQL Authentication. The domain environment I am running this under, service accounts are not easy to come by and have to be renewed every ...
2
votes
0answers
274 views

How to include custom managed metadata in FullTextSQLQuery searches?

I am using SP2010 and spservices jquery library to make sql search queries to the search service. I created a managed metadata called DocumentGUID which is mapped to the document guid crawled ...
2
votes
0answers
260 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
22 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
0answers
44 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
74 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
235 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
0answers
88 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
21 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
0answers
70 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
11 views

XML column on Sharepoint 2013 list - import to SQL table

I tried to import data from Sharepoint 2013 list to MSSQL. I prepered Query, but if I use Remote Server by Linked Server. But if I use this with Sharepoint 2013 list it giving me Error that can't ...
0
votes
0answers
6 views

XML DataType in Sharepoint 2013 - problem with remote server

If I make Query in MSSQL, and asking the data from sharepoint list I geting this error. I geting this only if i connecting with Remote Server: Msg 9514, Level 16, State 1, Line 28 Xml data type is ...
0
votes
0answers
13 views

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >=

I have got SQL Query: And I getting this error: Msg 512, Level 16, State 1, Line 1 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or ...
0
votes
0answers
15 views

In Sharepoint 2013 AllUserData has been change

Now is written as XML file. Like they told in this article: http://joelblogs.co.uk/2013/02/15/sharepoint-2013-content-databases-and-the-alluserdata-table/ How to use them in SQL ? This field and find ...
0
votes
0answers
7 views

SharePoint Workflow manager SQL Alias

I recently performed a separation of machines (from standalone to small farm). We choose the SQL Alias approach in order to keep everything as it is (I moved SQL Server to a new machine and add an ...
0
votes
0answers
11 views

User can't refresh data in Sharepoint List after SQL View Def changed

I am trying to support a user who uses a SharePoint 'report' (ie Excel SS). The report is based on an SQL Server 2008 View. The view definition was altered to source data from different tables within ...
0
votes
0answers
9 views

SharePoint External Content Type error: An entry has been added to the Windows event log of the server.

I have an External Content Type list connecting an SQL server in SharePoint 2013, and the data is not submitting/saving in the front-end of SharePoint using InfoPath. The error message is the ...
0
votes
0answers
13 views

Stored procedure to retrieve Name given Login Name

I have a hybrid database and SharePoint setup. I store some data inside my custom tables on the database. One of the tables requires a report to be generated based on a stored procedure. I do not ...
0
votes
0answers
26 views

Dashboard in sharepoint online - from list /sql azure datasource

Just wondering if anyone has done this and how did they go? What will be the best way to present a dashboard/charts in sharepoint online from data coming from a list or sql azure? Thanks for any info ...
0
votes
0answers
46 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
0answers
27 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
29 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
36 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
60 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
0answers
32 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
0answers
51 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
23 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
19 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
0answers
29 views

Access full URL (including domain) from SQL

I'm aware MS recommends PowerShell etc but I'm using TSQL (nolock). Everywhere I'm looking in the database I'm seeing "sites/something" rather than "http://domain-one.com/sites/something". The only ...
0
votes
0answers
12 views

remove actions icon from SQL column

I have a column that pull in info from a SQL DB but it has an action icon that I do not want, I have deselected the the display action menu but it is still in the list
0
votes
0answers
29 views

Linq to sql timeout

I have set command timeout property to zero in my code (means it is not limited), but still my timerjob timeouts, how to prevent time outing ? Is there any more actions should I take to increase ...
0
votes
0answers
65 views

SharePoint Transaction Log Size in High Availability Group

I know SharePoint Config transaction logs tends to grow quickly when in Full Recovery mode, we have been cleaning it out by swapping the database recovery to simple mode, running a backup, the ...
0
votes
0answers
40 views

What do I have to consider when modifying 'wss_minimaltrust.config'?

I have an issue which makes me go mad for quite a while. It probably has to do with permissions and CAS. In the referenced question I explained that I tried out a number of approaches, running against ...
0
votes
0answers
27 views

Sharepoint 2010 enterprise search sql syntax

sorry for the bad English. So i'm using SharePoint 2010 server Enterprise Search and I'm building a custom search webpart and result page. Using the SQL syntax: Select (whatever i need) from scope() ...
0
votes
0answers
203 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
765 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 ...