1
vote
0answers
24 views

Editing a Dataview from a joined list

I think I want to do something simple, but it seems maybe I am not doing it the way you are supposed to. I need to use Sharepoint Designer 2007 to create a website, code behind is highly likely to be ...
0
votes
1answer
809 views

Site usage report from Database

I have a SP 2007 site where site usage is enabled and I can check the usage for last thirty days. I wanted the usage details for last 6 months for which I went to SharePoint Designer but my SPD is ...
0
votes
0answers
404 views

Insufficient SQL database permissions for user “”

I'm working with SharePoint 2007 and when I start the search service I keep getting the following error: Insufficient SQL database permissions for user '' in database Test_ConfigDB on SQL Server ...
1
vote
2answers
482 views

Update a list via SQL with MOSS2007?

How can I go about applying an update statement to a on MOSS2007 deployment? Essentially I'd like to write something similar to the following across it: update <list_name> set ...
0
votes
2answers
89 views

MOSS2007 active DBs

Whats the best way to tell which dbs are being used in your farm? Having moved and changed db servers over time, i now have dbs everywhere, wanting to do a clean up?
0
votes
1answer
151 views

Connecting Web part to external Database

I'm trying to connect a web-part running in Sharepoint 2007 site to an external Sql Server 2005 database. I get a System.Secutity.SecurityException with "Request Failed" message when I attach debugger ...
5
votes
3answers
2k views

Sharepoint 2007 farm performance goes down?

Our sharepoint 2007 farm is not working properly and we are facing a huge performance hit, some times it throws an unexpected error too. What all are the points to check? i.e like Depth of the ...
0
votes
1answer
338 views

How to force Sharepoint to commit list item changes to the database?

Long story short, I have an event receiver on a list item which listens for the ItemAdded event, makes some additional changes to the newly created item, calls listItem.SystemUpdate() and starts a ...
1
vote
3answers
172 views

Accessing the content database directly

Is accessing a content database is not a 'best practice' or 'advisable' or it 'should' not be done as Microsoft can withdraw their support if it is done? I just want to know if it 'can' be done in the ...
1
vote
3answers
320 views

How do I perform database disk usage analysis and selective replication?

I have a SharePoint 2007 database that is 16GB in size and I want to know why, and how I can reduce the size. Ideally I would like a trimmed replica to use as a developer workstation that retains a ...
2
votes
2answers
2k views

Unable to complete this operation. Please contact your administrator

We are using one API SharepointImporter Tool to upload documents to a SharePoint Site. When we are uploading one archive file we are getting the following problem. Error: Unable to complete this ...
1
vote
2answers
236 views

SharePoint 2007 Web-application is getting crashed due to memory leak

We decided to duplicate an existing web-application (for Podcasting kit), which has site collection only at root level, so created a new web-application (in the same DB instance) and imported (stsadm ...
1
vote
3answers
2k views

How to Enumerate ALL SharePoint MOSS databases

I want to enumerate all databases used by my SharePoint 2007 system. The stsadm -o enumcontentdbs only handles content db's but I also want the names of the SSP, Search and any other databases used by ...
1
vote
2answers
1k views

External database connection in web part

So, I have a web part that needs to connect to a different database other than sharepoint. This is a custom web part that I'm writing in VS, not something built with SPD. How can I connect to the ...
0
votes
1answer
2k views

Why SharePoint is not considering 'dbo.AuditData' table while calculating the site-collection size?

We have a heavy used site collection with a 30GB quota limit on the content DB - WSS_WebApp_Content1, I have verified the 'dbo.AuditData' table and found that it has 1.4c records and is 35 GB in size. ...
14
votes
4answers
1k views

Any reason not to create a new content database for each site collection?

When creating a site collection in stsadm there are 2 commands I could use: createsite and createsiteinnewdb, where the latter creates a new content database for the site collection. Reading around ...
2
votes
2answers
647 views

(De)Commission SharePoint Database Servers

In our SharePoint Farm, We are running with 2 Database Servers and on which we have 20+ Databases.Now, due to some issues we would like to decommission the existing database servers and commission 2 ...
0
votes
2answers
303 views

Issue when trying to reinstall MOSS on a single server

I am not an expert on the installation of SharePoint, but I have been trying to configure the MOSS installation on one of our DEV servers. The first problem was found when trying to set up an SSP. ...
0
votes
1answer
55 views

Performance Metrics and CA Configuration & Content DB?

When can we expect a maximum number of SQL connections for the Central Administration Configuration & Content DB? and what are all the important tables in these databases that an administrator ...
0
votes
1answer
256 views

Performance tuning and Manage Farm-Level Search Settings

Below options are available under "Manage Farm-Level Search Settings" in Central Administration Connection time (in seconds): 60 Request acknowledgement time (in seconds): 60 I would like to know ...
3
votes
2answers
460 views

What is the use of the search database and do we really need it?

The index will be kept on the Index Server, so why do we need a Search database and what is the point of it in SharePoint 2007? I would like to understand the basic concept of SharePoint Search. ...
1
vote
1answer
445 views

Managing Quotas and Content Databases with multiple Site Collections

Five content DBs are associated with a webapplication and each content DB can store upto 50GB. We have configured a couple of site quotas as follows: basic_quota (1GB) collab_quota (2GB) ...
2
votes
5answers
2k views

Migrating content from one content database to another

We have a content database on our live moss server. It contains one site collection with several sub-sites. I'm using the stsadm export command to produce a cmp file, then moving this to our test ...
3
votes
2answers
70 views

How critical is it and how to monitor, measure and reduce SharePoint database fragmentation?

It is a well advertised best practice to configure maintenance plans for SQL databases forming the data layer of SharePoint deployments. How critical is it to monitor and reduce fragmentation of the ...
1
vote
2answers
2k views

Why EventCache table size is huge

I have a MOSS publishing site. Content is quite small. I noticed that content database size is now 5GB without any significant content changes made. Using a script to show the tables' sizes, I noticed ...