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

2
votes
1answer
17 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: ...
1
vote
0answers
29 views

Are third party solutions really that superior to BCS?

Let us assume it is my task to establish a bidirectional connection between a SharePoint List and a SQL-database. According to Paolo Pialorsi's Developer Manual for SharePoint 2010, BCS (Business ...
0
votes
1answer
37 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
24 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
41 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
19 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
33 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
49 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 ...
1
vote
1answer
29 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
63 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
36 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
1answer
42 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
336 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
17 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() ...
7
votes
9answers
556 views

Content database size vs site collection size

We have one rather large content database in our environment. In this content database, a single site collection resides. In Central Admin, this site collection lists as being 464699 MB big. Since ...
4
votes
1answer
321 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 ...
2
votes
3answers
82 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
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 ...
3
votes
3answers
99 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 ...
0
votes
0answers
17 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
1answer
50 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
86 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. ...
1
vote
2answers
61 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
59 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
0answers
24 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 ...
3
votes
0answers
1k 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 ...
1
vote
2answers
75 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
72 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
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 ...
3
votes
1answer
53 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
38 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?
2
votes
0answers
175 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
163 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 ...
2
votes
1answer
165 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
1answer
28 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
47 views

changing SQLDATASOURCE SelectCommand in codeblock on SharePoint 2007 page?

I need to pass current user (in domain\user format) to a SQLDATASOURCE on a sharePoint 2007 page. Options? Is something like this possible? Cant seem to get it to work. <script runat="server"> ...
0
votes
0answers
125 views

SPServices Search - select first x items using sql type query?

I am using the SPServices library to make search requests in Sharepoint 2010 using this code: queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'>"; queryText += ...
0
votes
2answers
64 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
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
455 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 ...
0
votes
0answers
59 views

WebParts and SQL Server Tables

My new project requires me to create some 12 SQL tables and build some web parts in SharePoint 2010, to perform CRUD operation on the tables. One main table has around 25 columns and the rest of the ...
2
votes
1answer
132 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
15 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 ...
1
vote
2answers
797 views

Workflows and SQL Server Databases

Is it possible to create a workflow that is started by activity in a SQL Server database that is outside of SharePoint? Using a WebPart to put and modify data in a database isn't a problem. ...
0
votes
2answers
58 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
366 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
126 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
52 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: ...
1
vote
2answers
140 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 ...
0
votes
3answers
190 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 ...