These limitations apply to shared inline defaults:
You cannot use shared inline defaults in global or user tempdb.
Inline defaults that use a variable cannot be shared.
You cannot use shared inline defaults between users.
Inline defaults that use expressions cannot be shared.
constant_value must be a constant literal.
Inline defaults that are defined in syscomments as requiring more than one row (that is, more than 255 bytes) cannot be shared.
Shareable inline defaults that exist on an Adaptive Server you are downgrading are treated as if they were created with the create default command from the previous release. These defaults are fully functional with the sp_binddefault, sp_unbindefault and drop default commands using the internal default names.
