Options
error running exe created by packager
sqltarded
Posts: 3
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.
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.
This discussion has been closed.
Comments
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.
this is for a new database pacakge.