How to check if SQL Server 2008R2 merge pull subscription is set to reinitialize?

I am using RMO and some T-SQL to manage my subscriptions and have a need to know if a subscription has been set to reinitialize on next sync.

Solution

As far as I know, you can query the table sysmergesubscriptions on the server and check the column sentgen for your subscriber. If it is NULL, it has been marked for reinitialization.

Difference between @@ and @ in SQL Server 2008 R2
Select query to remove non-numeric characters
Create a Range From n to 1 in SQL
Drop column if exists in SQL Server 2008 r2
A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233)
SQL Server - Create a copy of a database table and place it in the same database?
Check if external database is online
Error restore backup SQLSERVER 2008R2 to SQLSERVER 2008
SQL Server convert date to String MMMYYDD
How to permit a SQL Server user to insert/update/delete data, but not alter schema?
Stored Procedure not showing fields in Crystal reports
CTE (Common Table Expression) vs Temp tables or Table variables, which is faster?
Scripting Log Shipping Automation
Merge insert with select statement
Laravel - Implicit conversion from data type nvarchar to varbinary is not allowed
Connecting to MS SQL Server with Windows Authentication using Python?
Get every hour for a time range
"Adding a value to a 'datetime' column caused an overflow."
How to return default value from SQL query
Convert VARCHAR to SMALLDATETIME as part of UPDATE statement
Return total records from SQL Server when using ROW_NUMBER
Stored procedure for auto generating roll no?
How to find databases which accessible to me in Sql server?
Updating and join on multiple rows, which row's value is used?
How do I add the description property to the table designer view in SSMS?
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated
Accent insensitive search using EF6 and SQL Server 2008 R2 - Czech language
Count just working days (exclude weekends and public holidays) and add filter that a query
Subtract one column from another and get running total SQL Server 2008 R2
How to get the name of a the student who got max marks in each subject?