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
0answers
32 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
0answers
10 views

SQL queries in sleeping status - sp_who [on hold]

I am monitoring SQL servers using Shinken (Nagios-like system) and it is reporting me more than 400 connected users on one of my SQL server. This is a development farm so it is not used at all. When ...
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.
1
vote
1answer
43 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 ...
1
vote
1answer
23 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 ...
0
votes
0answers
20 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 ...
1
vote
1answer
23 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 ...
0
votes
0answers
23 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 ? ...
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 ...
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
117 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. ...
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
75 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
64 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
72 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
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
74 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 ...
1
vote
1answer
88 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 ...
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
57 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
70 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
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 ...
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
44 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
55 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
2answers
87 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
0answers
58 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
56 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
46 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
19 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
143 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
77 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
25 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 ...
3
votes
0answers
61 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 ...
0
votes
1answer
45 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
0answers
19 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
1answer
94 views

Get rid of Duplicates in SQL Report Drop down Parameter (SharePoint Report embedded)

Is it possible to have a drop down parameter only show a unique value if I have multiple values? If I have 5 items with 123, I only want 123 to show up once in the drop down. Currently I have a ...
1
vote
2answers
38 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 ...
1
vote
2answers
505 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 : ...