March 22, 2012 at 3:11 pm
Can some one help me out in educating what does status = 25 or 17 mean in sysarticles on publication database. What does that indicate ?
Any clue ?
March 22, 2012 at 3:14 pm
AK1516 (3/22/2012)
Can some one help me out in educating what does status = 25 or 17 mean in sysarticles on publication database. What does that indicate ?Any clue ?
http://msdn.microsoft.com/en-us/library/ms187723.aspx
The bitmask of the article options and status, which can be the bitwise logical OR result of one or more of these values:
1 = Article is active.
8 = Include the column name in INSERT statements.
16 = Use parameterized statements.
24 = Both include the column name in INSERT statements and use parameterized statements.
64 = Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
For example, an active article using parameterized statements would have a value of 17 in this column. A value of 0 means that the article is inactive and no additional properties are defined.
March 22, 2012 at 3:14 pm
From Books Online:
status
tinyint
The bitmask of the article options and status, which can be the bitwise logical OR result of one or more of these values:
1 = Article is active.
8 = Include the column name in INSERT statements.
16 = Use parameterized statements.
24 = Both include the column name in INSERT statements and use parameterized statements.
For example, an active article using parameterized statements would have a value of 17 in this column. A value of 0 means that the article is inactive and no additional properties are defined.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply