Questions tagged [sql]
SQL or Structured Query Language is a special-purpose programming language designed for managing data in relational database management systems (RDBMS).
251 questions
1
vote
2
answers
3k
views
SharePoint 2013 list in SQL
I have a couple of questions:
Where does SharePoint list stores data in SQL?
Is there article for SP2013 on MSDN or TechNet? - I can find outdated articles which explain table structure for a list ...
- 240
1
vote
0
answers
2k
views
Get the library name from GUID in VBA
I want to pull information from a SharePoint 2016 list in VBA. Below Code is what I found and that is working without depending on a view. Unfortunately the SQL query uses the list Name. A user could ...
2
votes
0
answers
42
views
Attaching an Azure SQL Datebase to Sharepoint Online Provider-hosted Web Forms Add-In
I found this guide but it's specifically made for MVC add-ins. I'm looking for a way of attaching my Azure SQL Datebase to a Web Forms Sharepoint Online add in but I can't find it anywhere.
It was ...
- 65
1
vote
2
answers
788
views
want to convert sql quer to caml
I want to convert my sql query to caml query and my sql query is
sql query:
select Room from hotel where (time between starttime="2:30" and endtime="4:00") and (date between startdate="1/2/017" and ...
- 11
3
votes
1
answer
400
views
SQL Server Max Memory
In our farm, we have 3 servers dedicated for SQL Server and all three are consuming 99% of the memory available. Looking in to it I learned that we didn't change the Max Memory setting in our SQL ...
- 949
0
votes
1
answer
129
views
SP task list data push to SQL
What is my option so my sp task list still push the data to our sql database using the datasheet view? I was told that adding new item to the list triggers an event handler which uploads the data from ...
- 31
1
vote
1
answer
244
views
Add a SQL table for each item in a custom list?
I am fairly new to Sharepoint, so please forgive me if this answer is readily available somewhere, because in my searching I have not encountered the same issue.
Goal:
I have a custom list with ...
- 113
3
votes
1
answer
129
views
Autopopulate sharepoint list using sql
I am using sql to pull data from a specific table, is it possible to autopopulate certain columns in a sharepoint list with this data?
Currently I'm pulling the data and copy pasting into the list (...
- 31
0
votes
1
answer
835
views
Crawl Database Size
So I have a SharePoint 2010 farm. Last month I noticed it was getting unreasonably bigger, everything was working fine though.
Then I noticed that Search_Service_Application_CrawlerStore..... database ...
1
vote
0
answers
50
views
How to pull data on to SP Online from an external source without Azure instance?
I am new to SharePoint Online, so checking is there a way to connect and pull/push data from an external data source like (SQl on prem, Chatter) on to SharePoint Online through BCS or External content ...
- 499
0
votes
1
answer
1k
views
Upgrade SQL Server 2012 to 2014 or 2016 for Sharepoint Server 2016 instance
I have a Windows Server 2012 R2 with Sharepoint Server 2016 installed but the SQL server version is 2012. What do I need to do to upgrade the database to 2014 or 2016. Everything is installed in the ...
- 319
0
votes
1
answer
256
views
How to change web application settings via Powershell or SQL?
Third-party tools like SharePoint Manager allow you to change settings on your web application. I need to toggle the LookupDropDownUseStandardControl from TRUE to FALSE, but SharePoint Manager is not ...
- 1,822
1
vote
0
answers
2k
views
You do not have permission to run the RECONFIGURE statement
I am attempting to upgrade a SP2010 content database to SP2013. Once I get to 100% of the Mount-SPContentDatabase, etc, I am presented with the error:
Mount-SPContentDatabase: user does not ...
- 21
0
votes
1
answer
23
views
SQL configuration for Sharepoint
We are migrating SharePoint 2010 data(100GB) from one company A to company B(After acquisition) creating a new SharePoint 2010 farm.
Company B also has around 100GB data in SP 2007 version which ...
- 161
2
votes
1
answer
2k
views
MS Recommended Reindex of Sharepoint Databases
I find a high level of index fragmentation in many tables of the SharePoint 2013 database (greater than 75%). Documentation appears to indicate that SharePoint Timer should be running tasks to ...
- 133
1
vote
1
answer
358
views
SharePoint Provider hosted app with backend as sql server for CRUD operation
I have a provider hosted app in SharePoint on premise. Is it possible to retrieve data from sql server and crud operation database using app?
- 11
1
vote
1
answer
412
views
How to move web app data between farms
I have SharePoint Prod and Sharepoint Dev farm envirenment,
In my SharePoint Dev I have already "Site1b" an older copy of webapp
"Site1a" from Prod
and I would like to update it How should I proceed?
1
vote
1
answer
485
views
Connect Azure SQL Database to Provider Hosted Add-In
If I have both a provider hosted add-in and an SQL database running on the same Azure server, how do I access the database from within my Sharepoint add-in?
Thank you!
- 434
0
votes
1
answer
58
views
Upgrade my SharePoint 2010 database from 2008 SP1 to 2008R2 SP3
I have SharePoint 2010 running on SQL Server 2008 SP1. I would like to upgrade the database to 2008R2 SP3.
Are there any problems with that?
- 1
1
vote
1
answer
1k
views
Sharepoint Hosted Add-In using External SQL Database
As in the title, I would like to create a Sharepoint hosted add-in that accesses data from an SQL database on my companies database. Is there any way to do this? Thank you!
- 434
0
votes
1
answer
416
views
Sharepoint with mirrored database
i'm tryin to build a lab farm where a sharepoint 2013 server will use a mirrored database. I read lots of stuff but i'm still not sure about the correct installation path.
I would roughly proceed the ...
1
vote
1
answer
145
views
Error Report to SharePoint library
I have configured the reporting service in native mode, add the SQL Server Reporting Services Service application, start the service, I created the data source for the report. But when I try to enter ...
0
votes
1
answer
240
views
Possible to Install Any Version of SharePoint Using SQL Server 2014 Express?
The company I work for is thinking about moving our SharePoint services in-house.
Currently, we have a SharePoint 2010 Foundation site through a remote host and we are considering either moving to ...
1
vote
0
answers
98
views
Can not retrieve sql server routine return parameter schema information
I am trying to create an external content type on Sql stored procedure in sharepoint 2013 and getting the following error:
Invalid Object Name '#...' .Can not retrieve sql server routine return ...
- 83
4
votes
2
answers
6k
views
Suddenly am getting "Cannot open database requested by the login. The login failed."
My virtual machine was working fine, and everything was OK, suddenly, when I tried to connect to central administration, I started having an error saying connection closed and 200 OK http status.
...
0
votes
1
answer
171
views
MOSS 2007 <SharePoint:SPSqlDataSource /> compatibility with SQL Server 2012 version database
We have a MOSS 2007 version sharepoint site, and a database in Sql server 2005 ver (a application specific database with all required tables)
we are accessing the data (by using <SharePoint:...
0
votes
1
answer
40
views
How to use xml definition in SharePoint list which is configured using BCS
I have a SQL database server with 3 columns ID, Location, FileType, I have used BCS service to connect SharePoint with this table.
Now for example Location field is int type something like 19 means ...
- 508
1
vote
2
answers
213
views
How to export Sharepoint 2013 list to SQL Server
Suggest best possible way to add data from SharePoint 2013 list to SQL.
If the suggested option is SSIS please elaborate on how to perform the same, i am not able to find any links or video tutorials ...
- 318
1
vote
2
answers
2k
views
SQL service accounts keep getting Locked out
SQL service accounts keep getting locked out in AD.
I have to unlock them everytime.
What could be the probable cause and a solution?
- 87
0
votes
1
answer
297
views
800+ open connections being caused by SharePoint 2013 crawl?
All are "sleeping". Everything seems to be working fine but need to figure out why there are so many open connections. Any ideas?
CREATE PROCEDURE dbo.proc_MSS_GetNextCrawlBatch @ComponentID int,
...
- 453
0
votes
1
answer
57
views
How to create Sharepoint 2013 list with column entries incrementet by a button for every row
i want to create a list in Sharepoint 2013 where i can manage all my microsoft licenses. I want to be able to increment the number of used licenses after i used one.
So, my licenses are on a ...
1
vote
1
answer
1k
views
List view threshold - over 100,000 items in library
I have a query about the List view threshold on SharePoint 2013 where the limit is set to 5000 items in Central Administration.
We have a document library with 150,000+ items which means currently we ...
- 439
0
votes
1
answer
28
views
SP2013 - Migrate SQL from all in one server to separate servers
I have a SharePoint implementation that was set up (not by me) with everything on one VM, SharePoint and SQL. We now have a requirement to move SQL to a separate server to increase performance and my ...
- 97
1
vote
1
answer
385
views
Dismount and Mount of social DB, Sync DB and Profile DB on SP 2010
We need to mount production DB's of user profile service to Dev environment. We have already restored on SQL dev.
Now our intention, how to dismount existing DB's of user profile service and then how ...
- 105
0
votes
1
answer
292
views
How to create a Sharepoint 2013 form to update a Sharepoint SQL database
I have a SQL database, I have created an External Content Type and an External List for the Table. I can see the list in SharePoint. I would like to be able to change the form to add a new instance ...
- 3
0
votes
1
answer
75
views
Several SharePoint farms using the same clustered SQL Server
In our current infrastructure we have several clients that have their own SharePoint farm hosted on dedicated WFE's and a dedicated SQL Server instance.
We are thinking of moving our hosting to ...
- 1
2
votes
1
answer
166
views
How to get user specific information from content database in SharePoint 2010
I am using SharePoint 2010. I want to know the user specific details i.e. when and by whom a specific user was given permission to the site. My audit logs are disabled in CA.Is it possible to get the ...
- 21
0
votes
1
answer
820
views
infopath udcx error Data adapter failed during OnLoad
I created a UDCX file for data connection using SQL Server authentication in InfoPath form of SharePoint 2010. After that, I created a secure storeId which has credentials stored for SQL ...
- 365
0
votes
2
answers
2k
views
Converting SharePoint list into SQL
I am wondering is it possible to convert a SharePoint list into a SQL query to be used on a different platform. Or even a way to query the data that exists in the list?
2
votes
3
answers
775
views
Configure SP2013 to connect to SQL alias Name after Installation
I have a SP2013 farm which has 1 WFE,1 App Server and 1 SQL. While configuring,SQL Server Name was used to connect to SharePoint(in SharePoint Product configuration Wizard) and CA site has been ...
- 1,522
1
vote
1
answer
1k
views
Internal site works External site gets "Server Error in '/' Application."
Our sharepoint works great on our internal network. We use Sharepoint 2013 and SQLEXPRESS 2012. We have a domain intranet.crkoes.org that we have setup but get this error.
Server Error in '/' ...
0
votes
1
answer
2k
views
SSRS bar-chart do not show the x-axis name when value is zero
We have a Dashboard implemented by SSRS in SharePoint 2010 and data source is a SharePoint list. We have a bar table in which the x-axis is month but when data is zero it doesn't show the month name ...
- 41
0
votes
2
answers
52
views
Migrating content databases
I've just moved one of our SharePoint 2013 environments over to a new SQL server and I tested one of the content databases was able to connect and this was fine but I cannot figure out how to update ...
- 439
0
votes
2
answers
66
views
Database Backup\Restore Not working properly
In my present SharePoint farm what we do is create a web app and restore a previously saved backup of a site to the new one, this is usually done using the PowerShell site collection back\restore ...
- 21
0
votes
2
answers
127
views
Datasheet view export
I am using a datasheet view in sharepoint to manage an excel like sheet that multiple users can modify there data in. right now i export the list manually and upload it to the service provider. I am ...
1
vote
1
answer
109
views
SQL DNS entry for SharePoint farm configuration
To prevent from issues when/if the SQL server fails is it a good idea to create a DNS entry to point to the SQL server instead of using the actual server name when configuring SharePoint 2013?
In ...
- 453
0
votes
1
answer
39
views
Reinstall SQL server in windows server 2012?
I have SharePoint server.
I did mistake to uninstall SQL server so now SharePoint site is also not opening.
so please some one help me how can I reinstall SQL so my existing SharePoint site works ...
- 331
1
vote
0
answers
1k
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 ...
- 135
0
votes
1
answer
423
views
What's the meaning of column Level in table AllDocs?
I know it's not the most orthodox way, but
I am trying to count files in a huge list with a sql straight into the AllDocs table.
I see most files have one row only while
others have one row with ...
- 1,183
2
votes
1
answer
44
views
What happens to External List created using BCS from SQL query once the server goes offline?
If the database gets deleted or somehow goes offline, will the list keep the existing data or will it all be gone due to failed synchronization.
- 23