November 10, 2016 at 1:06 am
Hi,
I have the following tables and sp's in a database and wondering if they are part of any kind of replication or any other thing.
Could someone please help me clarify?
/*
TableName
MS_MessageQueues
MS_Messages
MS_MessageWaitingNotifications
MS_NamedSearches
MS_ResponseReceived
MS_sp_ChangeAccountNumber
MS_ThreadCategories
MS_Threads
MS_ThreadStatuses
ProcedureName
ObjectName
sp_MS_DeleteMessage
sp_MS_DeleteMessageQueue
sp_MS_DeleteNamedSearch
sp_MS_DeleteThread
sp_MS_DeleteThreadCategory
sp_MS_DeleteThreadStatus
sp_MS_InsertMessageQueue
sp_MS_InsertNamedSearch
sp_MS_InsertThread
sp_MS_InsertThreadCategory
sp_MS_InsertThreadStatus
sp_MS_MarkMessageWaitingNotified
sp_MS_MarkResponseReceived
sp_MS_MarkResponseReceivedNotified
sp_MS_Report_MessageQueue
sp_MS_SearchMessage
sp_MS_SearchMessageQueue
sp_MS_SearchMessageQueues
sp_MS_SearchThread
sp_MS_SelectMessage
sp_MS_SelectMessageQueue
sp_MS_SelectMessageQueueByUserID
sp_MS_SelectMessagesByDestinationQueue
sp_MS_SelectMessagesBySourceQueue
sp_MS_SelectMessagesByThread
sp_MS_SelectMessageWaitingNotificationMessages
sp_MS_SelectNamedSearch
sp_MS_SelectResponseReceivedNotificationMessages
sp_MS_SelectThread
sp_MS_SelectThreadCategory
sp_MS_SelectThreadCategoryByName
sp_MS_SelectThreadStatus
sp_MS_SelectThreadStatusByName
sp_MS_SendMessage
sp_MS_UnmarkMessageWaitingNotified
sp_MS_UnmarkResponseReceived
sp_MS_UpdateMessage
sp_MS_UpdateMessageQueue
sp_MS_UpdateNamedSearch
sp_MS_UpdateThread
sp_MS_UpdateThreadCategory
sp_MS_UpdateThreadStatus
*/
Thanks,
Santhosh
November 10, 2016 at 11:37 am
I'm not sure about stored procs, but this should get you started in determining which tables are replicated:
SELECT NAME, is_replicated, is_published
FROM SYS.TABLES
WHERE
TYPE = 'U'
AND (IS_REPLICATED = 1
OR is_published = 1)
ORDER BY name
Run this on whichever database you're wondering about. If is_replicated = 0 and is_published = 1, those are usually snapshot replications (as opposed to transactional).
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply