Adding the Stored Procedure for Microsoft SQL Server and Sybase Databases

Compile the appropriate stored procedure (mssql_fc_wip_q_counts.sql or syb_fc_wip_q_counts.sql).

• One way of performing the compilation:
  isql -Usa -P<pass> -S<server> -d<database> < <sql_file>
  where:
  <pass> is sa's password
  <server> is the name of the database server
  <database> is the name of the database
  <sql_file> is the name of the stored procedure file

If there are any error messages once completed, fix the error and recompile.

Did this topic help you? Email us your feedback.
Last updated: 11/7/2007 9:23:58 AM
© by Dovetail Software, Inc.