Chapter 1: System Procedures

sp_post_xpload

Checks and rebuilds indexes after a cross-platform load database where the endian types are different.

sp_post_xpload

Once the database is loaded from another platform, rebuild its indexes by executing:

sp_post_xpload

To check and rebuild indexes after a dump database and load database.

The following indexes are rebuilt on all user tables in the database:
- Nonclustered index on an APL table
- Clustered index on a DOL table
- Nonclustered index on a DOL table
Indexes on system tables are not processed with this stored procedure. System table indexes are rebuilt when online database is executed.
You can also rebuild indexes using drop index and create index.
Only run this stored procedure when the database is loaded across platforms with different endians.
Where the index status is suspect, reset the index by executing the sp_xpload, drop index, or create index.
Stored procedures are recompiled from the SQL text in syscomments at the first execution after the load database. Use dbcc upgrade_object to upgrade objects if you do not have permission recompile from text.

Can only be executed by the System Administrator.

Values in event and extrainfo columns from the sysaudits table are:

Event	Audit option	Command or access audited	Information in extrainfo
38	exec_procedure	Execution of a procedure	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect