rs_funcstrings

Stores the function strings associated with each function.

Column

Datatype

Description

prsid

int

Site where this row is primary

classid

rs_id

Class the function string belongs to

funcid

rs_id

Function this string is for

name

varchar(255)

Function string name

fstringid

rs_id

ID for this function string

attributes

smallint

Attributes of the function string:

  • 0x01 – conflicting function

  • 0x02 – RPC

  • 0x04 - altered

  • 0x08 – used for all functions other than rs_writetext and indicates that a function has no output command and that nothing is sent to the replicate data server.

  • 0x10 – default input

  • 0x20 – default output

  • 0x40 – writetext output is used for an rs_writetext function string

  • 0x80 – writetext output is used with the with log option for an rs_writetext function string

  • 0x100 – a function string for an rs_writetext, rs_textptr_init, or rs_get_textptr function

  • 0x200 – writetext output is used with the no log option for an rs_writetext function string

  • 0x400 – function string includes one or more variables that will access the values of non-key columns

  • 0x800 – the rs_default_fs system variable was used in output language template

  • 0x1000 – none output is used for an rs_writetext function string

parameters

smallint

Number of parameters in this function string

param_hash

int

Hash value of input template

expiredate

datetime

Date the function string should expire. This is used for dynamic function string expiration

rowtype

tinyint

1 if this row is replicated, 0 if not

minvers

int

Minimum version required to support the function string. This means that if a function string has minvers value of 15.0, it will not replicate to sites below 15.0

Indexes

  • Unique clustered index on (classid, funcid, name)

  • Unique index on (fstringid)

  • Non-unique index on (funcid)