New and changed Transact-SQL commands

Table 4-4 summarizes the new Transact-SQL commands in version 12.5.0.1.

Table 4-4: New commands

Command

Description

grant dbcc

Allows the System Administrator to grant access on certain dbcc commands.

revoke dbcc

Allows the System Administrator to revoke access on some dbcc commands.

Table 4-5 summarizes the changes to existing Transact-SQL commands in version 12.5.0.1.

Table 4-5: Changed commands

Command

Change

insert

You can use the insert command to create a new file directory. To do so, use only the filename, filetype, and content columns. Specify “DIR” as the filetype, to create filename as a directory.