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
21 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
12 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
13 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
8 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
98 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
25 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
28 views

Is it possible to run/ install sharepoint on MySQL

as in the titel you can read, I wonder if it is possible to install and run sharepoint (does not matter what version) on an other SQL-Plattform than Microsoft? For example: MySQL, Oracle SQL, etc. ...
0
votes
0answers
17 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
16 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
25 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
23 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
42 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
17 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
29 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
61 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
65 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
27 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
45 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
28 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
11 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 ...
1
vote
0answers
48 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
16 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
79 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
183 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
17 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
26 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
26 views

SP 2010 , SP 2013 and SQL Database

Can Sharepoint 2010 and Sharepoint 2013 use the same database (SQL 2012) ?
0
votes
0answers
18 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
107 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
154 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
43 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
35 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
107 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
2k 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
25 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 ...
2
votes
1answer
581 views

SP2013 Failed to create the configuration database

When installing SP2013 I got this error: Failed to create the configuration database An exception of type Microsoft.Sharepoint.SPException was thrown. Additional exception information: The ...
0
votes
1answer
37 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
70 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 ...
0
votes
1answer
51 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
34 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
364 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
80 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
0answers
27 views

How do I use Sharepoint 2010 as an SQL backend for web content?

Given web pages hosted in a SharePoint 2010 document library, what is the simplest way to use SP as an SQL backend such that some Javascript on each page could add/query data from a single table on ...
0
votes
0answers
18 views

SQL DB 2008 R2 SP2

We have Principal DB ex: DB1 and Mirror DB ex: DB2. Webanalytics Service App has 2 DB's created ReportingDB and StagingDB. I have noticed that the mirroring has been suspended and not happening for ...
0
votes
1answer
63 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
236 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
42 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 ...