In addition to the commands already documented, (alter database, load database, online database, drop database and load tran) the following SQL commands are allowed 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 checkpoint an archive database automatically.
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.
