次の方法で共有

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

Comments

  • Anonymous
    June 10, 2009
    PingBack from http://tune-up-pc.com/blog/?p=2266

  • Anonymous
    July 21, 2009
    This is very good news was well informed that the followers of the issue I am. Thanks...