In addition to the commands already documented, (alter database, load database, online database, drop database and load tran) you can use these SQL commands in an archive database:
use
select
select into – where the target database is not an archive database.
Cursor operations that perform reads, including:
declare cursor
deallocate cursor
open
fetch
You cannot use an updatable cursor.
checkpoint – is a supported command. However, the checkpoint process does not automatically checkpoint an archive database.
execute – is allowed as long as any statements that reference the archive database are allowed within the archive database. A transaction inside or outside a stored procedure is not permitted with an execute command.
lock table
readtext
DML commands including insert, update,
and delete are not permitted, and you cannot
start user transactions.
