We were having trouble adding a user to a site collection.  Every time we hit the search button or clicked the check userid button the system would just sit there and spin. I added the following section of the web.config to resolve the issue. </compilation> <pages enableSessionState="false" enableViewState="true" enableViewStateMac="true" validateRequest="false" pageParserFilterType="Microsoft.SharePoint.ApplicationRuntime.SPPageParserFilter, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" [...]

Here is the t-sql statement used to shrink the SQL transaction logs: Use <DatabaseName> Go Backup Log <DatabaseName> With Truncate_Only DBCC SHRINKFILE(<TransactionLogName>, 1) Go .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, “Courier New”, courier, monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } [...]

I came across this script to backup all SQL Server databases: Code Snippet DECLARE @name VARCHAR(50) — database name DECLARE @path VARCHAR(256) — path for backup files DECLARE @fileName VARCHAR(256) — filename for backup DECLARE @fileDate VARCHAR(20) — used for file name SET @path = ‘E:\Backups\Dynamics’ SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112) DECLARE db_cursor CURSOR FOR SELECT [...]

One of our developers reported to me that the SharePoint Alerts were not sending emails.  The initial notification that the alert was setup was sent but not the alerts themselves. I was able to find a great article by a MS MVP named Susan Bradley called How to Troubleshoot Alerts in WSS 3.0 / MOSS. [...]