DBSchema file for SQL LiteSpeed XP’s
Based on a customer request I created a .dbschema file which contains the definitions of all the extended stored procedures used by SQL LiteSpeed 5.0 that live inside the master database. Since schema import does not import the definition of extended stored procedures, the user could no resolve the reference to the extended stored procedures.
The following 39 extended stored procedures are defined inside the dbschema file:
| Extended Stored Procedure name |
[dbo].[xp_append_file] [dbo].[xp_backup_database] [dbo].[xp_backup_log] [dbo].[xp_delete_tsmfile] [dbo].[xp_encrypt_decrypt] [dbo].[xp_file_search] [dbo].[xp_get_temp_filename] [dbo].[xp_memory_size] [dbo].[xp_objectrecovery] [dbo].[xp_objectrecovery_createscript] [dbo].[xp_objectrecovery_executeselect] [dbo].[xp_objectrecovery_viewcontents] [dbo].[xp_procedure] [dbo].[xp_read_file] [dbo].[xp_rebind_tsmmc] [dbo].[xp_remove_file] [dbo].[xp_replicate_activity_statistics] [dbo].[xp_replicate_job_statistics] [dbo].[xp_restore_attachedfilesonly] [dbo].[xp_restore_checkpassword] [dbo].[xp_restore_checksumonly] [dbo].[xp_restore_database] [dbo].[xp_restore_filelistonly] [dbo].[xp_restore_headeronly] [dbo].[xp_restore_log] [dbo].[xp_restore_setinfo] [dbo].[xp_restore_verifyonly] [dbo].[xp_sls_bcp] [dbo].[xp_slsAddRegMultiString] [dbo].[xp_slsReadProgress] [dbo].[xp_slsRemoveRegMultiString] [dbo].[xp_slssqlmaint] [dbo].[xp_sqllitespeed_debug] [dbo].[xp_sqllitespeed_licenseinfo] [dbo].[xp_sqllitespeed_version] [dbo].[xp_view_sls_auditlog] [dbo].[xp_view_tsmcontents] [dbo].[xp_view_tsmfilespaces] [dbo].[xp_view_tsmmc] |
You can download the dbschema files from the following SkyDrive location:
https://cid-526eb9977609d51e.skydrive.live.com/self.aspx/DBProj.com/DBSchema/SQLLiteSpeed/SQLLiteSpeed.dbschema.zip
There are 3 dbschema files, one for each version:
I hope this helps others who need to reference SQL LiteSpeed procedures.
GertD @ www.DBProj.com