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
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 ...
4
votes
3answers
3k 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 ...
0
votes
2answers
57 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
358 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: ...
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
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 ...
1
vote
1answer
114 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
1k 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
827 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
168 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
238 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
176 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
2k 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
203 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 ...
1
vote
0answers
53 views

Display and update data column of type time in sharepoint

I have an sql server data table with a column of type time(0). I need to display columns of this table on a sharepoint page, including the time-column. Users must be able to read and update rows. What ...
3
votes
4answers
387 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 ...
7
votes
3answers
308 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 ...
1
vote
4answers
2k 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 ...
0
votes
1answer
171 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
2answers
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: ...
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
490 views

Searching Pages Library using FullTextSqlQuery

Can anybody please point me in the right direction of searching the Pages library using FullTextSqlQuery? I've successfully instanced a new FullTextSqlQuery and have dealt with all of the necessary ...
3
votes
4answers
924 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?
0
votes
2answers
895 views

SQL 2008 R2 standard vs enterprise

From a SharePoint Enterprise perspective what do you miss If you use SQL Standard?
3
votes
3answers
219 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
2answers
186 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 ...
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 ...
1
vote
2answers
461 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
1answer
475 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 ...
5
votes
2answers
233 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 ...
1
vote
3answers
651 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
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 ...
3
votes
1answer
321 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 ...
4
votes
2answers
951 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 ...
2
votes
0answers
234 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 ...