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
17 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 ...
2
votes
1answer
817 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
32 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
14 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
56 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
98 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
53 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
18 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 ...
0
votes
1answer
2k views

Updating a SharePoint list via an Access query and VBA code exhausts system resources

My apologies: I asked this on StackOverflow already but have received no responses. I am hoping that reposting on a site more oriented to SharePoint might lead to more insight. For reasons beyond my ...
0
votes
1answer
67 views

Custom message for those who don't have access

How can I provide a custom message to a user who doesn't have access to a folder in Microsoft Online SharePoint? Appreciation in advance.
0
votes
1answer
80 views

Is it possible to deploy a Sharepoint Foundation content database to Azure SQL Services?

We are starting a new project and to be costly effective we need to use Sharepoint Foundation 2013. We are planning to deploy both Sharepoint and Database to cloud. For Sharepoint we will use a ...
0
votes
1answer
83 views

How to grab a value from cache and pass it to an SQL Stored Procedure

I am designing a website that queries an SQL database when opened, providing a list of bills for the given user. I am using a custom SQL query with a Data Source/Data View and in the Command & ...
0
votes
1answer
374 views

Limits of Running Foundation, Server 2012, SQL 2012 Express

What are some of the major limitations of using SharePoint Foundation 2013, it's compatibility with Server 2012 Standard, and the limitations of SQL 2012 Express?
0
votes
1answer
33 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
1answer
813 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
votes
1answer
23 views

Sharepoint Versions table

I have a question about the table above, versions. The information in usernames is that the user who installed the update/roll up/first installation? Kind Regards
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
68 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
272 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
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
63 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
218 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
83 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
65 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
8 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
12 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
19 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
33 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
24 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
24 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
29 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
51 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
30 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
36 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
21 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
18 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
26 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
54 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
38 views

SQL Union of two task lists in Access - how to get the correct “Assigned to”?

As you all probably know, a Sharepoint task list has an "Assigned To" column. When I import a task list, I get a table for the list and another table, "UserInfo" with the users for that list. When I ...
0
votes
0answers
39 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
26 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
201 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
721 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 ...