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 ...

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.

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.