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
3answers
1k 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: ...
1
vote
1answer
498 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 ...
1
vote
2answers
2k views

Moving Sharepoint Foundation 2010 from SQL Express 2008 R2 to SQL Server 2008 R2

We have a very small Sharepoint Foundation 2010 farm with a library and some workflows. We want to build this originally on one server using SQL Server Express 2008 R2. However, there is a chance ...
1
vote
1answer
123 views

Getting information from different lists (SQL Style)

Is it possible to do something like an SQL query within SP Designer workflows? e.g I want to do something like "SELECT * FROM list-a WHERE client-id = current-clients-id". or can someone suggest a ...
0
votes
3answers
6k 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 ...
0
votes
3answers
213 views

Caching expensive query to use in a Web Part

I have a Web Part that connects to a SQL server and pulls summary data for the current user. (Think "dashboard".) Unfortunately this query is expensive to run so I'd like to cache the results to ...
0
votes
2answers
18 views

Efficiency of SQL updates/queries versus dealing with lists

I'm doing a lot of operations on very large custom lists, comparing them to SQL tables and updating items in the lists based on those tables. Currently this is a pretty slow process because it takes ...
0
votes
2answers
66 views

How to describe all content from the list in SQL

I must do Data Warehouse from my lists in Sharepoint. I need to connect to the Sharepoint and get all elements from the list and Show them in MS SQL Serwer 2008 R2. I need to show them in another ...
0
votes
2answers
931 views

SQL 2008 R2 standard vs enterprise

From a SharePoint Enterprise perspective what do you miss If you use SQL Standard?
0
votes
1answer
40 views

How to get “.sql” files to be searchable in SharePoint Foundation 2013?

What sort of black magic and secret handshakes do I need to do to get .sql files searchable with SP Foundation 2013? Specifically, how do I get files with the ".sql" extension be both indexed and ...
0
votes
1answer
73 views

Where are List View definitions stored?

Where can I find the raw definition within the Content database of a View on one of my Lists. I've found the list in AllLists and the View, I think, in AllDocs. But from there the trail is cold. I ...
0
votes
1answer
57 views

SQL TempDB size

I've read it on a number of different sources, and saw it presented by multiple people at different events: "Temp DB should be pre-sized to 20% of your biggest content" As I'm doing a 2010 farm ...
0
votes
3answers
83 views

Application pool identity account giving login error for sharepoint search page

I am getting a "Login failed for user " error when try to search on my SharePoint site. The site is loading fine, but its the search page thats throwing the error. Event viewer info Process ...
0
votes
2answers
2k views

Recommended SQL Server 2008 R2 instance features for Sharepoint Foundation 2010

Are there any recommended SQL Server 2008 R2 instance features for Sharepoint Foundation 2010 please? Is there any specific SQL feature that should be enabled please?
0
votes
1answer
30 views

Mapping a different SQL server to a SP farm

I want to map a new SQL server and content DBs to my SP farm. What are the steps to achieve this and what are the things i have to take care off?
0
votes
2answers
117 views

How to deploy an EventReceiver which writes to SQL Server correctly

following scenario. I have a client machine on which I have all the permissions for: SQL-databases (db_owner) Full access to a Sharepoint Application. Created a Sql-account (db_owner) and included ...
0
votes
1answer
57 views

SharePoint DB Server - CPU usage 1 to 5%. RAM is almost 100% at all the time [closed]

On the SQL server box. I bumped the RAM to 24 GB and allocated 20GB for SQL Server. Now the performance looks like attached print shot. I see there is barely 1 GB RAM available and only 31 Free. Is ...
0
votes
1answer
148 views

Give users access to BDC using SQL Authentication

I have a web part using an external list through an external content type which uses Business Data Connectivity with SQL Server Authentication through the use of a Secure Store Service key. ...
0
votes
2answers
73 views

Creating a search box in SharePoint that will search an external database

Is there a way to create a search box in SharePoint that searches an external SQL database that is connected to SharePoint?
0
votes
1answer
212 views

Export all of Sharepoint 2010 data (list, webapp data, etc. )

I need to export all of Sharepoint 2010 data (list, webapp data, etc.) in to a easy to import file. Meaning I have "SiteName" with lists and webapp data, and I need all the information of that site in ...
0
votes
2answers
65 views

Help embedding asp.net page in a Sharepoint Web Part

First off, I do not have access to designer, so I'm attempting this through my SharePoint site's on-page edit tools. I realize that this may not be possible, but I'll ask the question anyway. :) I ...
0
votes
2answers
861 views

Live-sync MSSQL DB <--> Sharepoint List

My experience with SharePoint is not really sophisticated so please bear with me. What I want to do is setting up a live-sync between a SharePoint list and a database table. This live-sync should be ...
0
votes
1answer
38 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 ...
0
votes
1answer
20 views

Custom message for those who don't have access

How can I provide a custom message to a user who doesn't have access to a folder in Microsoft Online SharePoint? Appreciation in advance.
0
votes
1answer
30 views

Is it possible to deploy a Sharepoint Foundation content database to Azure SQL Services?

We are starting a new project and to be costly effective we need to use Sharepoint Foundation 2013. We are planning to deploy both Sharepoint and Database to cloud. For Sharepoint we will use a ...
0
votes
0answers
22 views

What do I have to consider when modifying 'wss_minimaltrust.config'?

I have an issue which makes me go mad for quite a while. It probably has to do with permissions and CAS. In the referenced question I explained that I tried out a number of approaches, running against ...
0
votes
1answer
34 views

How to grab a value from cache and pass it to an SQL Stored Procedure

I am designing a website that queries an SQL database when opened, providing a list of bills for the given user. I am using a custom SQL query with a Data Source/Data View and in the Command & ...
0
votes
0answers
22 views

How do I use Sharepoint 2010 as an SQL backend for web content?

Given web pages hosted in a SharePoint 2010 document library, what is the simplest way to use SP as an SQL backend such that some Javascript on each page could add/query data from a single table on ...
0
votes
0answers
17 views

SQL DB 2008 R2 SP2

We have Principal DB ex: DB1 and Mirror DB ex: DB2. Webanalytics Service App has 2 DB's created ReportingDB and StagingDB. I have noticed that the mirroring has been suspended and not happening for ...
0
votes
1answer
99 views

Limits of Running Foundation, Server 2012, SQL 2012 Express

What are some of the major limitations of using SharePoint Foundation 2013, it's compatibility with Server 2012 Standard, and the limitations of SQL 2012 Express?
0
votes
0answers
129 views

SQL Error: “All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.”

I have a SharePoint 2010 farm (14.0.6114.5000) that is logging a large amount of errors in the event log. It's been happening for a while, longer than I've been with this customer. I've seen a few ...
0
votes
1answer
129 views

Using workflow and BCS to sync external data - CRUD

I'm new to SharePoint and trying to get BCS working with external content. I need to "replicate" native list to an external SQL DB for my project. So I use the crated/changed workflow start options ...
0
votes
0answers
23 views

Sharepoint 2010 enterprise search sql syntax

sorry for the bad English. So i'm using SharePoint 2010 server Enterprise Search and I'm building a custom search webpart and result page. Using the SQL syntax: Select (whatever i need) from scope() ...
0
votes
0answers
22 views

Using SP 2013 web site for getting data from users to MS SQL server

I need some help. How to realise form based functionality. I got about 200 ppl in my workgroup and I need to collect some information from them. All my data stored at MS SQL server and it suppost to ...
0
votes
0answers
22 views

Upgrading SP 2010 site collection to SP 2013 with SQLExpress

I'm in the process of upgrading 2010 - 2013. I have two servers, bith with SQL Express (not my decision). I was wondering what was the best way to move the current 2010 sites to 2013? I have been ...
0
votes
0answers
25 views

Word template with parameters for query

We have a Word template which gets information from a database to fill in some fields (mail merge) but now I want to open this template from a page in sharepoint linked to a person. Now I was ...
0
votes
0answers
16 views

Auto Popluate infopath from SQL2012 with user logged in information

I am building a form to be used in a workflow in sharepoint 2013 for approval of expenses submitted. I have created the form in InfoPath. The problem is I want to auto populate the information in ...
0
votes
1answer
31 views

SQL Select of SharePoint Dates off ? MOSS 2007

Does anybody know what this is about? They seem to be off by a bunch of hours and they look right in SharePoint but not SQL I also see the problem in my Data view Webpart, but it's clearly coming ...
0
votes
0answers
22 views

Where in MS SQL Server 2008 R2 are list content [duplicate]

Where in MS SQL Server 2008 R2 could I find out a content from all lists which I have got in my Site Colection. If I oppen MS SQL Serwer 2008 R2 I see a lot of data bases, but I don't know in which ...
0
votes
1answer
143 views

Set SPBuiltInFieldId.WorkflowInstanceID value

I start worklfow programmaticaly on SPListItem (custom ContentType). When i try to save all fields but "WorkflowInstanceID", its ok. But, item[SPBuiltInFieldId.WorkflowInstanceID] = ...
0
votes
1answer
64 views

Remove entries from dbo.EventReceivers

Can I safely remove Entries in dbo.EventReceivers ? The Problem is that when i'm deploying a Solution i get on the Feature Activation many Errors in the SharePoint Logs like: ...
0
votes
0answers
179 views

SharePoint Foundation, SQL Server Express & Forms Based Authentication

Are there any limitations to use SharePoint Foundation with a SQL Server Express and using Forms Based Authentication to log in?
0
votes
1answer
496 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 length ...
0
votes
0answers
388 views

Moved SQL databases for SharePoint 2010 and now have a 3351 error

I moved the SQL databases from a local instance to a remote SQL server. All permissions are the same. Everything seems to work but now I'm getting a 3351 SQL error every 30 minutes from the local ...
0
votes
1answer
2k views

How to stop SQL time out issue

I keep getting "System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." 9 out of 10 times when I try to ...
0
votes
1answer
179 views

Error 5214 only when trying to add a Web Part Page from “More Options”

I can add anything else, new site, new library, etc. When I try to add a new webpart page I get an error. Event log is 5214 insufficient SQL permissions. The EXECUTE permission was denied on the ...
-1
votes
1answer
2k views

Emptying SharePoint Recycle Bin

Our SharePoint 2007 installation has a particularily immense First-Stage Recycle Bin. I wrote a PowerShell script a while back that deletes old items. Just for fun, that's posted below. UPDATE2: ...