For Each dmoDB In dmoServer.Databases
strFolder = "C:\SQLDMO_Scripts\Local\Result\SP\" & dmoDB.Name
If dmoDB.Name <> "master" And dmoDB.Name <> "msdb" And dmoDB.Name <> "tempdb" And dmoDB.Name <> "Northwind" And dmoDB.Name <> "pubs" And dmoDB.Name <> "model" Then
'If dmoDB.Name = "ApplogDB" Then
If Not FSO.FolderExists(strFolder) Then
FSO.CreateFolder(strFolder)
End If
For Each dmoSP In dmoDB.StoredProcedures
If Not dmoSP.SystemObject Then
strFile = strFolder & "\" & dmoSP.Name & ".sql"
dmoSP.Script SQLDMOScript_IncludeHeaders + SQLDMOScript_ToFileOnly + SQLDMOScript_Drops + SQLDMOScript_Default , strFile
End If
Next
End If
Next
Set dmoSP = Nothing
Set dmoDB = Nothing
Set dmoServer = Nothing