This little SQL script is used to to shrink all the log files in a Microsoft SQL server instance.  It uses the following function to get the job done: DBCC SHRINKFILE. declare @ssql nvarchar(4000) set @ssql= ‘ if ”?” not in (”tempdb”,”master”,”model”,”msdb”) begin use [?] declare @tsql nvarchar(4000) set @tsql = ”” declare @iLogFile int [...]

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; } [...]