<div>
It is - you can copy objects using the import/export wizard (amongst other ways of recreating them)
</div>


It is - you can copy objects using the import/export wizard (amongst other ways of recreating them)

<div>
Ok, do both Databases have to be up at the same time to do that? <br />
Or could I export to a file? <br />
Or do I have to create a blank DB and export the stored procedures into that, and then restore the more current DB and import them in?
</div>


Ok, do both Databases have to be up at the same time to do that?
Or could I export to a file?
Or do I have to create a blank DB and export the stored procedures into that, and then restore the more current DB and import them in?

<div>
Thanks man, I'm sure I can use this solution to get at least most of my data back :) Hope I can return the help that you gave some day.
</div>


Thanks man, I'm sure I can use this solution to get at least most of my data back :) Hope I can return the help that you gave some day.

<div>
<div class="content wysiwyg-content">
We have a DB that got corrupted and had to be repaired (log file was deleted) - unfortunately it seems like not everything was recovered. <br />
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 :<br />
<br />
04/22/2009 07:54:17 The object 'p_CascadeGrantAccess' does not exist in database 'AcmeWidgits_MSCRM'.<br />
04/22/2009 07:54:17 Microsoft OLE DB Provider for SQL Server<br />
<br />
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?
</div>
</div>


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?

Copy SQL Stored Procedures (Export and Import)

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.

Microsoft Dynamics

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.