Navigation¶

• Main Page
  

• Random Page
• Create a new Page
• All Pages
• Categories
  

• Administration
• File Management
  

• Login/Logout
• Language Selection
• Your Profile
• Create Account
  

Quick Search
»
Advanced Search »

ODM - Help

Table of Contents [Hide/Show] How do I update the series catalog?

How do I update the series catalog?¶

The blank ODM database available on the ODM downloads page has a stored procedure that updates the series catalog. To run it:

1. Log in to SQL Management studio.
2. Click the plus sign to expand the tree for your database.
3. Expand Programmability, and then Stored Procedures. You will see dbo.spUpdateSeriesCatalog.
4. Right click dbo.spUpdateSeriesCatalog, and click Execute Stored Procedure.
5. Click OK in the dialog that opens. The procedure then runs.
6. Open the Series Catalog table to see if it was updated. You may need to right click on the table and click Refresh to see the changes.
   

Note: If you don't see "Execute Stored Procedure" in the context menu for dbo.spUpdateSeriesCatalog, then try this:

1. Right click dbo.spUpdateSeriesCatalog, and point to Script Stored Procedure as.
2. Then point to EXECUTE To.
3. Then click New Query Editor Window.
4. When the script shows up in the new query editor window, click the Execute button (usually the top with other buttons in the SQL Management Studio user interface.)