Microsoft SharePoint is a platform and a family of software products developed by Microsoft for collaboration and web publishing. Its capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence. ...
0
votes
0answers
21 views
Multiple Column Lookup field from Access 2010 to Sharepoint 2010
I have two fields called "Tool ID" and "Tool Name" in my main "Tools" table in Access. "Tool ID" is set as the primary key in that it gives each tool a unique autogenerated number. When I create a ...
-1
votes
1answer
58 views
Directory lookup failed during log shipping
I have configured log shipping for all our SharePoint 2010 databases. All worked well since Friday and today Monday I ran this query:
SELECT *
FROM [msdb].[dbo].[sysjobhistory]
WHERE [message] like ...
0
votes
0answers
40 views
How to Copy Yes/No field data in Sharepoint list to Sharepoint list using SSIS Package?
I am copying sharepoint list data using SSIS package and they are copying perfectly. But the problem is when there is a Choice field or Yes/No field at that time it is copying only default value to ...
0
votes
0answers
320 views
SQL Server 2012 SSIS\SharePoint Kerberos auth
I have some issues setting up Kerberos together with SQL Server and SharePoint. Any help will be much appreciated! =)
GOAL:
Use Kerberos to avoid double-hop issue.
USAGE:
User logs onto ...
0
votes
0answers
132 views
Getting UserInfo data out of Sharepoint via OPENROWSET
The query below returns most of the data from the SharePoint list that my customers want:
SELECT *
FROM OPENROWSET ('Microsoft.ACE.OLEDB.12.0',
...
3
votes
2answers
424 views
SELECT/INSERT Deadlock
This instance hosts the SharePoint 2007 databases (SP). We have been experiencing numerous SELECT/INSERT deadlocks against one heavily utilized table within SP content database. I have narrowed down ...
0
votes
0answers
108 views
C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\DATA
I am trying to query SharePoint list data from a database named like STS_bangbus_1 database, but there seem to be only one SQL Server instance with the named “bangbus” aka “SHAREPOINT”, with ...
1
vote
2answers
273 views
Consistency errors for a SharePoint database
When I check my database (SQL Server 2008 R2, Windows Server 2008 R2, SharePoint 2007 DB) with the command:
DBCC CheckDB
I get 12 consistency errors (see below).
Is the only way to fix it with ...
6
votes
1answer
285 views
Attempting to tune a Sharepoint site using SQL Server Waits and Queues
I'm pretty new to this performance tuning with Waits and Queues thing - fascinating, but also not always all that intuitive...
Right now, a customer of mine has a SQL Server 2008 64-bit Enterprise ...
0
votes
0answers
84 views
Visio and Oracle Server/Network Layout
I'm attempting to use Visio 2010 and SharePoint for a somewhat unique scenario. After quite a bit of searching, I am in need of some assistance in pointing me in the right direction.
I want to ...
2
votes
1answer
548 views
Mysterious disappearing consistency errors in SharePoint DBs
We have a pre-production SharePoint SQL server which threw an 824 error yesterday evening on the Content DB. As part of my investigation today, I ran DBCC CHECKDB on this DB and it came up clean. ...
1
vote
1answer
267 views
FILESTREAM is enabled, but I get a message that it's not. Anyone able to help?
I have been given the task of setting SharePoint Foundation 2010 up in work. I have hit quite a few problems (see other questions I have posted), so I decided to start from scratch again. I have ...
2
votes
1answer
146 views
Can I create a second filestream container on an existing SQL Server 2008 database without going offline?
Our production DB is using the FILESTREAM option for our sharepoint environment. The volume where the files are residing is getting full and I am planning to add another volume to ease space issues. ...
2
votes
1answer
157 views
sys.syshobtcolumns Help
Does anyone have a good link to documentation regarding how the syshobtcolumns and syshobt system tables are populated. The reason for asking is that we are receiving pagelatch_sh and pageliolatch_ex ...
1
vote
1answer
285 views
How to manage SQL Server Log file?
I have an application build on SharePoint 2007 platform, and currently I encounter a common issue where the Database Log file growth rapidly and fill up the hard disk space.
In my situation, I wanted ...
2
votes
3answers
749 views
SQL Server Permission Denied Error When I'm DBOwner?
So I created an account, gave him dbcreator and securityadmin privileges and then through that account tried to run CREATE TABLE on a database that I had created and now owned, but was getting a ...
1
vote
2answers
328 views
maintenance plan executing by agent
I have a built-in, regular maintenance plan scheduled to run weekly.
The databases are SharePoint databases and a snap manager (netapp snap manager) backs up these databases.
The rebuild ...
4
votes
1answer
353 views
What can be done, if anything, to tune a SharePoint database?
SharePoint uses a single table (i.e. dbo.AllUserData) with columns like nvarchar1, nvarchar2, ..., nvarchar64 or int1, int2, ..., int16 (193 columns altogether) to store all items from all lists in ...
