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

SharePoint code generating SQL, how can I trace this back to my code?

Looks like my SharePoint code is generating SQL, it runs 3 to 4 times per page request. It all adds up to approximately 4 seconds from what I can see on the developer dashboard. I'm using spmonitored ...
0
votes
0answers
9 views

User can't refresh data in Sharepoint List after SQL View Def changed

I am trying to support a user who uses a SharePoint 'report' (ie Excel SS). The report is based on an SQL Server 2008 View. The view definition was altered to source data from different tables within ...
0
votes
1answer
31 views

Get rid of Duplicates in SQL Report Drop down Parameter (SharePoint Report embedded)

Is it possible to have a drop down parameter only show a unique value if I have multiple values? If I have 5 items with 123, I only want 123 to show up once in the drop down. Currently I have a ...
1
vote
2answers
18 views

Backup from SP 2013 on SQL 2014 to be restored on SP 2013 on SQL 2012

I need to backup a SP 2013 site with SQL 2014 to be restored on SP 2013 with SQL 2012. I currently have a content DB backup but it is not working because of the different versions. Will it work if i ...
1
vote
1answer
115 views

SP 2013 How to create new FBA sql users with PowerShell?

I set up SharePoint 2013 with FBA users (SQL). I'd like to know if it's possible to create new users using PowerShell script ? What I tried but did not work : ...
0
votes
0answers
8 views

SharePoint External Content Type error: An entry has been added to the Windows event log of the server.

I have an External Content Type list connecting an SQL server in SharePoint 2013, and the data is not submitting/saving in the front-end of SharePoint using InfoPath. The error message is the ...
0
votes
0answers
12 views

Stored procedure to retrieve Name given Login Name

I have a hybrid database and SharePoint setup. I store some data inside my custom tables on the database. One of the tables requires a report to be generated based on a stored procedure. I do not ...
0
votes
1answer
17 views

Change sharepoint database in the same machine

I installed sql server 2012 on windows server 2008 R2 and sharepoint server 2013 stand alone, but there was sql server 2008 r2 on the server and it seems that my sharepoint database installed on ...
0
votes
0answers
22 views

Dashboard in sharepoint online - from list /sql azure datasource

Just wondering if anyone has done this and how did they go? What will be the best way to present a dashboard/charts in sharepoint online from data coming from a list or sql azure? Thanks for any info ...
1
vote
1answer
31 views

Sharepoint 2010 - frequently freezes

We have serious problem with Sharepoint 2010 - system freezes for some minutes (2, 5, 10, 15..). This may occur once or twice a day, but may be 2 - 3 hours successively. CPU usage on SQL Server drops ...
0
votes
1answer
36 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
14 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
1answer
69 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
31 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 ...
0
votes
1answer
32 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
38 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 ...
3
votes
1answer
125 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
2answers
48 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
2answers
53 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
0answers
27 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
25 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 ...
0
votes
1answer
41 views

Export(or map) List data to external MSSQL table

There is much information about External Lists - when You make a Sharepoint list from SQL database table. In my case I need reverse operation - I have list, and want to map it to external SQL table, ...
-1
votes
1answer
25 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
58 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
34 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
55 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 ...
0
votes
1answer
119 views

SSRS integrated report refreshes after idle time

I’m experiencing an issue with a SSRS 2012 report integrated with SharePoint 2013 and it’s usage in Chrome and Firefox. The issue presents itself when the following conditions are met. 1. User ...
1
vote
2answers
193 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
0answers
32 views

SharePoint 2013 external content type query

How can I see the SQL query made by an external content type? From Central Admin in the BCS service application I can see the list of all the external content types but not the query.
0
votes
1answer
57 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. ...
0
votes
0answers
44 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 ...
0
votes
0answers
22 views

How to retrieve site data from SharePoint on cloud and store them at SQL server

I currently use SharePoint on cloud at Microsoft 365 and need to retrieve few data including site title(name), site URL, site owner and also its parent site and subsite title and owner ...
2
votes
0answers
78 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
107 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 ...
1
vote
1answer
192 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
21 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 ...
0
votes
0answers
29 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 ...
0
votes
0answers
12 views

remove actions icon from SQL column

I have a column that pull in info from a SQL DB but it has an action icon that I do not want, I have deselected the the display action menu but it is still in the list
1
vote
1answer
28 views

SP 2010 , SP 2013 and SQL Database

Can Sharepoint 2010 and Sharepoint 2013 use the same database (SQL 2012) ?
0
votes
0answers
28 views

Linq to sql timeout

I have set command timeout property to zero in my code (means it is not limited), but still my timerjob timeouts, how to prevent time outing ? Is there any more actions should I take to increase ...
1
vote
3answers
143 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
18 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
239 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?
0
votes
0answers
62 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
0answers
39 views

SQL Union of two task lists in Access - how to get the correct “Assigned to”?

As you all probably know, a Sharepoint task list has an "Assigned To" column. When I import a task list, I get a table for the list and another table, "UserInfo" with the users for that list. When I ...
0
votes
1answer
268 views

Restore content database 2013

I am trying to restore a SharePoint site with a backed up content database. I restored the backup of the content database to Sql server, then when i created the web application i entered the restored ...
1
vote
1answer
27 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
1answer
3k 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
2answers
27 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 ...