I need to run a query (such as SELECT * FROM <tablename> WHERE <something> = 'ENABLED') to list nodes and their "replstate" status.... But I don't find "REPLSTATE" as a column in the NODES table.
And I don't see a column name that seems related. Q REPLNODE * returns multiple rows for each node; but REPLNODE is not a table. Does anyone know where the replication status is stored? Thanks. ------------------------------------------------------------ Harold Vandeventer Systems Programmer State of Kansas - Office of Information Technology Services STE 751-S 910 SW Jackson (785) 296-0631 [Confidentiality notice:] *********************************************************************** This e-mail message, including attachments, if any, is intended for the person or entity to which it is addressed and may contain confidential or privileged information. Any unauthorized review, use, or disclosure is prohibited. If you are not the intended recipient, please contact the sender and destroy the original message, including all copies, Thank you. ***********************************************************************
