hi i needed to reinitialize my subscription and by mistake i clicked on Use New Snapshot, mark for reinitialization, what i want to do is renitialization and run snapshot now, how can i unmark this subscription so it doesn't run at 1am when i have scheduled my snapshots to run?
WOULD IT BE :
Updating the status column in distribution.dbo.MSsubscriptions table to 2 for this subscription?
Status of the subscription:
0 = Inactive
1 = Subscribed
2 = Active