error running exe created by packager

sqltardedsqltarded Posts: 3
edited April 1, 2005 1:44PM in SQL Packager Previous Versions
i get the following error when i run sqlpackager...

Name must be in sysobjects with xtype = "p"

the database seems to be created, however, i am not sure what this message is telling me. can someone shed some light on this.

i am currently doing an eval on the trial version to see if the product will suit our needs.
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello,

    SQL Packager gets the information about the schema from the system tables that are shipped with SQL Server. Specifically, the sysobjects table contains information about objects in the database. The xtype column identifies the type of object that this is. For instance, 'S' is a system table, 'U' is a user table, and 'P' is a stored procedure.

    If this happens during the package execution, it may be because of some database corruption or the result of someone accidentally modifying sysobjects.

    It may be for other reasons as well. Is this a new database package or an upgrade package? There may be differences in the way these are handled by the server.
    · Share on Twitter
  • sqltardedsqltarded Posts: 3
    thanks for the explanation brian...

    this is for a new database pacakge.
    · Share on Twitter
This discussion has been closed.