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

0
votes
1answer
22 views

Performance Issue - Using Access to Update Field in SharePoint

I would like to use MS Access to update one field on a SharePoint list. I run into serious performance issues with MSAccess locking up for +15 minutes. Are there steps I can take to optimize the query ...
0
votes
0answers
10 views

Importing multiple lists with lookups

I have a legacy database that was originally written in SQL Server 7 and then upgraded to SQL 2000. My client would like to now use Sharepoint Online to manage this database. There are 25 tables and ...
1
vote
0answers
40 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 ...
0
votes
2answers
90 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
1answer
13 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 ...
2
votes
1answer
16 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.
0
votes
1answer
4k 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 ...
1
vote
1answer
44 views

Where do I get started on building an HTML5 form in SharePoint?

Working on a project to build an HTML5 form within SharePoint that will read and write to a SQL database. Can't find much online about how to get this implemented. I am very well versed in HTML and ...
2
votes
1answer
2k 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
25 views

Simple Question - Is it possible to Edit SQL Tables from SharePoint form

The title about says it all. I've developed in Access for 20+ years. I've held off learning SharePoint because everything I've read seems to indicate restrictions on true data management. So... here ...
1
vote
2answers
523 views

SP 2013 How to create new FBA sql users with PowerShell?

I set up SharePoint 2013 with FBA users (SQL). I'd like to know if it's possible to create new users using PowerShell script ? What I tried but did not work : ...
1
vote
1answer
25 views

Workflow farm infrastructure

We are planning on building a Workflow farm to use with an existing SharePoint 2013 farm. We have 7 servers in total split between 2 physical locations: Location 1: Server 1, Server 2, Server 3, ...
0
votes
0answers
33 views

In SharePoint lists - how add a field that gets data from a database connection?

Background: We have SharePoint lists that contain user requests for compilation of software, various regression testing, and other tasks. They automatically cause start of these tasks. I need to add ...
2
votes
1answer
24 views

SiteCollection not available after the DB was moved into a different volume/drive by DB Admin

I ran the below command to create a NewSiteCollection and new DB for Legal Team Add-PSSnapIn Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue; New-SPContentDatabase ...
0
votes
0answers
25 views

Expose list or document through ODBC connection

I've seen a few things on Data Connection Libraries and BCS on how to bring content from external databases into SharePoint, but what I am looking for is the other way around. We have a SAP server ...
1
vote
2answers
53 views

if i want to free some space on my Dev machine can i shrink the WSS Logging database

I am working on my Dev machine, and i am running out of space, now i check the WSS Logging database and i find that it have 34% of its size as a free space :- so are there any harm if i shrink it ? ...
1
vote
2answers
43 views

Conflict Content Databases names inside my sharepoint farm

I am using SharePoint server 2013, and i am facing problems on understanding how to manage my SharePoint content databases:- currently i have a single content database, with name = ...
2
votes
2answers
55 views

Add entries to AllUserData from SQL

I have been tasked with having our application make entries into our customer's Sharepoint database. I have found the table where I think these entries are stored ("AllUserData"), but there are ...
0
votes
2answers
123 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
0answers
29 views

SharePoint 2010 not Accessible

My complete SharePoint 2010 site is not accessible. However, the admin site is. The database is still OK. Error: Cannot open database "WSS_Site_Content" requested by the login. The login failed. ...
1
vote
4answers
8k 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 ...
4
votes
1answer
52 views

How to retrieve all list/library which uses custom content type in a site collection?

How to retrieve all list/library which uses custom content type or a custom column in a site collection? It would be really helpful if you post your answers in C# code or SQL query. Please let me ...
0
votes
1answer
79 views

SQL Server Reporting Services Service Application Encryption Error

I'm trying to create a new SQL Server Reporting Services Service Application, I go in and set all my settings and the application creates just fine. But when I click on the service application i ...
1
vote
2answers
65 views

BCS, can I connect a result of SQL query to external database in SharePoint list?

Can I connect a result of SQL query to external database in SharePoint list? As I understand - External Content types could map only one table for list, but I need to get some combined data from few ...
0
votes
1answer
74 views

insert value from sharepoint list to SQL table

I have list with approx 20000 items, and want to push that into sql table. Can anyone help me with c# code. Thanks
0
votes
1answer
15 views

Foundation, Designer and SQL Database in a Virtual Enviornment

Are there any good tutorials that show you how to set up a web server, SharePoint 2010 Foundation & Designer as well as a database in a virtual environment (i.e VirualBox). I would like to learn ...
0
votes
1answer
1k 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 ...
0
votes
0answers
9 views

One SQL PowerPivot instance for SharePoint for two separate SharePoint Farms?

Can I use one SQL PowerPivot instance for SharePoint for two separate SharePoint Farms? I use SharePoint 2013 SP1 and SQL 2012.
1
vote
1answer
28 views

Do I need to drop database before doing SP-remove?

I'm currently testing doing some stuff on a site collection with a console app. I'd like to redo the test by deleting and then restoring the site collection, but I'm not sure if I need to delete ...
0
votes
0answers
76 views

Event ID 5586, error seems related to search

The following error is being thrown every few minutes 24/7: Unknown SQL Exception 201 occurred. Additional error information from SQL Server is included below. Procedure or function ...
2
votes
1answer
73 views

“Sorry this site hasn't been shared with you” for root URL only after migrating to new SQL server

All I found a couple other posts related to my issue but they did not lead to any solutions and my backstory is a bit different. Backstory: We have a 2013 farm that we use for test/development. The ...
1
vote
1answer
90 views

How to solve error with comments paging on blog site?

We have a news functionality in SP2013 based on the blog site template. The problem occurs when a post receives more than 10 comments: SharePoint adds a paging button (the left and right arrows) in ...
1
vote
1answer
34 views

Upload data stored in external SQL database

I want to upload some data which is stored in external SQL database to SharePoint database and it should reflect in forms under SharePoint.
0
votes
1answer
1k 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 ...
1
vote
1answer
59 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?
0
votes
0answers
24 views

Configuring Sharepoint Server 2013 connect to SQL server using child Active Directory domain user

I'm having a problem with the initial configuration of SharePoint. I'm unable to connect to my SQL user account which is integrated in a child Active Directory domain, like this format: ...
0
votes
1answer
69 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 ...
2
votes
1answer
71 views

Is it possible to import user profile from an external source, not from active directory

How do I import user profile directly from an external source (SQL database) without using active directory? The common usual solution is to have a SharePoint privilege account that have the ...
0
votes
1answer
284 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
0answers
91 views

Multiple Inner Joins CAML query

I'm trying to convert the following SQL statement to a CAML query: SELECT t.Id, t.Name, t.CustomerId FROM Ticket AS t INNER JOIN Customer AS ...
0
votes
1answer
45 views

Unable to connect to SQL on aspnet_regsql.exe

I have a standalone environment, and I am trying to configure FBA on my local machine, I ran aspnet_regsql.exe, and it said it's unable to connect to SQL. The account am using is the sp_admin ...
0
votes
1answer
56 views

How can I determine the size and file type of items stored in a content database?

I'm a SQL Server person, and I'm wondering why one of our SharePoint content databases suddenly shot up to 600GB. I suspect we're adding larger documents, rather than more. Is there a SQL query I can ...
0
votes
0answers
59 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
46 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
0answers
58 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 ...
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 ...
0
votes
0answers
48 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
1answer
20 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
154 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
0answers
81 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 ...