Removes existing duplicate inline default objects, converting the unique inline defaults to sharable inline default objects.


sp_merge_dup_inline_default [@report_only = {yes | no} 
	[, @show_progress = {yes | no}]]




There are additional considerations when using sp_merge_dup_inline_default:
  • You cannot run sp_merge_dup_inline_default on system databases.

  • User databases must be in single-user mode before you run sp_merge_dup_inline_default.

  • You may re-run sp_merge_dup_inline_default if the system procedure aborts.

  • If sp_merge_dup_inline_default issues an error message stating that the SAP ASE server is out of locks:
    • Increase the value for number of locks, or

    • Reduce the lock promotion threshold with sp_setpglockpromote or sp_setrowlockpromote.

    Re-run sp_merge_dup_inline_default, and reset the values after sp_merge_dup_inline_default finishes.

  • sp_merge_dup_inline_default changes only inline default objects for which the default value is a literal string constant or simple numbers (the literal string constant cannot include escaped string delimiters).

  • sp_merge_dup_inline_default does not remove any duplicate inline default objects if their source text in syscomments is “encrypted.”


The permission checks for sp_merge_dup_inline_default differ based on your granular permissions settings.


With granular permissions enabled, you must be a user with manage database privilege.


With granular permissions disabled, you must be a user with sa_role.