Hot answers tagged

5

This is completely unsupported! Do not read or write data to SharePoint databases. You need to go through the SharePoint Object Model, namely using SPWeb.EnsureUser which will add the entry if it does not exist.


4

You can detach the content database from central admin and then reattach using the correct SQLCluster Name. You dont need to delete anything. Attach or detach content databases in SharePoint 2013


4

Depending on your specific requirements, the easiest way is probably to use BCS to create external content types that link to your MySQL data. Your SharePoint hosted app can then read/write that data more or less as if it was a standard SharePoint list. The benefit of this approach is that it is quite quick and easy to set up. The downside is that it may be ...


4

Nico, I found a source that may help you immensely. The following link walks you through how to use a PowerShell script to import a list of users from Excel and create them for FBA. Importing and Exporting Data in Extranet Collaboration Manager (ExCM) 2010 You can also download the PowerShell source code from this link. It looks like the code creating ...


3

Do not remove the site collection from the database! Just remove it via the GUI (Site settings -> Delete site) or use the PowerShell cmdlet Remove-SPSite (outlined here). This will make sure it is deleted the right way


2

Has nothing to do with SharePoint. If you configure the server your MYSQL database runs on to accept Cross Origin requests you can access it from any environment. A https connection is preferred, but not required when you manually instruct your browser to allow mixed content. A REST middle-tier like ArrestDB in your stack simplifies access. You are ...


2

If your database is SQL, then there is a built in feature to achieve this. Follow the link For other databases you have to write a custom wcf web service. see here


2

I would also like to add that you can also accomplish this with SQL Table Views. So if you create a custom view within your SQL DB, you can connect to it in BCS using SP Designer as if it was a regular table. My understanding is that if the View is update-able as defined here, you will also be able to add Update controls to it. To add a view as an ECT ...


2

SharePoint API has class and function SPContentTypeUsage.GetUsages that returns all content type usages in site collection. Is MSDN article there is an C# sample too. Also look at the accepted answer in this question . The answer is in PowerShell.


2

You can use the script to give specific users the db_owner role. Don't forget to dd all users to users.txt. [System.Reflection.Assembly]::LoadWithPartialName(‘Microsoft.SqlServer.Smo’) | out-null $Users = get-content c:\users.txt Foreach ($User in $Users){ $InstanceName = "" $NewOwnerLoginName = $user; $smosvr = New-Object ...


2

The name of a content database is just a random generated name that does not have any type of function more than that you can't have 2 databases with the same name. (Every database has it owns unique ID, the display name is just there to make administration easier.) However you should name your content databases to something relevant to make it easier for ...


1

I know you get the answer, here is my 2cetns on it. why i will get different content database when i create a new web application? and from where i can check this content database? Christoffer already explained it. SharePoint when create a content DB it puts guid in front of it, make it unique, you cant have two database with same name / id in the same ...


1

Pre-Requisites You must be a member of the Farm Administrators SharePoint group. You must be a member of the Administrators group. On the database server you must be a member db_backupoperator fixed database role and db_owner fixed database role Steps Close all open SharePoint Management Shell windows. Stop all services that are related to SharePoint ...


1

There are many ways how to add items to SharePoint lists and the approach that you want to take is definitely not on the list. Using C# (server object model) - code needs to be run on SP server. Using C# (Client object model) - add items to SharePoint List using CSOM. SharePoint PowerShell. SharePoint Web Services (jQuery). Query Ajax function is used to ...


1

For a development environment, no I don't see any reason you couldn't shrink it (though you should never shrink databases in production, unless you're going to gain back 40%+ space and you need it -- shrinks fragment the indexes). I would say for your dev environment, you probably want to disable most usage logging, unless you need it for a specific ...


1

You can shrink a SharePoint SQL Server database just like any other SQL Server database using SQL Server Management Studio. This is fine in a development environment, since you are likely the only person using it (might want to give a heads up to the team if there's more than one of you). Of course, there will be a performance impact on SharePoint itself ...


1

I recommend you start with this book, "Inside Microsoft SharePoint 2010". The first 4 chapters can be read online at MSDN this link: Book landing page: Inside Microsoft SharePoint 2010 There are versions of this book for 2007 and 2013 too.


1

User profiles must be created initially from an LDAP (or other approved directory) this does not include SQL. You have to have a domain account to match the Profile to. This can also happen when a user hits a SharePoint site for the first time. Once the Profile is created you can update it in a number of different ways. If you want to use a SQL data source ...


1

I am on the same SKU with patch level October 2015 CU. I can't reproduce the behavior with the second page you mention. With regards to the requested ordering of comments, I was able to change the ordering by using SharePoint designer. I navigated to post.aspx within the list that contains the blog items and changed the XsltListViewWebPart webpart that is ...


1

You can use the stored procedures with BCS, so instead of a single table, you can gather information (Read only) from a result of a query. You need to create the stored procedure in SQL first, then connect to BCS through SHarePoint Designer, then you will be able to create a External Content Type based on that stored procedure. Here is an article that ...



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