Create a database-level DDL trigger to move the object to the new schema. I’ve created this trigger that will transfer an object to ‘dbo’ once it’s created.

Let’s see… In SQL Server 2000, if Fred created a table called “Mytable” in the “Pubs” database on the “Usaserver”, the fully qualified name would be Usaserver.Pubs.Fred.Mytable.

Set (SYSTEM_VERSIONING = ON (HISTORY_TABLE = dbo.SalesOrderHistorical)); Once you've created a temporal table, it does have some restrictions. Some things are taken care of for you: If you alter the ...