Copy SQL Stored Procedures (Export and Import)
Posted on 2009-04-22
We have a DB that got corrupted and had to be repaired (log file was deleted) - unfortunately it seems like not everything was recovered.
It's a CRM database and when we try to run the redeployment wizard it fails. When we look at the logs to see why it failed we see :
04/22/2009 07:54:17 The object 'p_CascadeGrantAccess' does not exist in database 'AcmeWidgits_MSCRM'.
04/22/2009 07:54:17 Microsoft OLE DB Provider for SQL Server
We do have a backup, but it's at least a month old! If we recover that SQL DB, is it possible to export the stored procedure (or procedures...) then go back to the more current DB and IMPORT the stored procedures?