Assert verifies that database object exists. Fail when object with a given name has not been found in the database.

Arguments

  • v_ObjectName – database object name, SYSNAME
  • v_UserMessage – message to report when assertion fails, NVARCHAR(MAX)

 

Examples

SQL Server 

EXEC DBTD_ASSERT_OBJECT_EXISTS 'MyDatabase.MySchema.sp_MyStoredProcedure', 'cannot find database object';

 
See Also