Questions tagged [sql]

SQL or Structured Query Language is a special-purpose programming language designed for managing data in relational database management systems (RDBMS).

Filter by
Sorted by
Tagged with
8
votes
4answers
9k views

CAML vs LINQ vs SQL

So LINQ is a front end to CAML so of course CAML is faster, and CAML is a front end to SQL so of course SQL is faster. However what would be a good test to see where and when to use each of these on ...
7
votes
3answers
830 views

Is it recommended to store high volume transaction data in SharePoint Lists?

I need to devise a solution strategy for an internal application that will take inputs from rfid tags and those records will to be stored "somewhere". Now this somewhere needs to be choice a between a ...
6
votes
1answer
2k views

SQL Injections with SharePoint 2010 CAML Queries

IBM Appscan has detected that some pages in our system are vulnerable to SQL Injection. The report shows which URLs are vulnerable, so I checked the pages based on the URLs, but most of the pages ...
6
votes
2answers
285 views

How to move SQL user database to SharePoint?

I have a SQL and a Access database which I need to import to SharePoint. These database contains information collected from my Internet site like registration info, usernames etc. Is this possible ...
4
votes
4answers
721 views

Simple SQL Query Problem

When performing a FullTextSQLQuery against my SharePoint site's document library and retrieving field 'Path', I occasionally get the likes of "Forms/DispForm.aspx?ID=45" returned at the end of a ...
4
votes
2answers
2k views

WSS_Logging Database Recovery Model

I'm looking for best practice advice when setting the SQL recovery model for the WSS_Logging database in SharePoint Foundation 2010. We currently have this database set to use the "Simple" recovery ...
4
votes
2answers
3k 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. ...
4
votes
1answer
4k views

Errors executing bulk query when updating a Sharepoint Linked List from Access

I have a Sharepoint list that is a Linked List with MS Access (2010). It has just under 5,000 items (4,864), thus meaning it avoids the reduction in functionality lists of greater than 5,000 items ...
4
votes
1answer
85 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 ...
4
votes
1answer
334 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 ...
4
votes
4answers
1k views

Programmatically adding SharePoint Lists to external SQL database

I need to export a SharePoint list to an external SQL database. My initial idea is to open the list as a datatable and bulk update. I created a console app I can run anytime I need to sync the data. ...
4
votes
0answers
9k 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 ...
3
votes
4answers
1k views

What is the recommended way to query data on a Sharepoint site?

Say if I need to retrieve list items for batch processing, how would I be recommended to retrieve the data? Maybe Powershell or a SQL Server query?
3
votes
3answers
481 views

Sharepoint 2010 Configuring Database Connections without using alias

After migrating all SharePoint databases to a new SQL Server, how can I configure SharePoint to to reference the new SQL Server without using an Alias? The reason we need to avoid using an Alias is ...
3
votes
1answer
1k views

SqlException when trying to access sharepoint site

I have a local sharepoint server 2010. I'm able to browse through the pages, go to the backend etc. But when it comes to the point that something needs to be written into the SQL-DB (e.g. upload a ...
3
votes
1answer
57 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 (...
3
votes
1answer
152 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 ...
3
votes
1answer
283 views

What to do when SharePoint Lists and SSRS isn't enough?

I've developed a complicated InfoPath web form for reporting outages. This system will be maintained by someone with little technical skill, so in a lot of places the form populates its dropdowns from ...
3
votes
1answer
4k 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 ...
3
votes
1answer
101 views

Are documents in SP2010 saved directly to MS SQL Database

When I Upload a document e.g. Word or Excel documents to a document list. Are the files saved directly binary to an SQL database? If yes, could someone give me a url by MS, where I can find further ...
3
votes
1answer
359 views

Context Aware BCS Model for Search Crawling in SharePoint 2013

I have an external SQL data source that I would like to include in SharePoint search crawling with a BCS/BDC model. As it stands, SharePoint sees this data independently of the SharePoint site ...
3
votes
3answers
366 views

Can I use EntityFramework and sql azure with Sharepoint Online?

I would like to connect to an entity model from a sandboxed webpart in sharepoint online. Is this possible? Is it possible to connect to sql azure from a sandboxed webpart?
3
votes
0answers
275 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 ...
3
votes
2answers
202 views

View SQL Queries/times for page request

SharePoint 2010 has the fancy new developer dashboard where you can view the SQL queries made and how long they took to determine bottlenecks etc. I am not a SQL Sysadmin so I cannot use SQL profiler ...
2
votes
2answers
214 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 ...
2
votes
1answer
941 views

Accessing data from another web application throws an SQLInvalidException

The scenario is: A MySiteHost site collection (example name: MY SITE). Web application's application pool account is spmysite. A TeamSite site collection (example name: TEAM SITE). Web application's ...
2
votes
5answers
3k views

Locked Row in database for key on Infopath Submission for Contribute Permission + below w/ Custom Event Reciever (ItemUpdating)

Basic Rundown of Process: I am creating a Process wherein an InfoPath form is Submitted to a Library, certain managers will then have the ability to change a drop-down to either Approved or Rejected, ...
2
votes
1answer
26 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 "...
2
votes
3answers
700 views

SP 2010 Modifying the “Last Modified By” column in SQL Management Studio

Let me preface by saying that I have read this page by Microsoft: http://support.microsoft.com/kb/841057/en-us I have not understood it completely which is why I am here, We are currently in a tough ...
2
votes
2answers
7k views

Sharepoint - Changing Database Server Name

Our Sharepoint Database Server will be moved to a new server, can someone please advise where we need to make the changes so that it points to the new server? Any help will be highly appreciated as I'...
2
votes
1answer
279 views

Site traffic SQL query?

Is it possible to query a SQL DB to find out most accessed page, information on the user ( country of orgin etc ). I need this for 2010 and 2013.
2
votes
1answer
20 views

Is there a way to tell if SharePoint was installed using a SQL Alias?

I know that a SQL Alias is listed now but I would like to find out if SharePoint was installed while specifying that alias during the install. On the 'Servers in Farm' page, I see both a SQL Alias ...
2
votes
3answers
401 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 ...
2
votes
2answers
1k views

How to choose the right datatype when creating external content types?

assuming I want to create a SPList using external content types, in my case SQL server tables. When I create my ECT in Sharepoint Designer 2010 SQL data types are mapped to the List as follows: ...
2
votes
2answers
54 views

Attach Database Failed SQL Error

I have a .mdf file which contains more than 30 GB data. On trying to attach this to SQL on one of our standalone dev servers (with independent database), I am getting the following error message : "...
2
votes
1answer
722 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 ...
2
votes
1answer
1k views

Call SQL procedure from Workflow - Sharepoint 2013

Is there a way to call an procedure stored on SQL server from SharePoint 2013 workflow?
2
votes
2answers
1k views

2010: How to connect to a SQL database on the same SQL server as the SharePoint databases?

In the code behind of an application page, I need to query a SQL table from a database which is on the same server and instance as the SharePoint content and config databases. Is there an easy way to ...
2
votes
2answers
641 views

Use sharepoint 2007 as database for an ASP.NET MVC 4 application

I have built an ASP.NET MVC 4 C# application that has Many to One relationships. The application currently uses SQL as data provider. The following is the data connection string I use: <add name="...
2
votes
3answers
4k views

Site Collection Not Selectable in Central Administration After Moving Site Using SQL .bak File

I've inherited a SharePoint site as sql .bak file. I took the following steps to create the site: Create a Web Application Create a root site (no template) Delete the default database: Remove-...
2
votes
1answer
785 views

Error with credentials installing SQL 2008 R2 PowerPivot on SharePoint 2010 Front End

Scenario: We have a server farm that consists of (2) back-end servers, (2) web front-ends that are accessed via the internal network, and (2) web front-ends that are accessed from outside the network (...
2
votes
0answers
17 views

Create, read, and update from SQL table to on-prem SharePoint 2016?

Ultimately I would like to create an external list that can be customized (i.e., partly columns from a SQL table and partly native SharePoint columns). BCS isn't an option because it would not let me ...
2
votes
1answer
295 views

SharePoint 2016: Transaction (Process ID 58) was deadlocked on lock resources

I receive the following error when attempting to create a new SharePoint 2016 Configuration db in SQL 2017. PS command and Error: The local farm is not accessible. Cmdlets with FeatureDependencyId ...
2
votes
0answers
36 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 ...
2
votes
1answer
107 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 ...
2
votes
1answer
39 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.
2
votes
1answer
742 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 ...
2
votes
0answers
276 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
1answer
11k 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 ...
2
votes
0answers
341 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 property....