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
312 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
1answer
138 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 ...
1
vote
0answers
60 views

Mounting content database from 2010 to 2013 murders Views and Indexes in the Database

Well this is fun. I have content database from a SharePoint 2010 and I´m trying to mount it on my SharePoint 2013 SP1 farm. At around 26% I get a the error Mount-SPContentDatabase : Operation ...
0
votes
0answers
393 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
380 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 ...
4
votes
4answers
915 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. ...
1
vote
1answer
39 views

Performance: SQL query vs SPListItemCollecion

A project I'm working on has me pulling lots of data from another SQL database (via a c# webpart) and I'm curious about the best approach to make it as speedy as possible. The two thoughts I had were ...
2
votes
2answers
226 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 ...
1
vote
0answers
168 views

InfoPath 2013 form causes “Server out of memory” error when viewing list item

I have a rather large (200+ field) InfoPath form on a custom list that is full of drop-downs referencing other lists on the same site, along with some textboxes and checkboxes. There's not much in the ...
1
vote
4answers
1k 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, ...
1
vote
1answer
140 views

Sharepoint 2013 Workflow question (using to publish text in various SQL Data Bases), is possible?

First Question: I Need Create one workflow to publish news, and other texts in other SQL. Is it possible? The workflow is: Step One: The Writer send the text with the sharepoint blog (for ...
6
votes
1answer
684 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 ...
0
votes
0answers
25 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() ...
1
vote
2answers
208 views

SharePoint 2010 backup: differential size almost as big as full

My question is similar to this one except my full and differentials do not happen as often. I do a full once a week and a differential on weekday evenings. My differential backups at the beginning ...
4
votes
1answer
2k 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 ...
3
votes
3answers
206 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 ...
2
votes
3answers
231 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 ...
0
votes
0answers
592 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
79 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
314 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
69 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 ...
1
vote
1answer
1k views

How to link two tables from SQL Server Database to a SharePoint List?

How can I link two tables from an External SQL server database to a SharePoint list and also send emails from it.
1
vote
2answers
81 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 ...
0
votes
2answers
105 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?
1
vote
2answers
218 views

SP_Admin SQL Permissions

I'm trying to create a web application using powershell and I'm getting a log in error with the SP_Admin account. I'm not sure if I've made a mistake when I was setting up the environment, I might ...
0
votes
3answers
110 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 ...
3
votes
1answer
74 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 ...
1
vote
0answers
73 views

Migrate documents from SQL Server to SharePoint document library with the meta data?

I'm new in SharePoint and I have a requirement to migrate millions of documents stored as BLOB's in SQL Server to a new SharePoint Document library. Can you suggest the best approaches for the same?
0
votes
1answer
33 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 ...
2
votes
0answers
241 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 ...
0
votes
1answer
388 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 ...
3
votes
1answer
251 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 ...
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 ...
1
vote
2answers
1k 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 ...
2
votes
1answer
311 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 ...
1
vote
0answers
19 views

Re-using SQL instance for multiple farms

During a transition phase of indeterminate length, I will be hosting the databases for a SP2012 farm and an unrelated SP2013 farm on the same physical hardware. I know that the guidance for mixing SP ...
0
votes
2answers
80 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 ...
1
vote
2answers
813 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 ...
0
votes
1answer
184 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
85 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
3answers
7k 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
276 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 ...
1
vote
1answer
225 views

Filling an SP column with SQL data

As part of an internship assignment, I'm working with SharePoint 2013. I'm completely new to SharePoint in general. Part of this assignment is a labeling system. The idea is that users can add labels ...
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
2answers
929 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
0answers
194 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?
1
vote
1answer
265 views

Bind 2 External Content Types (2 tables in SQL database) to 2 drop down lists and have 1 update the contents of the other?

I have 2 tables in my database called "Meetings" and "Items", items belong to a meeting. I've created the external content types with sharepoint designer and bound them to drop down lists ("Meetings" ...
2
votes
2answers
299 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
2answers
3k 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 ...
1
vote
1answer
265 views

SharePoint list updation using powershell script from sql trigger

I need to update a SharePoint list whenever a datachange happens in the sql cuastom table. I am trying achieve this by writting a trigger in the sqltable and calling PowerShell script to update list ...