Msg 207, Level 16, State 1, Procedure GetCaseCurrentOwner, Line 19
Invalid column name 'StatusId'.
Msg 207, Level 16, State 1, Procedure GetCaseCurrentOwner, Line 21
Invalid column name 'Id'.
Msg 207, Level 16, State 1, Procedure GetCaseDistributionList, Line 35
Invalid column name 'IsActive'.
Msg 207, Level 16, State 1, Procedure GetCaseDistributionList, Line 57
Invalid column name 'IsActive'.
Msg 209, Level 16, State 1, Procedure GetSecUsersAccess, Line 21
Ambiguous column name 'EffectiveDt'.
Msg 209, Level 16, State 1, Procedure GetSecUsersAccess, Line 22
Ambiguous column name 'EndDt'.
The module 'mntSaveCaseSubType' depends on the missing object 'UpdateMaintenenceListId'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'mntSaveCaseType' depends on the missing object 'UpdateMaintenenceListId'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'mntSaveContactType' depends on the missing object 'UpdateMaintenenceListId'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'mntSaveHairColor' depends on the missing object 'UpdateMaintenenceListId'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'mntSaveLocations' depends on the missing object 'UpdateMaintenenceListId'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'mntSaveQuestion' depends on the missing object 'UpdateMaintenenceListId'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'mntSaveQuestion' depends on the missing object 'UpdateMaintenenceListId'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'mntSaveQuestionEntities' depends on the missing object 'UpdateMaintenenceListId'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'mntSaveRegion' depends on the missing object 'UpdateMaintenenceListId'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'mntSaveSecurityFirms' depends on the missing object 'UpdateMaintenenceListId'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'mntSaveVehicleColors' depends on the missing object 'UpdateMaintenenceListId'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'mntSaveVehicleMake' depends on the missing object 'UpdateMaintenenceListId'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'mntSaveVehicleTypes' depends on the missing object 'UpdateMaintenenceListId'. The module will still be created; however, it cannot run successfully until the object exists.
Msg 207, Level 16, State 1, Procedure SaveDistributionList, Line 40
Invalid column name 'IsActive'.
Msg 207, Level 16, State 1, Procedure SaveDistributionList, Line 45
Invalid column name 'IsActive'.
Msg 207, Level 16, State 1, Procedure SaveDistributionList, Line 44
Invalid column name 'IsActive'.
Msg 207, Level 16, State 1, Procedure SaveDistributionList, Line 55
Invalid column name 'IsActive'.

CREATE TABLE #Dir(Col1 varchar(max))
GO

INSERT INTO #Dir(Col1)
EXEC master..xp_cmdshell 'dir \\L-LLRLTENN\Public\PSRS\Sprocs\*.*'

SELECT CHARINDEX('dbo.',Col1) FROM #Dir



DECLARE myCursor99 cursor
FOR
SELECT 'RENAME \\L-LLRLTENN\Public\PSRS\Sprocs\' 
 + SUBSTRING(Col1,40,50) + ' '
 + SUBSTRING(REPLACE(REPLACE(Col1,'dbo.',''),'.StoredProcedure',''),40,50)
FROM #Dir
WHERE CHARINDEX('dbo.',Col1) <> 0

DECLARE @dos varchar(8000)

OPEN myCursor99

FETCH NEXT FROM myCursor99 INTO @dos

WHILE @@FETCH_STATUS = 0
  BEGIN
	EXEC master..xp_cmdshell @dos
	FETCH NEXT FROM myCursor99 INTO @dos
  END
  
CLOSE myCursor99
DEALLOCATE myCursor99
GO

DROP TABLE #Dir
GO

quote:

---

In the minefield of available options I've never seen that one.

---