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
79 views

500 Internal error - Timeout expired

I am getting "500 Internal Server" error while accessing my webapplication in SharePoint 2010. After some tracing I found that the actual error is : "Timeout expired. The timeout period elapsed ...
0
votes
1answer
15 views

SharePoint Workflows and Lists, External Housing Dilemma

So I have a client who has arranged for their SharePoint environment to be housed and managed to by an external entity (not my contracting group) and we have limited access to administrative ...
0
votes
2answers
84 views

Is it possible to run/ install sharepoint on MySQL

as in the title you can read, I wonder if it is possible to install and run SharePoint (does not matter what version) on an other SQL-Platform than Microsoft? For example: MySQL, Oracle SQL, etc. ...
0
votes
1answer
234 views

Call SQL procedure from Workflow - Sharepoint 2013

Is there a way to call an procedure stored on SQL server from SharePoint 2013 workflow?
0
votes
1answer
76 views

Copy-SPSite destination database size issue

I am using the Copy-SPSite command to copy a site collection to an other site collection (differente contentDB). The source contentDB is around 50GB, but during the copy the size of the target content ...
3
votes
1answer
153 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 ...
0
votes
1answer
57 views

Create Design Package - Access Denied

I need to create a design package for a site collection, but when I try to create it (from Design Manager), I get a 403 Forbidden Error I am site collection administrator.
0
votes
0answers
79 views

InfoPath - SQL as Secondary Datasource - Limit Results

I have limited InfoPath experience, mostly using as SQL table UI. I am now trying to create a SharePoint form that will capture data from a SQL table. In dev environment I have been able to add the ...
0
votes
2answers
116 views

Bind SQL data with SharePoint Gridview

I'm developing a SharePoint solution, In an Application Page, I want to place SPGridView and I have to bind it with SQL server data. Is it possible and if yes, how?
0
votes
0answers
30 views

What happens in the background(sql content db) when a version history is deleted?

i am trying to research a scenario of what is happening in the background (sql) when we delete a version history? i am trying to use an sql profile but Im getting confused with all that logs that ...
0
votes
0answers
32 views

Install the ADOMD.NET setup on SharePoint Database server

One question related to the PerformancePoint feature: If I install the ADOMD.NET 10 setup file on the SQL Server 2012 connected with our SharePoint 2013 farm... it will cause any error in the web ...
-1
votes
1answer
29 views

Sharepoint Versions table

I have a question about the table above, versions. The information in usernames is that the user who installed the update/roll up/first installation? Kind Regards
0
votes
2answers
112 views

Conceptually, how are lists different from SQL tables?

Total noob question here, but I've just started learning Sharepoint, having only had .NET experience in the past and I'm trying to understand conceptually the difference between a list and just an SQL ...
0
votes
0answers
52 views

How do we consume Sharepoint API methods in SQL server?

As we know we can access the web service in SQL. But then how to consume the Sharepoint API methods in SQL? Can anyone explain with example? I wanted to access ...
0
votes
0answers
113 views

RBS maintainance job Orphan cleanup not working

the problem are that Orphan cleanup won't start up. He starting up. chekcking pools and always stuck on 5 pool. And can delete other pool data. The command I'm runing: > C: cd "C:\Program ...
1
vote
2answers
422 views

How to restore SharePoint from SQL backups?

I have been tasked with restoring our SharePoint instance for our Disaster Recovery Procedure. We store our backups of SharePoint onto tape via Netvault, we use the SQL plugin and also backup the ...
0
votes
1answer
78 views

Building a GUI in SharePoint 2013

I’m planning on building some business processes that use SQL as the data source and allow SharePoint 2013 users to interact with the data. I’m not sure how to give the users a GUI inside SharePoint. ...
1
vote
0answers
86 views

I have a list built on external content using bdc with a custom filter, I get the data but not the filter

SPD 2013, SP Enterprise 2013, SQL 2008 So I have a BDC connector setup with a SQL backend, I then built a Exernal Content List off that. I then inserted a content control webpart and inserted some ...
2
votes
0answers
113 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 ...
0
votes
0answers
19 views

RBS Configuration on another content database Fail

I faced a problem while configuring RBS on another content database after installing it on a content database. The problem is that inside the log file I found the expression "Configuration completed ...
1
vote
2answers
151 views

Enabling RBS on more than content database (Different site collection)

I am trying to enable RBS on different content database but first the RBS that I installed was installed by wizards, not using cmd as mentioned in the msdn article about installing and configuring ...
2
votes
1answer
210 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.
0
votes
1answer
26 views

SharePoint reporting services integration

I am using the SharePoint report services integration. I deployed a report to a document library, but when I try to view the report (form SP), I receive this error: login failed for user 'nt ...
6
votes
4answers
6k 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
0answers
37 views

Access full URL (including domain) from SQL

I'm aware MS recommends PowerShell etc but I'm using TSQL (nolock). Everywhere I'm looking in the database I'm seeing "sites/something" rather than "http://domain-one.com/sites/something". The only ...
1
vote
1answer
29 views

SP 2010 , SP 2013 and SQL Database

Can Sharepoint 2010 and Sharepoint 2013 use the same database (SQL 2012) ?
1
vote
3answers
219 views

Sharepoint 2010 and 2013 on same SQL Server

We have a Sharepoint 2013 installed with SQL database Cluster and our old Sharepoint 2010 databases should also be moved to the new SQL database Cluster but not migrated to Sharepoint 2013. I have ...
0
votes
1answer
22 views

Move SharePoint 2007 databases

I have a SQL 2008 server I need to migrate the SharePoint databases to a new SQl 2008r2 server. Not heavily used, I believe I want to do the following: 1.Shutdown SharePoint 2.backup the databases ...
0
votes
1answer
3k 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: ...
0
votes
1answer
392 views

SQL Server Developer edition and SharePoint

Can you use SQL Server Developer Edition with SharePoint 2013? Would each service account need a license? Has anyone done this before?
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 ...
0
votes
0answers
80 views

SharePoint Transaction Log Size in High Availability Group

I know SharePoint Config transaction logs tends to grow quickly when in Full Recovery mode, we have been cleaning it out by swapping the database recovery to simple mode, running a backup, the ...
0
votes
2answers
5k 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 ...
1
vote
1answer
28 views

Is there a good way to connect to a SQL Server using Windows authentication from a Sharepoint 2010 event hander?

Inherited some legacy code that makes use of SQL authentication which I want to eliminate. When I tried using Windows auth, the connection seemed to be getting created using ANONYMOUS LOGIN. is there ...
0
votes
2answers
34 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
1answer
212 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
116 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 ...
1
vote
2answers
3k 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
1answer
69 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
0answers
46 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
2answers
468 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
109 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
1answer
131 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 ...
2
votes
2answers
534 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: ...
0
votes
1answer
594 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 ...
1
vote
0answers
50 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
460 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
432 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
79 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
1answer
560 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 ...