Search for text in SQL database procs/functions

declare @searchString varchar(100)
Set @searchString = '%word_to_find%'
SELECT Distinct SO.Name
FROM sysobjects SO (NOLOCK)
INNER JOIN syscomments SC (NOLOCK)
on SO.Id = SC.ID
AND SC.Text LIKE @searchString
ORDER BY SO.Name

Technorati Tags: ,,
23. July 2009 07:04 by Danny Gershman | Comments (1) | Permalink

Step/Debug through VBScript

http://baodad.posterous.com/step-through-vbscript-debugging

Technorati Tags:
20. July 2009 12:09 by Danny Gershman | Comments (0) | Permalink

VBScript Array

Pretty neat script I wrote that allowing preserving an array by cloning it.

Function AddToArray(ArrayToClone, ValueToAdd)
Dim a, tempArray
    On Error Resume Next
    ReDim tempArray(UBound(ArrayToClone) + 1)
    If Err.Number = 0 Then
        For a = LBound(ArrayToClone) To UBound(ArrayToClone)
            tempArray(a) = ArrayToClone(a)       
        Next
    ElseIf Err.Number = 13 Then       
        Err.Clear
        ReDim tempArray(0)
    Else
        WScript.Echo Err.Number
    End If
    tempArray(UBound(tempArray)) = ValueToAdd       
    AddToArray = tempArray
End Function

Technorati Tags: ,
20. July 2009 11:02 by Danny Gershman | Comments (0) | Permalink

Sharepoint Solution Installer

 

http://www.codeplex.com/sharepointinstaller

Technorati Tags: ,
20. July 2009 08:23 by Danny Gershman | Comments (0) | Permalink

Quickly Install WSP

stsadm -o addsolution -filename helpdesk.wsp

stsadm -o deploysolution -name helpdesk.wsp -allowgacdeployment -immediate

stsadm -o execadmsvcjobs

Technorati Tags: ,
20. July 2009 08:18 by Danny Gershman | Comments (1) | Permalink

About dannyg

dannyg has been writing software for the last 12+ years and worked with various languages and programs.  He specializes business process automation, versatile solutions and R&D.