Tag Info

Hot answers tagged

4

AFAIK, using the existing services; it is not possible to access the content database informations from Client Object model or services. As a work around you can create your own WCF service and deploy it in SharePoint, which can provide your required data. How to Customize WCF Services in SharePoint 2010 SharePoint 2010: Create Custom WCF Service


3

As per the Microsoft KB articles, which applies to all SharePoint Versions, always against direct access to SharePoint database. here are the supported scenarios: Supported database modifications Exceptions to the prohibition against database modifications are made for specific usage scenarios: Operations that are initiated from the SharePoint ...


3

If you navigate to Central Administration >> Monitoring >> Reporting: Configure Diagnostic Logging. You can configure logging to be less verbose, turn off logging for features you may not need, and limit the amount of space it consumes. See this link for a reference: http://technet.microsoft.com/en-us/library/ee748656(v=office.15).aspx


3

READ COMMITTED SNAPSHOT ISOLATION is not supported by SharePoint. Review the presentation below by Lisa Gardner from the PASS Summit back in 2012 for more details. http://blogs.msdn.com/cfs-filesystemfile.ashx/__key/communityserver-components-postattachments/00-10-36-86-42/SQLNSharePoint_5F00_Frienemies.pptx


2

SQL server by DESIGN will always eat up as much ram as you throw at it if you have databases of sufficient size. Have a 32GB database and 32GB of memory ... SQL by default will eat all of it. You can configure SQL to limit the amount of memory it will consume however. Lets say you have 16GB of memory in your system try limiting the SQL buffer to 10GB, that ...


1

It seems you are putting a heavy load on the server and that cannot be handled by the SQL Server itself. I would suggest splitting it into chunks, executing one by one and also increase the timeout to something relatively better for the particular query. I think it is ok to increase timeout upto 90 seconds depending on the situation and then can rollback ...


1

You can create a custom list in SharePoint with following fields Employee Name - Person field which pulls Employee name from User Profile (which can be tied to Active Directory) Type of Certification - Choice Field (You can fill in all available certifications) Certification # - Single line of text Expiry Date - Date field If your employee data is not ...


1

Since SharePoint stores ConfigDb connection string in Windows Registry you could utilize the following approach for retrieving Config Db server name: public static string GetConfigDbConnectionString() { var farm = SPFarm.Local; var version = farm.BuildVersion.Major.ToString() + "." + farm.BuildVersion.Minor.ToString(); var configDbKey = ...


1

You can use namespace Microsoft.SharePoint.Administration.SPFarm and look for Server in the farm. public String GetSharePointSQLServerName() { String sServerName = "notFound"; foreach (var item in SPFarm.Local.Servers) { foreach (var svc in item.ServiceInstances) { if (svc is SPDatabaseServiceInstance) { ...


1

Here is a guidance to rename the Usage and Health Data Collection service application: http://technet.microsoft.com/en-us/library/jj219726(v=office.15).aspx Stop your Service with: $usage = Get-SPUsageApplication $usage.ServiceInstances | % {Stop-SPServiceInstance $_.ID} In your SQL Management Tool Rename the database. I had problems doing this because ...


1

You need to rename one of the Databases. Is the Usage database the only one with a conflicting name? You can try: Removing the service application without deleting the database Using SQL Management Studio to rename the database to a new, non-conflicting name Provision the service application pointing to the renamed database Step by step: ...


1

When upgrading to SharePoint 2013 from 2010, you can choose to move only your content databases or you can upgrade some of your old services as well. The services that you can upgrade is the following: Secure Store service application Business Data Connectivity service application Managed Metadata service application User Profile service application ...


1

As You said, you dont want to use Kwiz solution in 2013. You have to remove/ uninstall that solution in 2010 completely. this way all refrence from content database gone. I highly recommend you to remove the twitter add-on as well. make it clean migration. Once you removed both then run the test-spcontentdatabase to check the potentail issue. If nothing ...


1

It depend what type of plan you have, if you have E3 or E4 then you can access the external data source. here is the great office article which explain what you can do it with external data source. Oracle is one of the supported database listed. http://office.microsoft.com/en-us/sharepoint-server-help/introduction-to-external-data-HA102891586.aspx other ...


1

Yes it is compatible with SQL Server 2008 R2 SP2. Also check: http://social.technet.microsoft.com/Forums/sharepoint/en-US/45f3d039-3e98-4791-a9da-bcd80ad71835/sql-server-2008-r2-sp2-and-cu2-are-compatible-for-environment-sharepoint-server-2010-sp1


1

(1) SP will display it as it could not connect to the external data source. Sometimes we setup manual caching mechanisms and as I know, it supports caching by default for Outlook. (2), (3) and (4) When a Business Data column is created, it creates another column associated with it which will be named with a suffix "_ID" to the Business Data Column. You can ...


1

Provided that BCS is connected to the web service and not to the DB directly, you should not need to worry about any changes at all.


1

You will be out of support of Microsoft. I dont think we can predict what will goes wrong as its depend what you change/ add/delete? Microsoft cannot reliably predict the effect to the operation of these products when parties other than the Microsoft SharePoint Development Team or Microsoft SharePoint Support agents make changes to the database schema, ...


1

The scenarios you could use with SharePoint are: Save the database file in SharePoint itself and check it in and out when you're using it just like you'd do with any other file. This is kind of rickety and SP isn't really going to do a great job of telling you what changes you made, but it's possible, I guess. Use Access Services to, in essence, host the ...


1

You may be able to use SharePoint Web Services' Lists class to interact directly with your lists. It has methods to create and read items from lists in SharePoint.


1

no need for any of those! you just need to add it to web.config http://msdn.microsoft.com/en-us/library/jj653752(v=vs.110).aspx and http://msdn.microsoft.com/en-us/library/ms228094(v=vs.85).aspx somthing on the lines of: <appSettings> <add key="SQLConnectionString" ...


1

Well best would be to avoid the Access DB layer, SharePoint -> List is the best way.. But if its necessary, you can write a Custom WCF Service, call this service from InfoPath form.. And use C# to add contents to Access Database.. You can use Business Connectivity Services: External Lists to connect to Access Database and show the List View. Let me know if ...


1

I would say that the problem isn't a SharePoint problem (SharePoint is really speaking just a ASP.Net website reading and writing to a SQL database), but more of a SQL Problem. I found a good article where Microsoft did some research on the topic. Read here: http://research.microsoft.com/pubs/64525/tr-2006-45.pdf



Only top voted, non community-wiki answers of a minimum length are eligible