|
Name |
abarepltoagcmds |
|
Code |
ap_rac |
|
Creation Date |
20 mars 2017 14:04:14 |
|
Modification Date |
20 mars 2017 14:09:11 |
|
Comment |
Commands saved to be replicated in an AG. |
|
This table comes into play when there are objects that needs permission on server level (through the $SERVERPERM directive or privileged assemblies), and the database is part of an availability group. All commands executed on server level are saved here and at the end of the AbaPerls operation, they are executed on the other servers in the AG.
The table normally only has data while an AbaPerls operation is running as data is deleted once it had been used. |
|
|
|
Data |
NOT |
F |
|
|
session_id |
|
int |
X |
|
Session key, typically @@spid. |
|
cmdno |
|
smallint |
X |
|
Running number. |
|
cmdtext |
|
nvarchar(MAX) |
X |
|
The command to run. |
|
Name |
Columns |
Options |
PK |
|
pk_ap_rac |
session_id, cmdno | clustered |
X |
|
|
|