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

7
votes
3answers
613 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 ...
7
votes
4answers
7k 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 ...
6
votes
1answer
1k 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 ...
5
votes
2answers
257 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
639 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
1answer
3k 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
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 ...
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. ...
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
347 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
710 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
178 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
97 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
318 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
335 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
66 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
0answers
6k 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
2answers
195 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
57 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
5answers
2k 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
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 ...
2
votes
3answers
467 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
1answer
628 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
1answer
215 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
2answers
5k 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 ...
2
votes
2answers
679 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
475 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
517 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 ...
2
votes
1answer
747 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
1answer
19 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
84 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 ...
2
votes
1answer
80 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
137 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
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 ...
2
votes
0answers
302 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
262 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
4answers
5k views

Find Database Column Names for List Columns

I am attempting to create a Database View derived from Sharepoint List Data in Sharepoint 2010. Currently to do this I have simply added a new List Item with Unique values, and manually mapped the ...
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 ...
1
vote
2answers
606 views

Update a list via SQL with MOSS2007?

How can I go about applying an update statement to a on MOSS2007 deployment? Essentially I'd like to write something similar to the following across it: update <list_name> set ...
1
vote
3answers
891 views

SharePoint 2010 - Generate reports from SharePoint Database?

It is possible to generate reports from the SharePoint Database with informations like current users, teamsites, websites etc. ? I heard maybe it is possible with the WSS-Logging Database. Are there ...
1
vote
2answers
574 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
2answers
45 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 = ...
1
vote
2answers
74 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 ...
1
vote
1answer
30 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 ...
1
vote
2answers
104 views

Best practice for taking SharePoint data and putting it into an SQL database?

I need to do some reporting across site collections. In order to do this I intend on writing a service layer that crawls SharePoint and puts information about document libraries and files into an SQL ...
1
vote
2answers
2k views

HELP URGENT. Out of disk space. Search DB huge. Over 270gb

MOSS 2007. Disk full on Data drive of SQL Cluster. Search DB over 270gb. DBs are set to simple mode so no transaction logs. Seeing these event errors: Event Type: Error Event Source: Office ...
1
vote
2answers
1k views

IBM DB2 database connect to Sharepoint

We have an IBM DB2 database which stores our documents as BLOBS in binary format. I've read about Remote Blob Storage(RBS) and FILESTREAM but I'm still puzzled if its possible to hook up our IBM DB2 ...
1
vote
2answers
58 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
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.