create default Restrictions

You can create a default only in the current database.

You cannot combine create default statements with other statements in a single batch.

You must drop a default using drop default before you create a new one of the same name; you must unbind a default using sp_unbindefault, before you drop it.