All Questions
28 questions
0
votes
1
answer
1k
views
Get data from VARBINARY fields
System: SharePoint 2010 and SQL Server 2012.
Question : how to get data from a content database field that are tCompressedString(varbinary) type? For example, table [Content_DB].[dbo].[AllWebParts] ...
- 1,041
3
votes
1
answer
400
views
SQL Server Max Memory
In our farm, we have 3 servers dedicated for SQL Server and all three are consuming 99% of the memory available. Looking in to it I learned that we didn't change the Max Memory setting in our SQL ...
- 949
1
vote
0
answers
2k
views
You do not have permission to run the RECONFIGURE statement
I am attempting to upgrade a SP2010 content database to SP2013. Once I get to 100% of the Mount-SPContentDatabase, etc, I am presented with the error:
Mount-SPContentDatabase: user does not ...
- 21
0
votes
1
answer
58
views
Upgrade my SharePoint 2010 database from 2008 SP1 to 2008R2 SP3
I have SharePoint 2010 running on SQL Server 2008 SP1. I would like to upgrade the database to 2008R2 SP3.
Are there any problems with that?
- 1
0
votes
1
answer
820
views
infopath udcx error Data adapter failed during OnLoad
I created a UDCX file for data connection using SQL Server authentication in InfoPath form of SharePoint 2010. After that, I created a secure storeId which has credentials stored for SQL ...
- 365
1
vote
0
answers
1k
views
How to resolve SharePoint 2010 Error Event 5586 - Some part of your SQL statement is nested too deeply.
The SharePoint 2010 server is returning some error message on Windows Event Viewer and SharePoint logs.
Windows Event Viewer is returning the following error message:
Event 5586, SharePoint ...
- 135
0
votes
1
answer
627
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 ...
- 552
0
votes
1
answer
26
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 ...
- 1
3
votes
1
answer
319
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 ...
- 671
0
votes
2
answers
395
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?
1
vote
1
answer
43
views
SP 2010 , SP 2013 and SQL Database
Can Sharepoint 2010 and Sharepoint 2013 use the same database (SQL 2012) ?
- 4,934
1
vote
3
answers
469
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 ...
- 748
2
votes
2
answers
2k
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:
...
- 293
1
vote
0
answers
63
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 ...
- 293
0
votes
1
answer
1k
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 ...
- 766
1
vote
0
answers
151
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 ...
- 351
2
votes
2
answers
1k
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 ...
- 471
0
votes
1
answer
237
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 ...
- 1,242
1
vote
2
answers
271
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 ...
- 1,425
3
votes
1
answer
119
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 ...
- 31
0
votes
1
answer
1k
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 ...
0
votes
1
answer
182
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:
System.Data.SqlClient....
- 391
1
vote
2
answers
333
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 ...
user16227
1
vote
1
answer
415
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 ...
- 77
0
votes
0
answers
1k
views
Moved SQL databases for SharePoint 2010 and now have a 3351 error
I moved the SQL databases from a local instance to a remote SQL server. All permissions are the same. Everything seems to work but now I'm getting a 3351 SQL error every 30 minutes from the local ...
- 21
2
votes
5
answers
3k
views
Locked Row in database for key on Infopath Submission for Contribute Permission + below w/ Custom Event Reciever (ItemUpdating)
Basic Rundown of Process: I am creating a Process wherein an InfoPath form is Submitted to a Library, certain managers will then have the ability to change a drop-down to either Approved or Rejected, ...
- 1,560
2
votes
3
answers
4k
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: Remove-...
- 335
3
votes
1
answer
1k
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 ...
- 890