Having a firm understanding of the SQL Server databases is beneficial when you need to troubleshoot an issue, gather data from SQL Server, etc.This tip will outline the SQL Server system databases, explain the core objects used in the relational databases and outline some do's and don'ts when working with the system databases.
Is there a way to disable this message, or is there another way for checking, if a table exists?
With @supports_net_changes parameter you can enable support for querying for net changes.
0000/01/04 .68 server Can't allocate space for object 'syslogs' in database 'DBbad' because 'logsegment' segment is full/has no free extents.
You can verify if the database that is enabled for CDC is not by looking at the fixed database role, you can enable CDC for the required table (a capture instance) using the sys.sp_cdc_enable_table system stored procedure.
When CDC is enabled for a table, a CDC table (table which keeps track of history of changes along with meta-data about changes) and two table-valued functions are generated along with capture and cleanup jobs for the database if this is the first table in the database to be enabled for CDC.