20 Dec 2011

Extend 10MB limitation of sharepoint template file

Extend template file size to 50MB

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsadm -o setproperty -propertyname max-template-document-size -propertyvalue 5000000

Operation completed successfully.

7 Dec 2011

Unprotect Excel sheet

Open protected sheet, right click an select View Code or press a short cut Atl+F11.
Copy and paste the below code and Run.
Enjoy :-)

Sub PasswordBreaker()
Dim i As Integer, j As Integer, k As Integer
Dim l 
As Integer, m As Integer, n As Integer
Dim i1 
As Integer, i2 As Integer, i3 As Integer
Dim i4 
As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66:         For k = 65 To 66
 
For l = 65 To 66: For m = 65 To 66:        For i1 = 65 To 66
  
For i2 = 65 To 66: For i3 = 65 To 66:       For i4 = 65 To 66
   
For i5 = 65 To 66: For i6 = 65 To 66:       For n = 32 To 126

     ActiveSheet
.Unprotect Chr(i) & Chr(j) & Chr(k) & _
         Chr
(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
         Chr
(i4) & Chr(i5) & Chr(i6) & Chr(n)
     If 
ActiveSheet.ProtectContents = False Then

         ActiveWorkbook
.Sheets(1).Select
         Range
(“a1”).FormulaR1C1 = Chr(i) & Chr(j) & _
              Chr
(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
              Chr
(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
         Exit 
Sub
 End 
If Next: Next: Next: Next: Next: Next
Next
: Next: Next: Next: Next: Next

End Sub 

6 Dec 2011

DPMRA can not start with error 1168

Verify you COM+ rights for the DPM agent. It could be that there is a missmatch in the rights.
Click START / Administrative Tools / Component Services
Expand Component Services / Computers / My Computer / DCOM Config
Right click on the "DPM RA Services" and choose properties. Verify that under the Security tab / Launch and Activation Permissions you got Customize marked, click the Edit... button in the ACL you should see the computer account for your DPM server. If it's not present add it and mark all allow boxes and try to start the service again.

DPMRA stops more frequently

http://www.microsoft.com/download/en/confirmation.aspx?id=23224

Total Pageviews